Data Modeler (only locals, hybrid, in-person interview)-Harrisburg, PA

4 views

Skip to first unread message

Harisha Katanguri

unread,

Aug 28, 2025, 11:29:49 AM8/28/25

to Harisha Katanguri

Client is Commonwealth of PA

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

No OPT/CPT

Title: Data Modeler
Location: Harrisburg, PA (once a month onsite)
Duration: Contract 12 months

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.

Thanks and Best Regards,

Harisha Katanguri

InfoPeople Corporation

450 Seventh Avenue, Suite 1106

New York, NY 10123

Direct: (646) 790-8258
Email: har...@infopeoplecorp.com

Website : www.infopeoplecorp.com

NYC DOITT ITCS Contractor

NYS OGS PBITS Contractor

GSA Schedule 70 Contractor

NYC & NYS Certified Minority Business

The Port Authority of NY &NJ Certified Minority Business

National Minority Supplier Development Council Certified Minority Business

SBA SDB Certified Business

This e-mail is property of InfoPeople Corporation. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail or the information contained herein by anyone other than the intended recipient is prohibited. If you have received this e-mail in error, please immediately notify us by replying to this email and destroy all electronic and paper copies of this e-mail.

“Every accomplishment starts with the decision to try. Either you will find a way, or you will make one”