Data Engineer I/II

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

Benefits offered by this job

401(k) plan with company match

Remote work with periodic onsite PI/te

Job summary

Mutual of Omaha Insurance Co. is seeking a Data Engineer I/II to own data pipelines and support a Teradata to Snowflake migration from a remote setting. You’ll work with DAS to ensure reliable data delivery for retail applications and reporting.

You will build ETL processes, optimize SQL, and collaborate with engineering and business teams in an autonomous, fast-moving environment with opportunities to grow into senior engineering roles.

Qualifications

• 6+ years of professional data engineering experience.
• Advanced SQL and stored procedures experience.
• Hands-on with Teradata, Snowflake, Oracle, and DB2.
• Strong ETL experience using Informatica / IDMC.
• Unix scripting and GitHub familiarity.
• Able to work in an Agile team and learn AWS Glue.

Responsibilities

• Build, debug, and maintain ETL pipelines across systems.
• Support migration from Teradata to Snowflake and ensure data compatibility.
• Write advanced SQL and manage stored procedures.
• Partner with teams consuming DAS data and participate in Agile ceremonies.
• Mentor developers and contribute to data quality initiatives.

Skills

Advanced SQL

ETL pipelines

Relational data platforms

Snowflake

Teradata

AWS Glue

Unix scripting

GitHub

Agile

Data quality

Tools

Informatica / IDMC

Oracle

DB2

Job description

Data Engineer I/II - Data Analytics & Solutions

Location: Remote
Work Type: Full Time Regular
Job No: 505226
Categories: Information Technology
Application Closes: Open Until Filled

Data Engineer I/II - Data Analytics & Solutions (DAS) — LIS ART, Retail Solutions

We are seeking a data-driven, detail-oriented Data Engineer II to join Mutual of Omaha's Data Analytics & Solutions (DAS) team, part of the LIS Agile Release Train within the Retail Solutions segment. This role is a strong fit for a data engineering professional who wants hands‑on ownership of production data pipelines and room to grow into a more senior engineering track.

The DAS team owns the data behind the scenes for our retail applications and reporting teams. You'll support production data systems, build and maintain ETL pipelines, and help lead the team's ongoing migration of our data warehouse from Teradata to Snowflake, with AWS Glue and continued mainframe decommissioning on the roadmap for the next 6–12 months.

This role will partner closely with other engineering, BA, and reporting teams that consume DAS owned data, including application teams like the Data Integration Hub, to keep data flowing reliably across the business.

We're looking for someone who already has hands‑on data engineering experience and is comfortable working with real autonomy. This team moves quickly and gives engineers real ownership.

If you're energized by hands‑on data engineering, cross‑functional collaboration, and helping modernize a growing data platform, we encourage you to apply.

WHAT WE CAN OFFER YOU:

• 401(k) plan with a 2% company contribution and 6% company match.
• Primarily remote, with periodic onsite collaboration for team‑building sessions and PI planning (up to four times a year).
• A local candidate is preferred but not required. This role can be fully remote for the right candidate.
• Applicants for this position must not now, nor at any point in the future, require sponsorship for employment.

This role is classified as remote; however, periodic in‑person attendance will be required at times for activities such as PI planning, team‑building sessions, or other business‑critical meetings.

WHAT YOU'LL DO:

• 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.

WHAT YOU'LL BRING:

• 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 remote, 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.

PREFERRED:

• Exposure to Control‑M or similar job‑scheduling tools.
• Windows scripting, in addition to Unix.
• Familiarity with mainframe environments.
• Located near the Mutual of Omaha office.

We value diverse experience, skills, and passion for innovation.

Together we achieve greatness. Not only is this a core value, but it’s also representative of the kind of place we are — built by the strength and integrity of our employees. It’s why we’re named a “Great Place to Work”.

Surround yourself with an authentic and inclusive culture. Your strengths and differences will be valued and celebrated by a diverse community of co‑workers.