Lead Data Engineer
About The Position
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.
Requirements
- 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 OR 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 OR High School or General Education Development (GED) diploma and ten years of experience in business application, business intelligence, or enterprise application consulting or development OR An equivalent combination of education and experience
Nice To Haves
- 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.
Responsibilities
- 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.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
1,001-5,000 employees
