jobapplier

Senior Business Intelligence Engineer

Mutual of Omaha Mortgage

If you are interested in joining a team that promotes from within and works together toward a common goal of helping customers with their mortgage needs, please review and apply for our opening below!

Mutual of Omaha Mortgage is looking for a Senior BI Engineer to build governed data models and reporting across loan, CRM, and marketing data. You'll own gold-layer modeling in a dbt medallion architecture and executive reporting in Sigma and Power BI.

About Mutual of Omaha Mortgage

Mutual of Omaha Mortgage is inspired by hometown values and a commitment to being responsible and caring for each other.

We exist for the benefit of our customers and employees.

Mutual of Omaha Mortgage is a full-service lending company offering both Forward and Reverse Mortgage products including a complete line of residential mortgage, refinancing, specialty, and HECM loans.

We employ a knowledgeable staff of experienced Loan Officers with an operations team that is second to none.

Responsibilities

  • You'll also define the KPIs that drive lending and marketing decisions.
  • Design, build, and maintain dimensional data models (Kimball star schema) across Bronze, Silver, and Gold layers using dbt on Databricks.
  • Integrate and reconcile data from loan origination systems, Salesforce CRM, servicing feeds, and third-party vendors, including cross-system entity resolution.
  • Build executive and operational dashboards in Sigma and Power BI covering pipeline, lead-to-loan conversion, funded volume, channel attribution, and campaign ROI.
  • Define and document governed KPIs in a semantic layer for consistent metrics across tools.
  • Own data quality through profiling, automated testing, volume and null-rate monitoring, and root-cause analysis of pipeline discrepancies.
  • Lead migration and modernization work, from legacy data warehouse to cloud warehouse and legacy reporting to modern BI.
  • Serve as data SME for Marketing, Sales, Operations, and Finance, translating business questions into technical requirements.
  • Mentor analysts on SQL, data modeling, and BI best practices.
  • grain declaration, conformed dimensions, data quality testing.
  • Python for data wrangling, automation, and ingestion.

Requirements

  • 7+ years in business intelligence, analytics engineering, or data analytics.
  • 3+ years designing and maintaining production data models and reporting structures.
  • Experience delivering end-to-end pipelines, from source ingestion through dashboards, that improved operational efficiency.
  • Experience leading or contributing to data platform migrations.
  • Track record of supporting cross-functional stakeholders as a data subject matter expert.
  • Advanced SQL, including query optimization and performance tuning. dbt or SQL Mesh, and a cloud data warehouse (Databricks preferred; Snowflake considered).
  • Power BI (DAX, M Query) and/or Sigma.
  • Tableau experience transferable.
  • ETL/ELT design and automation, including CDC, slowly changing dimensions, and incremental loads.
  • Version control and CI/CD (Git, Azure DevOps or similar).

Preferred

  • Mortgage or consumer lending experience: loan lifecycle, LOS data, lead-to-loan funnels, sales and underwriting KPIs, HMDA data.
  • Multi-channel marketing attribution (paid search, DRTV, affiliate, direct mail).
  • Unity Catalog or similar governance tooling. dbt semantic layer / MetricFlow.
  • Microsoft BI stack (SQL Server, SSIS, SSRS).
  • Snowflake or Databricks certification.
  • RPA or process automation experience.
  • Bachelor’s degree in computer science, Information Systems, or a related field, or equivalent practical experience.

Pay

  • The salary for this position is $130,000 – $165,000 annually.
  • Actual pay is based on skills, experience, and qualifications.
  • Mutual of Omaha Mortgage is an Equal Opportunity Employer, and we encourage diverse, talented, qualified applicants to apply.
  • We offer an extensive compensation package.

Benefits

  • Vacation — Vacation hours accrue on a per pay period basis.
  • Balance maximums are based on years of service.
  • Paid Sick Time — 40 hours of paid sick time after 90 days of employment.
  • State sick time requirements will be added as needed.
  • 9 Paid Holidays + 1 Cultural Celebration Day (Floating Holiday) Multiple PPO Medical Plans, as well as HDHP eligible plan.
  • Dental Coverage Vision Coverage Company Paid Life Insurance 401K with a generous employer match Additional Benefits including – Optional Life, FSA, Pet Insurance etc.
  • Free Legal Services Employee Loan Program

Senior Business Intelligence Engineer Location

Hybrid - Irvine, CA Job Type: Contract Mutual of Omaha is a Fortune 300 Company.