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:
________________________________________
Operational Requirements
________________________________________
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.
...Position Overview Role: American Sign Language (ASL) Interpreter Employment Type: Independent Contractor (As-needed basis) Client: Department of Defense Agency Purpose: Provide interpreting services for deaf and hard of hearing employees and applicants...
...is responsible for assisting the day-to-day operations of LCIs legal and legislative programs. At a high level, the incumbent both assists... ..., work-life-balance, and for many positions, flexible hours and remote work options. The State of California offers a competitive and...
...exceeding expectations, ensuring impactful results for our clients and communities. Position: Data / Information Architect Navy Data Model | MDM | Ontology About the Role: As a Data / Information Architect at Navaide, you will shape the foundation of secure,...
About OppyGrow our tomorrow.Oppy is a leading grower, marketer, and distributor of fresh produce from around the world. As one of North Americas top produce companies for nearly 165 years, we bring over 100 varieties of produce from 27 countries to 1,300+ retailers in...
...What youll need to succeed as a Truck Driver at XPO Minimum qualifications: Be at least 21 years of age Valid Class A commercial driver's license Safe driving record and history Currently possess or be willing to obtain hazardous materials, tank vehicle...