Senior ETL Developer

Nationwide-Children; Columbus (OH); On-site; USD 120,000 - 170,000; Full time

Job summary

Nationwide-Children in Columbus, OH seeks a Senior Data Integration Lead to Own the development, maintenance, and implementation of complex ETL pipelines across diverse data sources. You will drive scalable, metadata-driven patterns and promote best practices in data engineering across the organization.

You will mentor engineers, collaborate with cross-functional teams, and ensure data quality and security across data warehouse solutions while guiding long-term maintainability and performance.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Services, or related field is required.
• Master’s degree is preferred.
• Certifications in data or cloud technologies are a plus.
• Seven years of enterprise data pipeline design and support experience are required.

Responsibilities

• Leads development, maintenance, and implementation of complex ETL pipelines across structured and unstructured data sources.
• Drives scalable, metadata-driven, reusable data integration patterns to reduce technical debt.
• Mentors team members and promotes best practices in code reviews, testing, and documentation.
• Collaborates with multiple teams to ensure data quality and alignment with business goals.

Skills

ETL/ELT

Data warehousing

Pipeline design

Analytical thinking

Mentoring

Communication

Collaboration

Secure development

Education

Bachelor's degree in Computer Science or related field

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, WalkingFREQUENTLY: Flexing/extending of neck, StandingCONTINUOUSLY: 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"