Nationwide Insurance

Consultant, Software Engineer | Python ETL Technical Lead

Nationwide Insurance$118K — $178K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Advanced Python skills with experience in ETL framework design.
  • Expertise in API and SDK integration with strong attention to security and error handling.
  • Proficient in data engineering, including SQL and data validation processes.
  • Experience in cloud-native technologies and practices, particularly with AWS and Databricks.
  • Strong technical leadership abilities, with mentoring experience preferred.

Responsibilities

  • Design and evolve a robust ETL framework for efficient data management.
  • Build and maintain integrations with various data sources and services.
  • Implement thorough data transformation processes ensuring data integrity.
  • Drive production readiness through testing, monitoring, and security practices.
  • Lead technical initiatives and provide mentorship to team members.

Benefits

  • Comprehensive medical, dental, and vision insurance.
  • Generous paid time off starting at 18 days per year, plus holidays and additional time.
  • 401(k) plan with company matching contributions.
  • Company-paid pension plan to support your future.
  • Flexible work arrangement with a hybrid schedule.
Full Job Description

Join the Finance & Investments Technology BSA, a team focused on delivering innovative technology solutions that support Nationwide's finance and investment operations. This role offers the opportunity to influence enterprise-wide engineering standards, build reusable capabilities leveraged across multiple teams, and work with modern cloud and data technologies while partnering with architecture, security, governance, and product leaders.

Required Skills

  • Advanced Python and ETL framework design — Strong production experience with Python, modular architecture, reusable components, packaging, testing, error handling, performance optimization, and maintainable pipeline design.

  • API and SDK integration — Expertise integrating REST APIs, third-party SDKs, databases, files, and cloud services using secure authentication, pagination, rate limiting, retries, schema validation, and resilient error handling.

  • Data engineering and quality — Strong SQL, data modeling, schema mapping, incremental and bulk loading, data validation, reconciliation, deduplication, data contracts, and schema evolution.

  • Cloud-native delivery and Nationwide Golden Path alignment — Experience with containers, CI/CD, GitHub, automated testing, observability, secure configuration, and platforms such as AWS, Snowflake, Databricks, or Harmonia.

  • Technical leadership and sustainable development — Ability to lead design decisions, mentor engineers, document standards, and use GitHub Copilot with VS Code responsibly to improve productivity while maintaining security, quality, and long-term maintainability. A recognized Python certification is preferred.

Responsibilities

  • Design and evolve the ETL framework by defining reusable extraction, transformation, validation, loading, configuration, logging, retry, checkpointing, audit, and restartability patterns.

  • Build and support data integrations with third-party APIs, SDKs, databases, files, SaaS platforms, and cloud services.

  • Implement reliable data transformations and loads including normalization, enrichment, deduplication, business-rule processing, reconciliation, delta processing, upserts, and bulk loading.

  • Drive production readiness through automated unit and integration testing, CI/CD, containerized execution, data quality controls, monitoring, alerting, SLA tracking, and secure secrets management.

  • Lead and enable the engineering team through architecture and code reviews, mentoring, technical documentation, stakeholder collaboration, and effective use of GitHub Copilot with VS Code.

Work Arrangement: This role follows a hybrid schedule and requires in-office presence in our Columbus OH office location two days per week. Candidates must be based within a commutable distance to Columbus, Ohio.

Work Authorization: This role does not qualify for employer-sponsored work authorization. Nationwide does not participate in the STEM OPT Extension program.

#LI-KR1

Job Description Summary

If you’re enthusiastic about delivering secure technology solutions to support a company providing extraordinary care to its customers, then Nationwide Technology is the place for you. Nationwide's industry-leading technology workforce embraces an agile work environment and a collaborative culture to deliver outstanding solutions and results. If that sounds like something you aspire to, we want to hear from you!

As a Software Engineer, you will focus on mentoring and leading others to deliver high quality, cost-effective technology solutions to business partners by crafting new software applications or modifying and/or supporting existing packaged or custom-built applications.

Job Description

Key Responsibilities:

  • Responsible for applying secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.

  • Mentors and trains other team members on design techniques, tools and coding standards. 

  • Provides strategic advice on using technology to achieve goals. 

  • Drives cross-collaboration and execution of projects across multiple teams. 

  • Analyzes, solutions, develops, tests, debugs, documents and deploys software according to standards and optimal practices. 

  • Champions the use of DevSecOps practices, tooling and techniques. 

  • Ensures continuous learning and improvement through ongoing training, practice and innovation. 

  • Manages individual project priorities, deadlines and deliverables. 

