Senior Business Intelligence Engineer

Location: Hybrid - Irvine, CA

Job Type: Contract

Mutual of Omaha is a Fortune 300 Company. 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. 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!

THE ROLE

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. You'll also define the KPIs that drive lending and marketing decisions.

Responsibilities

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

Required Qualifications

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

Required Technical Skills

• 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.
• Data modeling and governance: grain declaration, conformed dimensions, data quality testing.
• Python for data wrangling, automation, and ingestion.
• Version control and CI/CD (Git, Azure DevOps or similar).

Preferred Qualifications

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