Data Engineer II — Analytics & Solutions (Remote)

Mutual of Omaha Insurance Co.; United States; Hybrid; USD 95,000 - 130,000; Full time

Benefits offered by this job

401(k) plan

Remote work flexibility

Periodic onsite PI planning

Paid time off

Job summary

Mutual of Omaha's Data Analytics & Solutions (DAS) team seeks a Data Engineer II to own production data pipelines and support the Teradata-to-Snowflake migration, with AWS Glue and mainframe decommissioning on the roadmap.

The role is remote-friendly with periodic onsite PI planning sessions. We offer a 401(k) plan, vacation and holidays, and a fast-paced, autonomous team environment that values hands-on ownership. Applicants must be comfortable traveling up to four times a year.

Qualifications

• 6+ years of professional experience in data engineering / data systems development, or equivalent.
• Advanced SQL knowledge, including writing and maintaining stored procedures.
• Hands-on experience across multiple relational/data-warehouse platforms: Teradata, Snowflake, Oracle, and DB2.
• Strong ETL experience, proficient with ETL tooling such as Informatica / IDMC.
• Working knowledge of Unix scripting, sufficient to understand and support existing scripts.
• Understanding of data warehouse concepts and cloud data environments.
• Familiarity with GitHub for source control.
• Strong debugging skills to support production issues.
• Experience working on an Agile team.
• Willingness to learn AWS and AWS Glue, and to pick up new ETL technologies as the team modernizes.
• Able to work independently with minimal oversight — this team runs with a high degree of autonomy, so self-driven, decisive contributors do best here.
• Able to travel onsite up to four times a year.
• Participation in an on-call rotation shared with the team, roughly every 5-6 weeks (one week as primary, following week as backup); after-hours pages are infrequent.

Responsibilities

• Build, debug, and maintain ETL pipelines that move and transform data across the team's supported systems.
• Investigate customer and business-partner data requests, validate data, and troubleshoot where information is missing or incorrect.
• Support the active migration from Teradata to Snowflake — tracing source tables in Teradata, building equivalent Snowflake tables, and ensuring downstream consumers see a seamless transition.
• Write and maintain advanced SQL and stored procedures across Teradata, Snowflake, Oracle, and DB2.
• Partner with other engineering, BA, and reporting teams that consume DAS-owned data, including application teams (e.g., the Data Integration Hub) that call on DAS data behind the scenes.
• Participate in a daily 30-minute developer collaboration session to raise blockers and work through problems with the team.
• Participate in Agile ceremonies, including sprint planning (roughly every 3 weeks) and PI planning.
• Maintain data quality through systematic approaches within supported data systems.
• Help lead and mentor other developers through technical challenges.

Skills

Advanced SQL

ETL pipelines

Agile team

Data warehousing

Unix scripting

GitHub

Debugging

Self-driven

Tools

Teradata

Snowflake

Oracle

DB2

Informatica

IDMC

AWS Glue

Job description

Mutual of Omaha's Data Analytics & Solutions (DAS) team seeks a Data Engineer II to own production data pipelines and support the Teradata-to-Snowflake migration, with AWS Glue and mainframe decommissioning on the roadmap.

The role is remote-friendly with periodic onsite PI planning sessions. We offer a 401(k) plan, vacation and holidays, and a fast-paced, autonomous team environment that values hands-on ownership. Applicants must be comfortable traveling up to four times a year.