Data Engineer I/II - Data Analytics & Solutions

Mutual of Omaha is seeking a data-driven Data Engineer II to join its Data Analytics & Solutions team. The role focuses on building and maintaining production ETL pipelines, supporting data systems, and helping migrate the data warehouse from Teradata to Snowflake while partnering with engineering, business analysis, and reporting teams.

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

Requirements:

• • 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 work remotely, with the ability to travel onsite for team events 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
• • Applicants for this position must not now, nor at any point in the future, require sponsorship for employment
• • A local candidate is preferred but not required
• • SAFe Agile experience
• • Exposure to Control-M or similar job-scheduling tools
• • Windows scripting, in addition to Unix
• • Familiarity with mainframe environments
• • API integration experience
• • Located near the Mutual of Omaha office