Job Description

Title: Data Modeler

Location: Harrisburg, PA (once a month onsite) Candidate must be located in Pennsylvania

Active LinkedIn with 2 references & valid docs.

Note:
Need locals only (PA) with local PA projects

Need public health or healthcare industry with various health applications and data.

Submit at lowest possible rate

Job Description:

Objectives of Engagement

The primary objective is to engage a Data Modeler / Data Architect to provide technical services for the Department of Health (DOH) and Enterprise Data Warehouse (EDW) modernization. The selected candidate will serve as data architect, modeler, and administrator for the EDW, supporting the analysis and reporting needs of DOH and DDAP, as well as the design and construction of a new EDW in Azure.

Key responsibilities include:

• Modernizing DOH operations.
• Planning, coordinating, and addressing evolving data reporting needs.
• Setting standards and defining frameworks for data management.
• Supporting large-scale data processing and statistical analysis of large datasets.
• Migrating and transforming the EDW on Microsoft Azure Cloud, leveraging Azure Databricks, Delta Lake, and Synapse (compute, storage, application fabric, IaaS, PaaS, SaaS, and serverless technologies).
• Creating a centralized data model.
• Supporting DOH projects such as ELC Enhanced Detection Expansion, Data Modernization Initiative, PA NEDSS NextGen, PA LIMS Replacement, Reporting Hub, Verato UMPI, COVID-19 response, and onboarding new DOH systems into the EDW.

________________________________________

Operational Requirements

• The Data Modeler / Data Architect role is senior-level, requiring specialized expertise in data analysis, modeling, and database design. The contractor must demonstrate experience in:
• Development, validation, publication, and maintenance of data designs, logical and physical data models, data dictionaries, and metadata repositories.
• Collaboration with EDW teams and DOH stakeholders to deliver solutions that address technical and business requirements.
• Developing and implementing data analysis methodologies and validating business use cases.
• Working closely with business analysts, application developers, and DBAs to meet project objectives, including delivery deadlines, cost, quality, and customer satisfaction.

________________________________________

Required Skills & Experience

Advanced experience in data profiling, analysis, and design, including information domain models, data structures, and integrity rules.

Expertise in logical and physical data modeling, with tools like ErWin or similar.

Experience managing metadata, data dictionaries, and technical documentation.

Ability to analyze and translate business requirements into optimized data models, flows, and database solutions.

In-depth knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts.

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 evaluating data systems for discrepancies and efficiency.

Ability to audit databases and implement systems to maintain data quality and security.

Experience using Azure DevOps and Agile/Scrum methodologies.

Strong communication and documentation skills.

Ability to manage multiple projects independently, with strong organizational skills.

Excellent teamwork and relationship-building.

Capable of explaining complex technical concepts and data to various audiences.

10+ years of relevant experience.

Bachelor's degree in computer science or related field (advanced study preferred).

________________________________________

Preferred Experience

Experience working in public health or healthcare, with exposure to health data sets.

________________________________________

Engagement Details

Duration: 10 months, beginning September 2025.

Location: Candidate must be resident in Pennsylvania. Work-from-home is permitted; office space provided as needed. On-site work required at least one day per month, with more days possible at management discretion.

Equipment: DOH will supply all necessary hardware and software.

Job Tags

Similar Jobs