Qureos Mentor

S R International Inc

<div>Position Overview: 
The Commonwealth of Pennsylvania Department of Health (DOH) is seeking a seasoned Data Modeler / Data Architect to support their Data Warehouse (EDW) modernization initiative. The successful candidate will provide technical services to the DOH and EDW teams, leading the design, development, and implementation of data models for a new, cloud-based EDW system utilizing Microsoft Azure. This role includes large-scale data processing, analysis, and modeling in the context of public health projects, such as the COVID-19 response, healthcare systems modernization, and more. 
 
Key Responsibilities: 
<ul><li>Serve as the lead Data Modeler and Data Architect for the modernization of the Department of Health&rsquo;s EDW system in Azure.</li><li>Design, develop, and implement logical and physical data models, including metadata, data dictionaries, and technical documentation.</li><li>Collaborate with cross-functional teams, including business analysts, application developers, and DBAs, to ensure the EDW meets technical and business requirements.</li><li>Assist in data profiling, statistical analysis, and the design of efficient, scalable data solutions for large datasets.</li><li>Lead the migration of legacy data to Microsoft Azure using tools like Azure Databricks, Delta Lake, and Synapse.</li><li>Provide expert guidance on data analysis methodologies, ensuring accuracy and completeness of proposed data models.</li><li>Manage and ensure compliance with all federal and state standards for data management.</li><li>Facilitate knowledge transfer sessions and ensure stakeholders understand data models and their use.</li><li>Support ongoing business and technical requirements gathering, testing, and project status reporting.</li></ul>
 
Required Skills &amp; Experience: 
<ul><li>10+ years of relevant Data Modeling and Data Architecture experience.</li><li>Proficient in SQL Server, T-SQL, SSIS, stored procedures, ELT processes, and complex queries.</li><li>Hands-on experience with Azure Databricks, Delta Lake, Synapse, and Python.</li><li>Expertise in logical and physical data modeling, and use of tools like ErWin or similar.</li><li>Strong background in data profiling, analysis, and the development of data solutions based on business requirements.</li><li>Experience with metadata management, data dictionaries, and technical documentation.</li><li>Knowledge of Azure DevOps and experience working within Agile/Scrum frameworks.</li><li>Solid understanding of data warehousing, star schema, fact and dimension models, and entity-relationship design.</li><li>Ability to work independently with minimal supervision while balancing multiple projects.</li><li>Excellent communication skills with the ability to present complex technical concepts to diverse audiences.</li></ul></div>

Data Modeler / Data Architect

<div>Job Title: Azure Data Warehouse Developer 
Job Code: PA 775864 
Client: Commonwealth of PA 
Location: Dauphin County, PA (Local Only &ndash; Mostly Remote) 
Contract Duration: 10 Months 
 
Position Overview: 
 
The Commonwealth of Pennsylvania is seeking an Azure Data Warehouse Developer to support a Data Modernization Initiative for the Department of Health (DOH). This role will focus on modernizing the state&rsquo;s Enterprise Data Warehouse (EDW) to enable advanced data analysis, improve public health surveillance, and provide reliable, real-time data for critical decision-making. 
 
This position is primarily remote but requires Pennsylvania residency and 1 day/month onsite (subject to additional days at manager&rsquo;s discretion). 
 
Key Responsibilities: 
 
<ul><li>Design, develop, and maintain data lakes, ELT pipelines, and databases in Azure using Databricks, Delta Lake, Synapse, and Data Factory. 
</li><li>Build robust ETL/ELT processes and optimize large-scale data processing for analytics and reporting. 
</li><li>Act as an Azure DevOps CI/CD Pipeline Release Manager &ndash; implementing and maintaining scalable pipelines. 
</li>Collaborate with business analysts, developers, DBAs, and system teams to deliver enterprise data solutions. 
<li>
</li>Support modernization of DOH&rsquo;s EDW to enable centralized, state-of-the-art data capabilities. 
<li>
</li>Develop technical documentation, participate in peer code reviews, and ensure compliance with SDLC best practices. 
<li>
</li><li>Provide knowledge transfer, training, and documentation to internal teams.</li> 
</ul>
 
 
Required Skills &amp; Experience: 
<ul>
<li>5+ years hands-on experience with Azure, Azure Databricks, Delta Lake, Data Factory, Pipelines, Apache Spark, and Python. 
</li><li>Expertise in SQL Server, T-SQL, Azure Synapse, and ETL/ELT development (SSIS or similar). 
</li><li>Experience as an Azure DevOps CI/CD Pipeline Release Manager. 
</li><li>Strong background in data engineering, data mining, modeling, cleansing, and analytics-as-a-service. 
</li><li>Advanced knowledge of relational and dimensional data models (Star Schema, Facts, Dimensions). 
</li>Excellent communication skills and ability to work independently across multiple projects. 
<li>
</li><li>Bachelor&rsquo;s degree in Computer Science or related field (advanced degree preferred).</li> 
</ul>
 
 
Preferred Experience: 
<ul><li>
Public health or healthcare industry experience with health data sets.</li></ul> 
 
 
Additional Requirements: 
<ul>
<li>Must reside in Pennsylvania. 
</li><li>Must comply with no use of government equipment outside the U.S. (violation results in termination and program ineligibility).</li></ul> 
 
 
Flexible work from home options available.</div>

Azure Data Warehouse Developer

Join S R International Inc and explore 2   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

S R International Inc

ABOUT_COMPANY

Data Modeler / Data Architect

Azure Data Warehouse Developer