Senior Business Data Analyst

Mutual of Omaha Mortgage•Irvine, CA

5d•$90 - $100•Hybrid

About The Position

Mutual of Omaha Mortgage is 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 requiring daily advanced SQL work, management of data and reporting request intake and prioritization, ownership of projects from requirements through production cutover, and personal verification that delivered data is accurate, reconciled, and launch-ready. Work must align with regulatory and compliance requirements applicable to a federally regulated mortgage lender. The analyst will partner with business teams including Operations, Finance, Compliance, and Sales, as well as technical teams, Legal, and Compliance. The role supports data warehouse, pipeline, and BI migration efforts and requires hands-on validation of data, clear stakeholder communications, and post-launch monitoring and support.

Requirements

At least 5 years of business or data analysis experience, including at least 2 years of hands-on delivery of data warehouse, ETL/ELT pipeline, or BI/reporting solutions.
Expert-level advanced SQL ability, including complex joins, window functions, aggregations, and reconciliation queries against large datasets; candidates should expect a hands-on SQL assessment.
Databricks experience with SQL warehouses, notebooks, Delta Lake, or Unity Catalog.
Strong analytical knowledge, including data profiling, root-cause investigation of discrepancies, reasoning about data quality, and drawing defensible conclusions from data.
Proven personal experience executing data validation, reconciliation, testing, and UAT, rather than only overseeing those activities.
Experience owning projects end to end, including intake, scoping, requirements, delivery, launch, and post-launch support.
Strong requirements elicitation skills, including documenting and validating functional and non-functional requirements such as performance, data quality, security, and auditability.
Strong understanding of data modeling, data warehousing, dimensional design, and reporting best practices.
Strong knowledge of data ingestion into modern data platforms, including API integrations, SFTP/file-based feeds, batch and incremental loads, source onboarding, mapping, and validation of ingested data.
Familiarity with cloud data platforms such as Snowflake, Azure, AWS, or GCP and modern BI tools such as Power BI, Tableau, or similar.
Ability to adapt in a fast-paced, regulated environment, manage concurrent workstreams and shifting priorities without losing quality, and communicate effectively in writing and verbally, including presenting to senior leadership.
Bachelor's degree in Computer Science, Information Systems, Business, or a related field, or equivalent practical experience.

Nice To Haves

Experience in financial services, banking, or mortgage, with familiarity with regulatory data requirements such as HMDA, MISMO, or CFPB reporting.
Experience with Agile or hybrid delivery and exposure to data governance frameworks.
Scripting or automation for data testing, such as Python or dbt tests.

Responsibilities

Own intake for data, reporting, and analytics requests by triaging requests, clarifying requirements with requestors, assessing feasibility and effort, and prioritizing work against the data roadmap.
Elicit and document functional and non-functional requirements, translating business questions into scoped deliverables with acceptance criteria, data sources, and success measures.
Use SQL for hands-on data discovery and profiling during scoping to confirm source data supports proposed requests.
Run data projects end to end, including scoping, planning, build, validation, UAT, launch, and post-launch monitoring.
Maintain project plans, timelines, and status updates for executive and stakeholder visibility.
Identify, escalate, and resolve risks and dependencies, personally unblocking work where possible.
Support data warehouse, pipeline, and BI migration efforts, including onboarding new sources via API and SFTP ingestion, and verify the data.
Write, debug, and optimize advanced SQL to profile source data, build validation and reconciliation queries, investigate discrepancies, and prototype transformation logic.
Design and execute validation and reconciliation for migration phases and data solutions, including 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 through test scripts, stakeholder walkthroughs, defect tracking, and documented sign-off before cutover.
Document data lineage, transformation logic, and schema changes in collaboration with data engineers and architects.
Own launch readiness, including cutover checklists, go/no-go criteria, rollback plans, and stakeholder communications.
Verify production outputs at and after launch, reconciling initial production runs against expected results and legacy baselines.
Run post-launch monitoring and hypercare, tracking data quality, triaging issues, and confirming adoption and stability.
Serve as the primary liaison between business and technical teams, explaining technical concepts and data caveats clearly to leadership.
Coordinate with Legal and Compliance to align activities with RESPA, TILA, ECOA, HMDA, and applicable data governance requirements.
Follow production data-system change management processes and maintain requirements, runbooks, and validation documentation.

Benefits

Vacation hours accrue per pay period, with balance maximums based on years of service.
40 hours of paid sick time after 90 days of employment; state sick-time requirements will be added as needed.
9 paid holidays and 1 cultural celebration day (floating holiday).
Multiple PPO medical plans and an HDHP-eligible plan.
Dental coverage.
Vision coverage.
Company-paid life insurance.
401(k) with a generous employer match.
Optional life insurance, FSA, pet insurance, and other additional benefits.
Free legal services.
Employee loan program.