May perform other responsibilities as assigned.

Reporting Relationships: Reports to a Technology Manager/Director. 

Typical Skills and Experiences:

Education: Undergraduate studies in computer science, management information systems, mathematics or related field is strongly preferred. 

Experience: Six years of experience in programming and systems analysis. Three years of experience in project management is preferred. 

Knowledge, Abilities and Skills: Hands-on technical leadership experience leading project teams and setting technical direction. Proficiency in one programming language such as Java, C++, Python, JavaScript. Knowledge of software development lifecycle. Proven ability to tackle sophisticated business and development problems. Ability to thrive in a team environment. Insurance/financial services industry knowledge a plus. 

Other criteria, including leadership skills, competencies and experiences may take precedence. 

Staffing exceptions to the above must be approved by the hiring manager’s leader and Human Resources Business Partner.

Values: Regularly and consistently demonstrates Nationwide Values.

Job Conditions: 

Overtime Eligibility: Not Eligible (Exempt)

Working Conditions: Normal office environment. Associates may have on-call responsibility after normal working hours and/or on weekends. 

Benefits

We have an array of benefits to fit your needs, including: medical/dental/vision,life insurance, short and long term disability coverage, paid time off with newly hired associates receiving a minimum of 18 days paid time off each full calendar year pro-rated quarterly based on hire date, nine paid holidays, 8 hours of Lifetime paid time off, 8 hours of Unity Day paid time off, 401(k) with company match, company-paid pension plan, business casual attire, and more. To learn more about the benefits we offer,click here.


About Nationwide Insurance

Nationwide Mutual Insurance Company & Affiliated Companies is a group of large U.S. insurance and financial services companies based in Columbus, Ohio. Nationwide has grown from a small mutual auto insurer owned by policyholders to one of the largest insurance and financial services companies in the world, with more than $158 billion in statutory assets.

Nationwide Insurance Careers

Join the Nationwide Insurance team today and be part of a company that values innovation, leadership, and diversity. As one of the leading insurance and financial services providers, Nationwide offers unparalleled job opportunities that foster professional growth and development. Work You’ll Do At Nationwide Insurance, you’ll contribute to projects that impact lives and help communities thrive. You’ll work alongside a team of experts dedicated to upholding the highest standards in insurance and financial services. Our culture is built on a foundation of respect and integrity, driving us to achieve excellence in everything we do. Nationwide Insurance is not just about insurance; it’s about fostering an environment of continuous growth and innovation. With a variety of career paths available, from customer service to claims management, each position offers the chance to make a significant impact. Join Our Market-Leading Team Nationwide Insurance is home to some of the most dedicated professionals in the industry. Our team benefits from leadership that is committed to personal and professional development, ensuring that every employee has the opportunity for career advancement and skill enhancement. Innovate with Us Embrace the opportunity to work on groundbreaking projects that set industry standards. Nationwide’s commitment to innovation means constantly seeking out new ways to improve our services and processes, benefiting both our customers and our team members. Internship and Employment Opportunities Start your career with Nationwide Insurance through our internship programs or dive straight into a fulfilling career with vast employment opportunities. We are looking for passionate, curious, and driven individuals ready to make a difference in the insurance industry. Diversity and Inclusion At Nationwide, diversity and inclusion are more than just words—they are principles guiding how we build our teams, cultivate leaders, and create a company that’s the right fit for every person inside of it. We offer diversity training and resources that promote an inclusive workplace. Benefits and Culture Nationwide Insurance is committed to supporting our team members’ well-being both inside and outside of work. Our benefits package includes comprehensive health care, retirement plans, and generous paid time off. More than just benefits, our company culture encourages networking, mentorship, and community involvement. Career Development Invest in your future with Nationwide Insurance’s career development programs. From resume and interview workshops to advanced leadership training, we provide the tools to help you succeed and advance within the company. Stay Connected Join Our Team Explore the various positions available at Nationwide Insurance that match your skills and interests. We are continuously hiring and looking for new talent to join our professional network. Keep Up to Date Stay informed with career tips, insider perspectives, and industry-leading insights—all from the people who work at Nationwide Insurance. Job Alert Emails Customize your subscription to receive job alerts and the latest news tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Nationwide Insurance. Join Nationwide Insurance today and be part of a team that is dedicated to making a difference in the lives of our customers and communities.
Learn more about Nationwide Insurance
Size
28,000 employees
Industry
Founded
1925

Similar Jobs

More Jobs at Nationwide Insurance

More Information Technology Jobs

Find similar Consultant, Software Engineer | Python ETL Technical Lead jobs: