Azure Data Warehouse Developer Architect / Full-Time / Hybrid / Harrisburg, PA

Azure Data Warehouse Developer 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 - Azure Data Warehouse Developer Architect AR1 (775864)
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.

Azure DW Developer Architect position will support both the existing business and reporting requirements of individual DOH / DDAP systems and program areas, and the construction of a modern data warehouse that will serve DOH / DDAP from an enterprise perspective. The primary objective of this engagement is for the selected candidate to serve as the Azure DW Developer Architect supporting the analysis and reporting needs of the DOH / DDAP, and the design and construction of a modern EDW in Azure. The Architect is a senior level resource with advanced, specialized knowledge and experience in data warehousing, database, and programming concepts and technology. The selected contractor must have proven experience in the development, maintenance, testing, and maintenance of Azure production systems and projects. This position designs, develops, tests, and implements data lakes, databases, extract-load-transform programs, applications, and reports. This position will work with business analysts, application developers, DBAs, network, and system staff 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:
- 5+ Years: Azura Data Warehouse Developer experience
- 5+ Years: Technical experience and expertise with Azure, Azure Delta Lake, Azure Databricks, Azure Data Factory, Pipelines, Apache Spark, and Python
- 5+ Years: Design, implementation, and maintenance of business intelligence and data warehouse solutions, with expertise in using SQL Server Azure Synapse
- 5+ Years: Experience producing ETL/ELT using SQL Server Integration Services and other tools
- 5+ Years: Experience with SQL Server, T-SQL, scripts, queries
- 5+ Years: Experience as an Azure DevOps CI/CD Pipeline Release Manager who can design, implement, and maintain robust and scalable CI/CD pipelines
- 5+ Years: Experience with data formatting, capture, search, retrieval, extraction, classification, quality control, cleansing, and information filtering
- 5+ Years: Experience with data engineering, database file systems optimization, APIs, and analytics as a service
- 5+ Years: Experience with data mining architecture, modeling standards, reporting and data analysis methodologies
- 4-Year College Degree

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!