Senior ETL Developer

nationwidechildrens; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Nationwide Children's Leads development, maintenance, and implementation of data integration solutions, ensuring reliable data pipelines with quality governance. Oversees cross-system initiatives, mentors teammates, and drives continuous improvement across ETL frameworks and practices.

Required: Bachelor's in CS/Engineering/IS; Seven years in data pipelines; preferred Master's and cloud/data certifications. Emphasizes secure development and collaboration across teams.

Qualifications

• Seven years of experience designing, developing, and supporting enterprise data pipelines.
• Experience building scalable, reusable data integration patterns.
• Experience with secure development practices for handling sensitive data.

Responsibilities

• Leads the development, maintenance, and implementation of complex ETL pipelines and processes across structured and unstructured data sources, ensuring accuracy, reliability, performance, and security.
• Drives adoption of scalable, metadata driven, and reusable data integration patterns to reduce technical debt and improve long term maintainability.
• Identifies root causes, risks, and improvement opportunities across data solutions and processes.
• Participates in establishment and advancement of best practices for code reviews, testing, peer programming, and documentation, ensuring quality and standards.
• Collaborates with teams and stakeholders to understand data requirements and leads solution implementation aligned with business goals and data quality standards.
• Maintains and enhances ETL platforms, cloud services, and vendor delivered data warehouse solutions.
• Mentors and supports team members with best practices, testing approaches, and problem solving.

Skills

Data engineering concepts

Technical leadership

Stakeholder collaboration

Root cause analysis

Security practices

Education

Bachelor's degree in CS/Engineering/IS

Master's degree, preferred

Job description

Overview:

Certification and/or demonstrated experience with Clarity and Caboodle preferred.

Job Description Summary:

Leads the development, maintenance, and implementation of data integration solutions, ensuring reliable and high‑quality data pipelines and processes. Oversees complex data initiatives spanning multiple systems and stakeholders, mentors team members, and contributes to continuous improvement of data integration frameworks and practices.

Job Description:

Essential Functions:

• Leads the development, maintenance, and implementation of complex ETL pipelines and processes across structured and unstructured data sources, ensuring accuracy, reliability, performance, and security.
• Drives the adoption of scalable, metadata driven, and reusable data integration patterns to reduce technical debt and improve long term maintainability.
• Identifies root causes, risks, and improvement opportunities across data solutions and processes.
• Participates in the establishment and advancement of best practices for code reviews, testing, peer programming, and documentation, ensuring compliance with quality, maintainability, and engineering standards.
• Collaborates with team members and stakeholders to understand data requirements and leads solution implementation, ensuring alignment with business goals and data quality standards.
• Maintains and enhances ETL platforms, cloud services, and vendor delivered data warehouse solutions.
• Mentors and supports team members through constructive feedback, knowledge sharing, and guidance on best practices, testing approaches, and problem‑solving techniques.

Education Requirement:

Bachelor's Degree in Computer Science, Engineering, Information Services, or related field, required.

Master's Degree, preferred.

Certifications:

Relevant professional data or cloud certification, preferred.

Skills:

• Expert knowledge of data engineering concepts, including ETL/ELT, data warehousing, and pipeline design.
• Advanced analytical, problem solving, and systems thinking skills, with the ability to explain reasoning and trade-offs clearly. Sound judgment and data driven reasoning.
• Demonstrated commitment to accuracy, quality, and attention to detail.
• Ability to collaborate effectively with multiple teams and stakeholders across the organization. Strong communication skills and the ability to mentor and influence others through technical leadership rather than authority.

Experience:

• Seven years of experience designing, developing, and supporting enterprise data pipelines and analytics solutions, required.
• Experience building scalable, reusable data integration patterns and influencing engineering practices, required.
• Extensive experience performing data driven root cause analysis and designing well tested, maintainable solutions, required.
• Experience working with sensitive data and applying secure development practices, required.

Physical Requirements:

• OCCASIONALLY: Bend/twist, Climb stairs/ladder, Lifting / Carrying: 0-10 lbs, Pushing / Pulling: 0-25 lbs, Reaching above shoulder, Squat/kneel, Walking
• FREQUENTLY: Flexing/extending of neck, Standing
• CONTINUOUSLY: Audible speech, Color vision, Computer skills, Decision Making, Depth perception, Hand use: grasping, gripping, turning, Hearing acuity, Interpreting Data, Peripheral vision, Problem solving, Repetitive hand/arm use, Seeing - Far/near, Sitting

"The above list of duties is intended to describe the general nature and level of work performed by individuals assigned to this classification. It is not to be construed as an exhaustive list of duties performed by the individuals so classified, nor is it intended to limit or modify the right of any supervisor to assign, direct, and control the work of employees under their supervision. EOE M/F/Disability/Vet"