Overview
Skills
Job Details
Our direct client is looking for a Data Modeler - EDW, Azure for a 95% Remote Contract (Client in Harrisburg, PA).
NOTE:
- This will be a 10-month engagement beginning in September 2025
- The contractor must reside in PA, and will be permitted to work from home. Office space for the contractor will be provided as needed.
- The contractor is expected to be in the office at least '1' day per month, subject to additional days in office at Manager discretion.
- In addition, DOH will supply all necessary hardware and software for daily use that are needed to complete assigned work items.
OBJECTIVES OF ENGAGEMENT
- The primary objective of this engagement is for the selected candidate to serve as the Data Modeler / Data Architect, to provide technical services to the DOH and EDW for data warehouse modernization. The selected candidate will serve as a data architect, modeler, and administrator for the EDW, supporting the analysis and reporting needs of the DOH and DDAP, as well as the design and construction of the new EDW in Azure.
- This position s scope includes the modernization of DOH operations; plan, coordinate and respond to data reporting needs, set standards and define framework; assist with large volume data processing, statistical analysis of large datasets; revamping the EDW into Microsoft s Azure Cloud utilizing Azure Databricks, Delta Lake and Synapse, including compute, storage and application fabric, as well as services for infrastructure as a service (IaaS), platform as a service (PaaS), software as a service (SaaS) and serverless technologies; create a centralized data model; support for DOH projects like ELC Enhanced Detection Expansion, Data Modernization Initiative, PA NEDSS NextGen, PA LIMS Replacement, Reporting Hub, Verato UMPI, COVID-19 response, and onboarding additional DOH systems into the EDW.
OPERATIONAL REQUIREMENTS
- The Data Modeler / Data Architect is a senior level resource with specialized knowledge and experience in data analysis, data modeling and database design. The selected contractor must have proven and demonstrated experience in the development, validation, publishing, and maintenance of data designs, logical and physical data models, data dictionaries, and metadata repositories.
- The selected contractor will collaborate with EDW team members and DOH program area stakeholders to develop and implement solutions that meet the requirements for using the data. This position will be expected to develop and implement data analysis methodologies, validate business use cases for accuracy and completeness of proposed data models, and work with business analysts, application developers, and DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, and program area customer satisfaction objectives.
REQUIRED SKILLS:
- Data Modeler can design, develop, and implement data models and data lake architecture to provide reliable and scalable applications and systems to meet the organization s objectives and requirements. The Data Modeler is familiar with a variety of database technologies, environments, concepts, methodologies, practices, and procedures.
- Demonstrable, advanced experience with data profiling, analysis and design, developing and documenting information domain models, data structures, objects, attributes, relationships, and integrity rules
- Experience with logical and physical data modeling, including use of tools like ErWin, or similar.
- Experience managing metadata, data dictionaries and technical documentation
- Experience with analyzing and translating business requirements and use cases into optimized models, data flows, and developing database solutions
- Experience with and knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology
- Strong proficiency with SQL Server, T-SQL, SSIS, stored procedures, ELT processes, scripts, and complex queries
- Working knowledge of Azure Databricks, Delta Lake, Synapse and Python
- Experience with evaluating implemented data systems for variances, discrepancies, and efficiency
- Experience with Azure DevOps and Agile / Scrum development methods
- Auditing databases to maintain quality and creating systems to keep data secure
- Demonstrable ability to communicate and document clearly and concisely
- Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision
- Ability to work collaboratively and effectively with colleagues, and as a member of a team
- Ability to present complex technical concepts and data to a varied audience effectively.
- More than 10 years of relevant experience
SKILL MATRIX:
- Experience with logical and physical data modeling, including use of tools like ErWin, or similar. - Required
- Experience managing metadata, data dictionaries and technical documentation - Required
- Strong proficiency with SQL Server, T-SQL, SSIS, stored procedures, ELT processes, scripts, and complex queries - Required
- Working knowledge of Azure Databricks, Delta Lake, Synapse and Python - Required
- Experience with Azure DevOps and Agile / Scrum development methods - Required
- Auditing databases to maintain quality and creating systems to keep data secure - Required
- Experience working in the public health or healthcare industry with various health data sets. - Nice to have
- 4-year college degree in computer science or related field with advanced study preferred. - Nice to have
Question 1: The candidate must reside in PA. Where does your candidate currently reside?
Question 2: Does candidate possess more than '10' years of relevant Data Modeler experience ?
Question 3: The candidate must be able to work '1 day a month on-site (but subject to additional days at Manager discretion). Are you fine with this?
Location: 95% Remote (Client in Harrisburg, PA)
Type: Contract
Please send resume to "jobs at etechnovision dot com" with B4001B in Subject for immediate consideration.