Data Engineer Sr

OneAmerica; Indianapolis, Northern (IN, KY); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical & prescription

Dental

Vision insurance

Health Savings Account

Flexible Spending Accounts

Paid Time Off

Parental leave

401(k) Plan with company match

Pension Plan

Life & disability insurance

Wellness Program

Employee assistance program

Clinic access

Job summary

OneAmerica Senior Data Engineer in Indianapolis, hybrid work setup, leads data-related projects and aligns data models with enterprise standards. This role partners with business lines to shape data solutions and drives continuous improvement in data architectures.

Required: 5+ years in data architecture, strong SQL, and modeling skills; experience with data warehouses, OLTP/OLAP, and data integration platforms; Agile and DevOps familiarity.

Qualifications

• Bachelor’s degree in computer science or a related discipline.
• 5+ years of experience in a data architecture-related role.
• 5+ years of experience modeling data solutions including ODS, Data Warehouse, Data Integration Hub, OLTP/OLAP.

Responsibilities

• Maintain a holistic view of the scope of all data projects across a line of business and watch for project collisions.
• Provide project consultation including reviewing Data Architecture at the project level and opportunities for component reuse.
• Set Data Modeling standards and processes.
• Perform data model audits for standards compliance.
• Maintain conceptual data models for each line of business.
• Understand the complete data path within the business lines.
• Develop understanding of business data needs and align with enterprise data strategy.
• Partner with the Enterprise Data Architect to implement the enterprise data strategy.

Skills

Data modeling

Data architecture

SQL

Agile methodologies

DevOps concepts

Education

Bachelor's degree in computer science or related discipline

Tools

NOSQL

Hadoop

Redshift

SQL

HTML

CSS

XML

JavaScript

Job description

Indianapolis Tower
Indianapolis, IN 46282, USA

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!

Data Engineer Sr is responsible for providing strategic leadership and direction for data-related projects. The role will partner closely with at least one Line of Business to maintain their data model in alignment with standards and architecture. The Data Engineer Senior will review data models, evolve and implement OneAmerica Ways around data, and design and execute on continuous improvement efforts.

Primary responsibilities include, but are not limited to:

• Maintain a holistic view of the scope of all data projects across a line of business looking for potential project collisions
• Provide project consultation including reviewing Data Architecture overall approach at project level and looking for opportunities for component reuse.
• Set Data Modeling standards and processes
• Perform data model audits for standards compliance
• Maintain conceptual data models of each line of business
• Understand the complete path of data within the entire line of business
• Develop an in-depth understanding of the business data needs and the ability to align those business needs with the overall Enterprise data strategy
• Partner with the Enterprise Data Architect to influence, understand, and implement the Enterprise Data Strategy

Required Experience or Education:

• Bachelor’s degree in computer science or a related discipline

5+ years of experience in a data architecture-related role

• 5+ years of experience data modeling data solutions including but not limited to:
  • ODS
  • Data Warehouse
  • Data Integration Hub
  • OLTP/OLAP
  • Or Equivalent knowledge

5+ years of experience data modeling, querying, and performance tuning relational DBMS (Oracle, SQL Server, DB2)

Expert SQL skills and demonstrated ability to write and debug complex SQL for purposes of analysis and translation of data needs into back end structures

Demonstrated experience in work estimation and management

Familiarity working on agile teams

Familiar with DevOps concepts and methodologies

Preferred Experience or Education:

• Experience with recent data technologies (NOSQL, Hadoop, RedShift, etc.) preferred
• Experience with one or more programming languages, including but not limited to:
  • SQL
  • HTML
  • CSS
  • XML
  • JavaScript
• Experience with test driven development practices
• Experience with NoSQL database technology
• Experience working in a DevOps environment
• Master's degree in Data Analytics or similar field
• CDMP certification, Mastery Level

Salary Band:6C

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.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.