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
Live Operations Intern - Summer 2026
Perdue Foods has a goal of becoming the most trusted name in premium proteins by creating products for consumers and for retail and foodservice customers around the globe while changing the way anima…
Machine Build Technician
Job Description Job Description C.R. Onsrud, Inc. – Troutman, NC Position: Machine Build Technician Compensation & Benefits: ~ Pay: Competitive rates, depending on experience ~ Benefits…
Global Financial Crimes Manager - FIU Detection & US Transaction Monitoring
At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our …
Full time or Part Time Shift Leader
Job Description Job Description Carolina Juice Company is growing! We are now hiring Full-Time or Part-Time Shift Leaders. Flexible Schedules available, our store is open from 8:00am-6:00pm Mon…
Travel Speech-Language Pathologist (SLP) Skilled Nursing
TRAVEL (SLP) SPEECH LANGUAGE PATHOLOGIST - Travel/Local Contract (SLP/CCC) opportunity in a Skilled Nursing Facility setting (SNF) Fayetteville, NC. $2000 Weekly Net Take-home Pay! QUALIFICATIONS…
CT Tech Job in Cornelius, NC
Job Description Job Description Degree in Radiologic Technology, Certification in Radiologic Technology (ARRT Certification), and minimum 1+ years CT Tech experience required. Applicants who do n…
Hydraulic Project Manager - Civil Engineering
Pay: $100,000.00 - $150,000.00 per year Job description: Note: This position requires employees to be on-site five days a week at our clients Charlotte, NC office. Note: The qualified cand…
PROfessional House Cleaner - $250 Sign On Bonus!!
Job Description Job Description Pay Range: $410 - 780 a week Why work at MaidPro?A culture of kindness, appreciation, and a sense of belonging are just some of the great things you can expect …
Food Runner
Heist Brewery in Charlotte, NC is looking for one food runner to join our 83 person strong team. We are located on 1030 Woodward Ave Charlotte NC 28206. Our ideal candidate is attentive, motivated, a…
Delivery Driver - CDL Class A/B
Are you tired of being on the road for days or weeks at a time? Do you wish you could have a successful trucking career while also maintaining a consistent life at home? Drive for Kempsville Building…