Senior Business Data Analyst
Location: Hybrid - Irvine, CA
Job Type: Contract to Full Time
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!
Overview
We are seeking an experienced Senior Business Data Analyst to own data solutions end to end — from intake and scoping through build, validation, testing, and launch. This is a hands-on role, not a coordination role. You will write advanced SQL daily, manage the intake and prioritization of data and reporting requests, scope and run your own projects from requirements through production cutover, and personally validate that the data you deliver is accurate, reconciled, and launch-ready — all in alignment with the regulatory and compliance requirements applicable to a federally regulated mortgage lender.
Key Responsibilities:
Intake & Scoping
Own intake for data, reporting, and analytics requests: triage, clarify requirements directly with requestors, assess feasibility and effort, and prioritize against the data roadmap
Elicit and document functional and non-functional requirements, converting ambiguous business questions into scoped deliverables with clear acceptance criteria, data sources, and success measures
Perform hands-on data discovery and profiling (via SQL) during scoping to confirm source data supports the request before work is committed
End-to-End Project Delivery
Run data projects end to end: scoping, planning, build, validation, UAT, launch, and post-launch monitoring — staying hands-on in every phase
Maintain right-sized project plans, timelines, and status updates for executive and stakeholder visibility
Identify, escalate, and resolve risks and dependencies, unblocking work personally where possible (writingthe query, drafting the mapping, testing the fix)
Support data warehouse, pipeline, and BI migration efforts — including onboarding new sources via API and SFTP ingestion — as the analyst who verifies the data, not just tracks the tasks
Hands-On SQL, Validation & Testing
Write, debug, and optimize advanced SQL daily to profile source data, build validation and reconciliation queries, investigate discrepancies, and prototype transformation logic
Design and personally execute validation and reconciliation for every migration phase and data solution: row counts, field-level comparisons, aggregate tie-outs, and business-rule checks
Build and execute repeatable test plans for pipelines, data models, and reports, documenting results with evidence
Plan and drive UAT: test scripts, stakeholder walkthroughs, defect tracking, and documented sign-off prior to cutover
Document data lineage, transformation logic, and schema changes with data engineers and architects
Launches & Post-Launch Ownership
Own launch readiness: cutover checklists, go/no-go criteria, rollback plans, and stakeholder
communications
Personally verify production outputs at and after launch, reconciling first production runs against expected results and legacy baselines
Run post-launch monitoring and hypercare: track data quality, triage issues, and confirm adoption and stability
Stakeholder & Compliance Collaboration Act as the primary liaison between business teams (Operations, Finance, Compliance, Sales) and technical teams; translate technical concepts and data caveats into clear communications for leadership
Coordinate with…