Lead Data Engineer

About Us The North Carolina Department of Health and Human Services (DHHS) is one of the largest, most complex agencies in the state, and has approximately 17,000 employees. It is responsible for ensuring the health, safety, and well‑being of all North Carolinians, providing human service needs for special populations including individuals who are deaf, blind, developmentally disabled, and mentally ill, and helping poor North Carolinians achieve economic independence. Agency Department of Health and Human Services Division SEC OFFICE - INFO TECH - NC FAST Job Title Applications Systems Specialist II (NS) Position Number: 65017797 Grade: DT11 Job Term: Time‑limited, concluding on June 30 2031 Description of Work The Lead Data Engineer will support and enhance the PATH NC child welfare data ecosystem, ensuring a stable, secure, and user‑centered data platform that integrates Salesforce, MuleSoft, Power BI, Synapse, and mainframe data sources. This role leads the design, development, and delivery of scalable data pipelines, models, and integrations that maintain system reliability, meet defined data‑quality standards, and uphold strong security and governance practices. The engineer will troubleshoot and resolve data issues within established SLAs, translate stakeholder needs into data solutions that improve accuracy, accessibility, and measurable analytic value, and guide the evolution of data flows across connected systems. The position also evaluates and introduces new data technologies, modernizes the data environment through incremental improvements, and ensures alignment with evolving policy, practice, and reporting requirements. Success in this role requires clear communication, leadership, and long‑term strategic planning to keep the data platform accurate, accessible, sustainable, and effective for frontline staff serving children and families. Preferred Knowledge, Skills, and Abilities Leads the design and delivery of enterprise‑grade data pipelines and visualizations sourced from Salesforce and other systems, increasing data availability and analytics adoption by measurable percentages. Builds and optimizes scalable ETL/ELT pipelines using Synapse, MuleSoft, SQL, and Salesforce data connectors, consistently meeting defined performance and reliability SLAs. Develops and maintains high‑quality data models that improve reporting accuracy and reduce downstream data issues as measured through validation and reconciliation checks. Implements automated data‑quality monitoring and remediation processes for Salesforce‑derived datasets, reducing data errors and improving integrity against established thresholds. Troubleshoots complex data issues across integrated platforms resolving root causes within agreed timelines to improve platform stability and user trust. Salary and Recruitment Range Salary Grade Range: $91,600.00 – $160,299.00 Recruitment Range: $91,600.00 – $131,468.00 Benefits The State of North Carolina offers comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high‑quality, low‑cost benefits on a pre‑tax basis). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees. View state benefits on the website. EEO Statement The State of North Carolina is an Equal Employment Opportunity Employer and is committed to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. Location Hybrid – requires onsite reporting located within Raleigh, NC. Closing Date Posting will close at 11:59 P.M. the night before the end date. The position is time‑limited and concludes on June 30 2031. #J-18808-Ljbffr