Senior Data Engineer (Hybrid)
Location: Durham, NC
Duration: 12 Month Job Description:
The client is seeking a Senior Data Engineer to lead the development and optimization of end-to-end solutions using Microsoft Azure Synapse Analytics, ensuring data accessibility, performance, and security for the Child Welfare Program. The Department of Health and Human Services (DHHS) requires the assistance of a contract resource to serve as a Senior Synapse Data Engineer. The primary purpose of this position is to lead the development and optimization of our data pipelines, analytics solutions, and cloud-based data platforms. This role will be instrumental in designing and implementing end-to-end data engineering solutions using Microsoft Azure Synapse Analytics to meet child welfare business needs. Key Responsibilities:
Synapse
- Design, Develop and maintain data models in Synapse to support reporting and analytics
- Develop ETL solutions using Azure Synapse Analytics Pipelines and dedicated SQL pools for extraction, transformation and aggregation from Salesforce objects.
- Analyze the source system and design the ETL data load.
- Ability to create and configure Azure Synapse Analytics workspace.
- Create pipelines in Azure Synapse using Linked Services/Datasets/Pipeline to Extract, Transform and Load data from different sources like SalesForce.
- Perform needed monitoring, troubleshooting, and maintenance of the data architecture and pipelines.
- Collaborate with data engineers, analysts, and stakeholders to gather requirements, design visualizations, and provide training to use self-service BI Tools.
| Skill | Required/Desired | Amount | of Experience |
| Experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows | Required | 5 | Years |
| Programming Languages: Strong proficiency in Python or Scala for data processing. | Required | 3 | Years |
| SQL Mastery: Advanced query writing, performance tuning, and optimization. | Required | 7 | Years |
| Experience with Data Modeling and Warehousing (star schema, snowflake schema) | Required | 4 | Years |
| Experience with ETL/ELT processes | Required | 5 | Years |
| Experience with Azure Data Platform (Azure Data Factory, Azure Data Lake, and Azure SQL Database) | Highly desired | 4 | Years |
| Familiarity with Event Hubs, Azure Stream Analytics, and Azure Functions | Desired | 4 | Years |
| Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) | Desired | 1 | Years |
| Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage | Desired | 5 | Years |
| Experience with Power BI | Nice to have | 1 | Years |
Recommended Jobs
Full Stack Engineer
At INflow Federal, we're not just navigating the frontier of digital transformation; we're reshaping it. Our dedication to merging the prowess of humans and machines to solve complex problems has set…
Senior Educational Design Specialist
Job Description Job Description The Senior Educational Design Specialist is a professional with knowledge of and experience with learning and organizational development (LOD) principles, practi…
Patient Insurance Navigator
Overview Responsible for verification of patient eligibility, the pre-certification of services as required, ensuring coverages are updated, validating authorizations already on file, and providin…
Data Scientist II
Pay Rate: $60 - $65/Hour Overview: We’re looking for a People Data Scientist contractor to join the People Insights & Analytics (PIA) team. PIA is a team of analytics experts, …
Data Engineer, Incident response
The application window is expected to close on: October 16th, 2025 NOTE: Job posting may be removed earlier if the position is filled or if a sufficient number of applications are received. …
Lead Medical Lab Scientist
Introduction Are you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as …
Customer Marketing Manager
Are you looking for a high energy, strategic, and fast-paced position as a Channel Engagement Manager (Partner Marketing)? Join Relias, the company changing lives throughout the world by helping…
Industrial Automation Sales Manager
We’re partnering with a global leader in power and thermal management solutions. Our client is shaping the future of energy and automation through advanced manufacturing technology, smart infrastruct…
Sheetmetal Mechanics
Job Description Job Description About the Job: HM Staffing Solutions is looking for experienced and detail-oriented Sheet Metal Mechanics to join our team. You'll be responsible for fabricat…
Designer Sales Manager Charlotte, NC
What are we looking for At Cosentino ( we are looking for a Designer Sales Manager located in Charlotte, NC , who will have the opportunity to work in a multinational environment, in full ex…