Lead Data Engineer

This Lead Data Engineer position is a member of ITD - Child Welfare. This position reports to Jason Dempsey, Applications Systems Manager. This role will be responsible for designing and managing the data, analytics, and reporting ecosystem that powers data-driven decision-making for the Child Welfare Program, from Salesforce data ingestion through Azure Synapse to advanced Power BI solutions., * Strong command of SQL, Python, and distributed data processing frameworks (Spark, Databricks, Synapse, EMR, BigQuery, etc.).

• Designs and maintains Power BI reports and dashboards.
• Produces clear architectural diagrams, design documents, and operational runbooks.
• Engineers and monitors Synapse pipelines to ingest, transform, and validate data.
• Leads BI/data engineering initiatives, mentors staff, and enforces testing, governance, and security standards., The Office of the Secretary serves as the executive leadership arm of the North Carolina Department of Health and Human Services (NCDHHS), guiding the Department's mission to improve the health, safety, and well-being of all North Carolinians. Through strategic oversight and collaborative leadership, the Secretary's Office supports the effective coordination of over a dozen core divisions, ensuring that agency-wide priorities are aligned, resources are used responsibly, and services are delivered with equity and impact., In collaboration with our partners, the North Carolina Department of Health and Human Services (DHHS) protects the health and safety of all North Carolinians and provides essential health and human services. The IT division (ITD) is one of the divisions that report to the Operational Excellence portfolio. The ITD division comprises four sections: Implementation and Operations, Strategy and Workforce, Enterprise Technology, and Vendor and Finance. ITD offers the following services but not limited to implementations, operations, project/portfolio management, infrastructure, consulting, business division liaison, digital transformation, IT strategy, enterprise technology, IT contract and vendor management, and data office services., * Degrees must be received from appropriately accredited institutions. Transcripts and degree evaluations may be uploaded with your application. The State of North Carolina/Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent.
• For a list of organizations that perform this specialized service, please visit the NACES membership website at https://www.naces.org/members .

Degree/College Credit Verification

Degrees must be received from appropriately accredited institutions. Transcripts, degree evaluations, and cover letters may be uploaded with your application.

Veterans' and National Guard Preference

• Applicants seeking Veteran's Preference must attach a DD-214 Member-4 Form (Certificate of Release or Discharge from Active Duty) to their applications.
• Applicants seeking National Guard Preference must attach an NGB 23A (RPAS), along with the state application, if they are a current member of the NC National Guard in good standing.
• Applicants who are former members of either the NC Army National Guard or the NC Air National Guard, with honorable discharge and six years of creditable service, must attach a copy of the DD 256 or NGB 22, along with the state application.

ADA Accommodations

Consistent with the Americans with Disabilities Act (ADA) and the Pregnant Workers Fairness Act (PWFA), DHHS is committed to the full inclusion of all qualified individuals. As part of this commitment, DHHS will ensure that people with disabilities, or known limitations covered by the PWFA, are provided with reasonable accommodation. If reasonable accommodation is needed to participate in the job application or interview process, please contact the person indicated below.

The Knowledge, Skills, and Abilities (KSAs)/ Management Preferences are not required. Applicants who possess the following skills are preferred, Some state job postings say you can qualify by an "equivalent combination of education and experience." If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details.

Bachelor's degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and four years of progressive experience in business application consulting or development, Associate degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and five years of progressive experience in business application consulting or development, High School or General Education Development (GED) diploma and eight years of experience in business application consulting or development, An equivalent combination of education and experience

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.