Business Systems Consultant (Data & Analytic Solutions)

Mutual of Omaha; United States; Remote; USD 76,000 - 134,000; Full time

Benefits offered by this job

401(k) plan with company match

Job summary

Mutual of Omaha Insurance Co. is seeking a technically focused Business Systems Consultant to support our Life Insurance Solutions team as we modernize systems and migrate data to newer platforms.

This role focuses heavily on hands-on data analysis, SQL-based investigation, production support, testing, and data validation, while partnering across business and technical teams to deliver reliable system solutions. This position may be filled at the I, II, or III level based on experience.

Qualifications

• Proficient in SQL and data analysis to support data migrations and validation.
• Experience identifying data quality issues across multiple systems and environments.
• Ability to document requirements and translate them into technical workflows.

Responsibilities

• Partner with business and technical teams to gather, document, and refine requirements for system enhancements and modernization efforts.
• Use SQL to investigate production support issues, validate data, and identify root causes; escalate as needed.
• Support testing and data validation efforts by writing and executing test scenarios across DEV, CAT, PROD environments.
• Analyze current data flows and system processes to identify gaps and improve data reliability and reporting accuracy.
• Serve as a bridge between technical and business teams during modernization and data migration initiatives.

Skills

SQL

Data analysis

Tools

Teradata

DB2

IDMC

Job description

Business Systems Consultant (Data & Analytic Solutions)

Location: Remote
Work Type: Full Time Regular
Job No: 505373
Categories: Project Management/Business Analyst
Application Closes: Closes Nov 18, 2026

SHARE

We're seeking a technically focused Business Systems Consultant to support our Life Insurance Solutions team as we modernize systems and migrate data to newer platforms. This role focuses heavily on hands‑on data analysis, SQL‑based investigation, production support, testing, and data validation, while partnering across business and technical teams to deliver reliable system solutions. This position may be filled at the I, II, or III level based on experience.

WHAT WE CAN OFFER YOU:

• Estimated Salary (Levels have variable responsibilities and qualifications):
  • Business Systems Consultant I: $75,500 - $97,000, plus annual bonus opportunity.
  • Business Systems Consultant II: $86,000 - $114,000, plus annual bonus opportunity.
  • Business Systems Consultant III: $99,000 - $133,500, plus annual bonus opportunity.
• 401(k) plan with a 2% company contribution and 6% company match.
• Applicants for this position must not now, nor at any point in the future, require sponsorship for employment.

WHAT YOU'LL DO:

• Partner with business and technical teams to gather, document, and refine requirements for system enhancements and modernization efforts. You'll help translate business needs into clear technical workflows and solutions.
• Use SQL to investigate production support issues, validate data, and identify root causes. Document findings clearly and provide detailed handoffs to development teams when escalation is needed.
• Support testing and data validation efforts by writing and executing test scenarios, verifying results, and ensuring system changes function as expected across environments (DEV, CAT, PROD).
• Analyze current data flows and system processes, identify gaps or inconsistencies, and recommend improvements that strengthen data reliability and reporting accuracy.
• Serve as a key bridge between technical and business teams during system modernization and data migration initiatives, helping ensure successful delivery and adoption of new solutions.

WHAT YOU’LL BRING:

• Intermediate or higher SQL skills, including the ability to write, troubleshoot, and modify complex queries to support analysis, reporting, and production issue investigation.
• Experience working with relational databases, including querying large datasets and validating data accuracy. Familiarity with platforms such as Teradata or DB2 is strongly preferred.
• Proven ability to independently investigate production support issues, analyze data results, and distinguish between true system issues, reporting problems, timing delays, and expected behavior.
• Ability to take ownership of technical investigations through resolution, including gathering relevant information, analyzing data, documenting findings, and collaborating with developers or other technical teams as needed.
• Experience gathering and documenting business and technical requirements, supporting testing efforts, and working across multiple system environments.
• Strong analytical mindset with natural curiosity, attention to detail, and the ability to communicate findings clearly to both technical and non-technical stakeholders.
• You promote a collaborative culture, value different ideas and opinions, and listen courageously, remaining curious in all that you do.
• Able to work remotely with access to a high-speed internet connection and located in the United States.
• Able to travel occasionally (approximately 5-10% annually) to attend events and in-person meetings (travel reimbursed).

PREFERRED:

• Experience supporting data migration or modernization initiatives, including movement of data to cloud platforms such as Snowflake.
• Familiarity with Informatica Intelligent Data Management Cloud (IDMC) or similar ETL/data integration tools.
• Background in insurance, financial services, or other highly regulated industries

We value unique 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.