Lead Data Engineer

About the role

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.

Responsibilities

• Supports 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.
• Buils 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.

Requirements

Knowledge Skills And Abilities/Management Preferences:

• 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.
• Buils 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.

Qualifications

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

Skills

• 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.
• Buils 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.

Benefits

The State of North Carolina offers excellent 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.

Pay

Salary Grade Range: $91,600.00 - $160,299.00 Recruitment Range: $91,600.00 - $131,468.00

Schedule

This role is time-limited, concluding on June 30, 2031.