Senior Python ETL Tech Lead — Cloud Data Pipelines

Nationwide Mutual Insurance Company; Columbus (OH); Hybrid; USD 118,000 - 178,000; Full time

Benefits offered by this job

Medical/dental/vision

Life insurance

Short/long term disability

Paid time off

Holidays

401(k) with match

Pension plan

Casual attire

Job summary

Nationwide is seeking a skilled software engineer to advance secure technology solutions for finance and investments. The role focuses on building reusable ETL capabilities and integrating third-party APIs, SDKs, and cloud services across teams.

You will drive design decisions, mentor engineers and collaborate with architecture, security and product leaders while ensuring quality, security and maintainability across the data platform.

Qualifications

• Strong production experience with Python, modular architecture and maintainable pipeline design.
• Expertise integrating REST APIs, SDKs, databases and cloud services with secure auth and resilient error handling.
• Strong SQL, data modeling, schema mapping and data quality through validation and reconciliation.
• Experience with containers, CI/CD, GitHub, automated testing and observability on cloud platforms (AWS/Snowflake/Databricks/Harmonia).
• Ability to lead design decisions, mentor engineers and document standards using GitHub Copilot with VS Code.

Responsibilities

• Design and evolve the ETL framework with reusable extraction, transformation, validation, loading and audit patterns.
• Build and support data integrations with APIs, SDKs, databases, files and cloud services.
• Implement reliable data transformations including upserts, delta processing and bulk loading.
• Drive production readiness through automated testing, CI/CD, containerized execution and data quality controls.
• Lead engineering reviews, mentor team members and promote secure, scalable practices.

Skills

Advanced Python

API integration

Data engineering

Cloud-native delivery

Technical leadership

Python certification

Tools

AWS

Snowflake

Databricks

Harmonia

Job description

Nationwide is seeking a skilled software engineer to advance secure technology solutions for finance and investments. The role focuses on building reusable ETL capabilities and integrating third-party APIs, SDKs, and cloud services across teams.

You will drive design decisions, mentor engineers and collaborate with architecture, security and product leaders while ensuring quality, security and maintainability across the data platform.