Overview
Skills
Job Details
Data Modeler Architect / Full-Time / Hybrid / Harrisburg, PA
Become a member of a growing team of Information Technology professionals making an impact and providing solutions for Government and Commercial clients since 1996 Join the Domino Tech Team!
Accepting Candidates Until 09/05/2025 at 2:00 PM
The Position:
Client: Commonwealth of Pennsylvania Department Of Health (DOH)
Position Title: DOH - Microsoft Applications Developer Architect AR1 (775849)
Location: Hybrid; Remote Off-Site and On-Site in Harrisburg, PA
Duration: Initial term through 06/30/2026 (+ Annual Renewal in 1-Year Terms)
Note: The position is hybrid; primarily remote off-site, and minimum one day per month on-site or as required. Candidates must currently reside in Pennsylvania within a reasonable commuting distance (2-hour/100-miles) to Harrisburg, PA.
The primary objective of this engagement is for the selected candidate to serve as the Data Modeler / Data Architect for the EDW, supporting the analysis and reporting needs of the DOH and DDAP, the existing EDW, as well as the design and construction of the new EDW in Azure. 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.
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.
The selected candidate must adhere to the following operational requirements;
- Manage assignments and track progress against agreed upon timelines.
- Plan, organize, prioritize, and manage work efforts, coordinating with the EDW and other teams.
- Participate in status reviews, process reviews, deliverable reviews, and software quality assurance work product reviews with the appropriate stakeholders.
- Participate in business and technical requirements gathering.
- Participate in testing of implemented solution(s).
- Build and maintain relationships with key stakeholders and customer representatives.
- Give presentations for the EDW, other DOH offices, and agencies involved with this project.
- Develops and maintains processes and procedural documentation.
- Complete weekly project status updates in Daptiv when necessary.
- Provide weekly personal status reporting by COB Friday submitted on SharePoint.
- Publish and present design reports, maintain documentation on project SharePoint sites.
The Skills and Experience:
- 10+ Years: Data Modeler experience
- 5+ Years: Experience with logical and physical data modeling, including use of tools like ErWin, or similar
- 5+ Years: Experience managing metadata, data dictionaries and technical documentation
- 5+ Years: Strong proficiency with SQL Server, T-SQL, SSIS, stored procedures, ELT processes, scripts, and complex queries
- 5+ Years: Working knowledge of Azure Databricks, Delta Lake, Synapse and Python
- 5+ Years: Experience with Azure DevOps and Agile / Scrum development methods
- 5+ Years: Auditing databases to maintain quality and creating systems to keep data secure
- Experience working in the public health or healthcare industry with various health applications and data is a plus
- 4-Year College Degree is a plus
The Company:
The mission of Domino Technologies, Inc. is to provide clients with IT solutions for their individual business processes that lead to strategic market advantages. Since its founding in 1996, the Domino Tech Team has built a solid record of performance working with clients in the Government and Commercial sectors.
The Perks:
- Excellent Market Salary
- Competitive Benefits
- Paid Holidays and Vacation
- Positive Work-Life Balance
The Location:
Domino Technologies is based in the Harrisburg area the capital city of the Commonwealth of Pennsylvania and the county seat of Dauphin County. Located on the east bank of the Susquehanna River, Harrisburg is the anchor of the Susquehanna Valley metropolitan area.
Contact Us Today!