Mutual of Omaha Mortgage is hiring: Data Analyst (SQL) in Irvine

Get AI-powered advice on this job and more exclusive features.

The Mortgage Business Intelligence & Analytics team oversees all activities and functions involved with the company’s Business Intelligence platform, giving mortgage company business leaders access to reliable, actionable data to better manage and understand the business and drive company growth.

We are seeking a Data Analyst to support compliance, finance, and other streamlining initiatives. This role will focus on extracting, validating, and monitoring loan-level data to respond to state audit requests and regulatory reporting requirements, including the Mortgage Call Report (MCR). They will also lead efforts to streamline manual processes, by utilizing centralized data warehouse sources and tools to reduce/eliminate manual efforts. The ideal candidate is highly skilled in SQL, comfortable working with complex datasets, and able to ensure the accuracy and completeness of data used for critical regulatory reporting. The Data Analyst will also contribute to the documentation, development, and maintenance of our reports, and assist in monitoring and auditing the accuracy of our reporting data.

What you will be doing:
Regulatory & Audit Data Support (40%)

• Respond to state audit requests by extracting and validating loan-level data
• Ensure accuracy and completeness of data used for regulatory reporting, including MCR submissions
• Collaborate with compliance and risk teams to understand reporting requirements and timelines

The Mortgage Business Intelligence & Analytics team oversees all activities and functions involved with the company’s Business Intelligence platform, giving mortgage company business leaders access to reliable, actionable data to better manage and understand the business and drive company growth.

We are seeking a Data Analyst to support compliance, finance, and other streamlining initiatives. This role will focus on extracting, validating, and monitoring loan-level data to respond to state audit requests and regulatory reporting requirements, including the Mortgage Call Report (MCR). They will also lead efforts to streamline manual processes, by utilizing centralized data warehouse sources and tools to reduce/eliminate manual efforts. The ideal candidate is highly skilled in SQL, comfortable working with complex datasets, and able to ensure the accuracy and completeness of data used for critical regulatory reporting. The Data Analyst will also contribute to the documentation, development, and maintenance of our reports, and assist in monitoring and auditing the accuracy of our reporting data.

What you will be doing:
Regulatory & Audit Data Support (40%)

• Respond to state audit requests by extracting and validating loan-level data
• Ensure accuracy and completeness of data used for regulatory reporting, including MCR submissions
• Collaborate with compliance and risk teams to understand reporting requirements and timelines

• Perform ongoing validation of primary and derived tables to ensure data integrity
• Update views and stored procedures as needed to capture new/updated regulatory requests
• Work with pertinent business units to obtain and validate regulatory submission data
• Maintain exception reporting to proactively identify and address data issues

• Lead efforts to automate financial transaction entries using SQL and Power Automate platforms
• Identify opportunities for streamlining manual processes across various business units

• Assist in minor updates to existing reports and contribute to new report creation based on business and regulatory needs.
• Develop views and server-side objects to support reporting and semantic models.

• Provide support for ongoing team initiatives and ad hoc projects.

• 2-5 years’ experience in a data focused role
• Strong understanding of SQL and relational databases, including advanced querying and data validation techniques
• Experience with regulatory reporting in mortgage or financial services
• Familiarity with the MCR or other regulatory reporting frameworks a plus
• Comfortable working with large datasets and performing detailed reconciliations and validations
• Strong written and verbal communication
  

• MS SQL Server including:
  • Standard data mining
  • Advanced querying/window methods
  • Create/read views and stored procedures
• Power BI experience a plus
• VCS such as Git or TFS

This opportunity is fully remote with the option to work from our offices in San Diego, CA, Irvine, CA, or Omaha, NE for those who prefer an office environment. You will be joining a dynamic, fully remote team which is distributed across pacific and central time zones and supporting our business across all US time zones.

Applicants must be authorized to work in the US without the need for sponsorship.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Internet Publishing

Referrals increase your chances of interviewing at Mutual of Omaha Mortgage by 2x

Get notified about new Data Analyst jobs in Irvine, CA.

Newport Beach, CA $70,000.00-$115,000.00 3 weeks ago

Irvine, CA $75,000.00-$82,000.00 1 week ago

Newport Beach, CA $205,000.00-$240,000.00 4 months ago

Newport Beach, CA $165,000.00-$215,000.00 4 months ago

Analyst - Excel Reports (Advanced level/Power user), Data

Irvine, CA $90,000.00-$130,000.00 4 days ago

Santa Fe Springs, CA $100,000.00-$120,000.00 2 weeks ago

Associate Analyst, Data-Remote in California

Tustin, CA $100,000.00-$150,000.00 5 days ago

Newport Beach, CA $165,000.00-$240,000.00 19 hours ago

Irvine, CA $99,461.00-$128,329.00 2 days ago

Newport Beach, CA $165,000.00-$240,000.00 1 week ago

Aliso Viejo, CA $61,000.00-$86,000.00 1 month ago

Irvine, CA $50,000.00-$70,000.00 2 months ago

Irvine, CA $111,800.00-$139,800.00 4 weeks ago

Clinical Operations Data Analyst - Enterprise Data and Analytics - FT - Day - Remote

Irvine, CA $87,316.74-$117,873.05 1 month ago

Newport Beach, CA $110,000.00-$120,000.00 2 weeks ago

Irvine, CA $85,000.00-$95,000.00 2 days ago

Irvine, CA $74,859.00-$100,227.00 3 weeks ago

Data Analyst III - Transportation Management Systems

Irvine, CA $105,000.00-$136,000.00 2 weeks ago

Irvine, CA $101,000.00-$113,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.