Talent.com
Data Analyst (SQL)

Data Analyst (SQL)

Mutual Of Omaha MortgageIrvine, California, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

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

Data Quality & Validation (25%)

  • 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
  • Streamlining & Automation (20%)

  • Lead efforts to automate financial transaction entries using SQL and Power Automate platforms
  • Identify opportunities for streamlining manual processes across various business units
  • Report Development & Maintenance (10%)

  • 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.
  • Team Support & Other Duties (5%)

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

  • 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
  • Required Skills

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

    serp_jobs.job_alerts.create_a_job

    Data Analyst • Irvine, California, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior Data Analyst

    Senior Data Analyst

    DRY UTILITY EXPERTSOrange, CA, US
    serp_jobs.job_card.full_time
    Senior Data Analyst — Utilities Infrastructure Services (On-site, USA).We operate in the infrastructure and utility services sector, specializing in dry-utility engineering, construction supp...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Flexible $ : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    Flexible $ : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    UberDana Point, CA, United States
    serp_jobs.job_card.full_time +1
    Earn at least $1405 driving with Uber when you complete your first 132 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Healthcare Data Analyst

    Senior Healthcare Data Analyst

    Strategic Employment Partners (SEP)Rancho Cucamonga, CA, United States
    serp_jobs.job_card.full_time
    Are you a data-driven professional with a passion for healthcare analytics? This healthcare organization is keeping on the forefront of emerging technologies to help with decisioning and predictive...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior Healthcare Data Analyst (Rancho Cucamonga)

    Senior Healthcare Data Analyst (Rancho Cucamonga)

    Strategic Employment Partners (SEP)Rancho Cucamonga, CA, US
    serp_jobs.job_card.part_time
    Are you a data-driven professional with a passion for healthcare analytics? This healthcare organization is keeping on the forefront of emerging technologies to help with decisioning and predictive...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Management Data Analyst, Senior Specialist

    Management Data Analyst, Senior Specialist

    Vets HiredPomona, CA, US
    serp_jobs.job_card.full_time
    Management Data Analyst, Senior Specialist.The Management Data Analyst, Senior Specialist supports strategic decision-making by managing data processes, reporting, and analytics.This role is respon...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Analyst (SQL)

    Data Analyst (SQL)

    Mutual of Omaha MortgageIrvine, CA, US
    serp_jobs.job_card.full_time
    Compensation Range : $60,000 - $70,000.The Mortgage Business Intelligence & Analytics team oversees all activities and functions involved with the company’s Business Intelligence platform,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Analyst Lead

    Data Analyst Lead

    DatafiedAnaheim, CA, US
    serp_jobs.job_card.full_time
    We are seeking a highly motivated and experienced.This role combines hands-on data analysis with team leadership and project coordination. The ideal candidate will not only possess strong technical ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    B2B Data Analyst (Sales Support)

    B2B Data Analyst (Sales Support)

    TP-Link Systems Inc.Irvine, CA, US
    serp_jobs.job_card.full_time
    TP-Link is currently seeking a Data Analyst for our Irvine, CA.This position is an onsite role.Headquartered in the United States, TP-Link Systems Inc. The company is committed to delivering innovat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    Data Analyst (Ops Finance)

    Data Analyst (Ops Finance)

    Panda Restaurant GroupRosemead, CA, US
    serp_jobs.job_card.full_time +1
    The Data Analyst position is responsible for supporting the company’s overall data strategy by working with other business units to develop periodic reporting, metrics, and measurements to determin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Quick Earnings : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    Quick Earnings : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    UberDana Point, CA, United States
    serp_jobs.job_card.full_time +1
    Earn at least $1405 driving with Uber when you complete your first 132 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    SQL Developer_only on W2

    SQL Developer_only on W2

    Chelsoft Solutions CoSanta Ana, CA, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Database Developer serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Data Analyst

    Data Analyst

    DT Professional ServicesCorona, CA, US
    serp_jobs.job_card.full_time
    DT Professional Services is seeking an entry-level Data Analyst to join our team in Norco, CA! In this role, you will analyze structured and unstructured data to uncover trends, patterns, and insig...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Senior Data Analyst - Excel Automation & BI Specialist

    Senior Data Analyst - Excel Automation & BI Specialist

    Eggs UnlimitedIrvine, CA, US
    serp_jobs.job_card.full_time
    Eggs Unlimited is one of the world’s largest suppliers of eggs, servicing the biggest retail and food manufacturing companies around the globe. Every day, we find homes for millions of eggs by...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Systems Analyst 4-HB Enterprise Reporting-FT-Day

    Data Systems Analyst 4-HB Enterprise Reporting-FT-Day

    University of California - Irvine HealthAnaheim, California, United States
    serp_jobs.job_card.full_time
    University of California, Irvine, and the only academic health system based in Orange County.UCI Health is comprised of its main campus, UCI Medical Center, a 459-bed, acute care hospital in in Ora...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Analyst

    Data Analyst

    OMEGA INCOME TAX SERVICESan Bernardino, CA, US
    serp_jobs.job_card.full_time
    Data Analysts collect data, income and expenses, are able to.A data analyst collects, cleans, and interprets data sets in order to answer a question or solve a problem work encompasses several duti...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    DATA ANALYST ENGINEER I

    DATA ANALYST ENGINEER I

    VSolvitNorco, CA, US
    serp_jobs.job_card.full_time
    Data Analyst Engineer I – Onsite Role in Norco, CA.The Data Analyst Engineer I will provide critical support to Navy operations by developing, maintaining, and enhancing data visualization, r...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    UberDana Point, CA, United States
    serp_jobs.job_card.full_time +1
    Earn at least $1405 driving with Uber when you complete your first 132 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Drive With Uber : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    Drive With Uber : Earn At Least $1405 For Your First 132 Trips, Guaranteed.

    UberDana Point, CA, United States
    serp_jobs.job_card.full_time +1
    Earn at least $1405 driving with Uber when you complete your first 132 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Steward / Analyst

    Data Steward / Analyst

    University of California - IrvineIrvine, California, United States
    serp_jobs.job_card.full_time
    Association of American Universities and is ranked among the nation's top 10 public universities by U.The campus has produced five Nobel laureates and is known for its academic achievement, premier...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Research Data Analyst 3

    Research Data Analyst 3

    University of California - IrvineIrvine, California, United States
    serp_jobs.job_card.full_time
    Association of American Universities and is ranked among the nation's top 10 public universities by U.The campus has produced five Nobel laureates and is known for its academic achievement, premier...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days