Data Engineer

OneAmerica Financial; Indianapolis (IN); Hybrid; USD 105,000 - 140,000; Full time

Benefits offered by this job

Medical & prescription, dental, vision

Health Savings Account & Flexible

Paid Time Off

Parental leave

401(k) Plan with company match

Pension Plan

Life & disability insurance

Wellness Program & employee assistance

Clinic access

Job summary

OneAmerica Financial is seeking a Data Engineer to build a modern cloud data platform focused on delivering trusted data quickly and reliably. You will develop scalable pipelines using Snowflake, dbt, and Python, while collaborating with analytics, product, and business teams to produce dependable data products.

The role emphasizes hands-on development, data quality, governance, and cost optimization, with opportunities to contribute to architecture and standards in a dynamic insurance data

Qualifications

• Bachelors Degree in a related field or equivalent experience.
• 3+ years in data engineering, software engineering, or data development.
• Hands-on Snowflake or modern cloud data platform experience.
• Strong SQL skills and data transformation expertise.
• Proficiency in Python for data engineering, scripting, or automation.
• Experience building or supporting production ELT/ETL pipelines.
• Experience with dbt or similar transformation frameworks.
• Understanding of dimensional modeling and modern data architectures.
• Experience integrating data from multiple sources.
• Familiarity with Git, code review, and CI/CD practices.
• Strong analytical, troubleshooting, communication, and collaboration skills.

Responsibilities

• Build and maintain scalable, reliable data pipelines in Snowflake.
• Develop and support ELT workflows using dbt and modern tooling.
• Implement Bronze, Silver, and Gold medallion patterns.
• Integrate and transform data from operational systems and third-party platforms.
• Write reusable SQL and Python for data transformation and automation.
• Monitor pipelines, troubleshoot failures, and resolve data quality issues.
• Apply standards for testing, documentation, lineage, and observability.
• Support Snowflake performance and cost optimization.
• Collaborate with analytics, product, and business teams to clarify requirements.
• Contribute to data modeling, governance, and engineering standards.
• Participate in code reviews, releases, and continuous improvement.

Skills

Snowflake

SQL

Python

ELT

dbt

Git

CI/CD

Data modeling

Data governance

Education

Bachelor's Degree

Tools

Snowflake

dbt

Job description

At OneAmerica Financial, our purpose is to create more certainty for our customers that leads to better moments, every day. Our commitment is to advance stability and growth in every solution and relationship. We deliver financial strength that builds for generations, and we are always aspiring, looking ahead, and collaborating to achieve more, together. Come be a part of this journey with us as we champion lives!

Job Summary

We are seeking a Data Engineer to build, enhance, and support a modern cloud data platform focused on delivering trusted data quickly, reliably, and efficiently. This is a hands-on, collaborative role for an engineer who is developing strong expertise in Snowflake, modern ELT and data engineering patterns, and scalable pipeline development.

The ideal candidate has solid engineering fundamentals, a delivery-oriented mindset, and the ability to work with guidance across multiple source systems. This person will develop maintainable pipelines, investigate data issues, and partner with senior engineers, analytics teams, and business stakeholders to create dependable data products.

Experience with Medallion Architecture, dbt, and cloud data platforms is preferred.

Primary Responsibilities include, but not limited to:

• Build and maintain scalable, reliable, and cost-conscious data pipelines in Snowflake
• Develop and support ELT workflows using modern tooling such as dbt
• Implement established Bronze, Silver, and Gold patterns within a Medallion Architecture
• Integrate and transform data from operational systems and third-party platforms
• Write reusable, maintainable SQL and Python for data transformation and automation
• Monitor pipelines, investigate failures, and resolve data quality issues
• Apply established standards for testing, documentation, lineage, observability, and deployment
• Support Snowflake performance and cost optimization through sound engineering practices
• Partner with analytics, product, and business teams to clarify requirements and deliver trusted datasets
• Contribute to data modeling, governance, and engineering standards
• Participate in code reviews, release activities, and continuous improvement efforts

Required Work Experience/Education:

• Bachelors Degree
• 3+ years of data engineering, software engineering, or data development experience
• Hands-on experience working with Snowflake or a comparable modern cloud data platform
• Strong SQL skills, including joins, window functions, transformations, and query troubleshooting
• Working proficiency in Python for data engineering, scripting, or automation
• Experience building or supporting production ELT or ETL pipelines
• Experience with dbt or a similar transformation framework
• Understanding of dimensional modeling and modern data architecture concepts
• Experience integrating data from multiple source systems
• Familiarity with Git, code review, and CI/CD practices
• Strong analytical, troubleshooting, communication, and collaboration skills

Recommended Work Experience/Education:

• Experience implementing Medallion Architecture patterns
• Experience in insurance, financial services, or another regulated industry
• Familiarity with orchestration tools such as Airflow, Dagster, or Snowflake Tasks
• Exposure to streaming or near-real-time data pipelines
• Familiarity with data observability, monitoring, and lineage tools
• Experience supporting enterprise BI and analytics platforms
• Exposure to Data Vault and/or dimensional modeling methodologies

Salary Band: 05B

This selected candidate will be expected to work hybrid in Indianapolis, IN. The candidate will also be expected to physically return to the office in CA, IN or ME as business needs dictate or for team building and collaboration.

We offer a comprehensive total rewards package designed to support you both at work and at home. Full-time and part-time associates working 30 or more hours per week are generally eligible for benefits, including but not limited to:

• Medical & prescription, dental, vision insurance
• Health Savings Account & Flexible Spending Accounts
• Paid Time Off
• 10 weeks 100% paid parental leave (after completing 12 months of employment)
• 401(k) Plan with company match
• Pension Plan
• Company paid life & disability insurance
• Wellness Program & Company paid employee assistance program
• Clinic access subject to location* (*Indianapolis, Charlotte, Cincinnati)

If you are offered and accept this position, please be advised that OneAmerica Financial does not have any offices located in the State of New York and OneAmerica Financial associates are not permitted to work remotely in the State of New York.

Selected employees must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

Disclaimer: American United Life Insurance Company ("OneAmerica Financial") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee based on race, color, religion, creed, national origin or ancestry, ethnicity, sex (including gender, pregnancy, sexual orientation, gender identity), age, physical or mental disability, veteran or military status, genetic information, citizenship, or any other legally recognized protected basis under federal, state, or local law.

For all positions:

Because this position is regulated by the Violent Crime Control and Law Enforcement Act, if an offer is made, applicants must undergo mandated background checks as a condition of employment. Such background checks include criminal history. A conviction is not necessarily an absolute bar to employment. Consistent with applicable regulatory guidelines and law, factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered.

To learn more about our products, services, and the companies of OneAmerica Financial, visit oneamerica.com/companies.