Talent.com
Data Analyst (SQL)

Data Analyst (SQL)

Mutual of Omaha MortgageIrvine, CA, US
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Data Analyst (SQL) 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, 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.
  • We offer an extensive compensation package.
  • Benefits include Medical, Dental, and Vision insurance, company paid life insurance, 401K with a generous employer match and additional benefits such as Free Legal Services and an Employee Loan Program.
  • Mutual of Omaha Mortgage is an Equal Opportunity Employer and we encourage diverse, talented, qualified applicants to apply.   Applicants must be authorized to work in the US without the need for sponsorship.  Powered by JazzHR

    serp_jobs.job_alerts.create_a_job

    Data Analyst • Irvine, CA, US

    Job_description.internal_linking.related_jobs
    • 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_30
    • serp_jobs.job_card.promoted
    Senior Master Data Analyst, Supply Chain

    Senior Master Data Analyst, Supply Chain

    AndurilCosta Mesa, CA, US
    serp_jobs.job_card.full_time
    Senior Master Data Analyst, Supply Chain.Anduril Industries is a defense technology company with a mission to transform U. By bringing the expertise, technology, and business model of the 21st centu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Management Analyst (Municipal Services)

    Management Analyst (Municipal Services)

    Government JobsMurrieta, CA, US
    serp_jobs.job_card.full_time
    The City of Murrieta's new Municipal Services Department is seeking a detail-oriented and innovative Management Analyst to help shape the future of its public services. This pivotal role will be ins...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Accounting / Financial Data Analyst

    Accounting / Financial Data Analyst

    JobotLakewood, CA, US
    serp_jobs.job_card.full_time +1
    Accounting / Financial Data Analyst, banking / financial services, Credit Risk and Opertional Risk.This Jobot Job is hosted by : David Hyon. Are you a fit? Easy Apply now by clicking the "Apply Now" butt...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Data Analyst III - Transportation Management Systems

    Data Analyst III - Transportation Management Systems

    Glidewell DentalIrvine, CA, US
    serp_jobs.job_card.full_time
    Manages day-to-day results reporting and visualization through research and analysis of data.Analyzes data to discover and interpret trends, patterns, and relationships. Develops and provides effect...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Server Assistant, 33 North - Waldorf Astoria Monarch Beach Resort and Club

    Server Assistant, 33 North - Waldorf Astoria Monarch Beach Resort and Club

    HiltonDana Point, CA, United States
    serp_jobs.job_card.full_time
    The award-winning Forbes 4-Star and AAA 5-DiamondWaldorf Astoria Monarch Beach Resort & Club is looking for a.Located in the beautiful coastal town of Dana Point adjacent to Laguna Beach, this town...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_30
    • serp_jobs.job_card.promoted
    Relationship Banker - Orange County South Market

    Relationship Banker - Orange County South Market

    Bank of AmericaSan Clemente, CA, US
    serp_jobs.job_card.full_time
    Bank of America Financial Center Representative.At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection.We do this by driving...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • 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
    Medical Scribe

    Medical Scribe

    Rancho Health MSO, IncMurrieta, CA, US
    serp_jobs.job_card.full_time
    The intent of this job description is to provide a summary of the major duties and responsibilities performed in this job. Incumbents may be requested to perform job-related tasks other than those s...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Survey Taker : Earn up to $25 per survey (Remote)

    Survey Taker : Earn up to $25 per survey (Remote)

    Earn HausLakeland Village, CA, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Logistics Analyst IV

    Logistics Analyst IV

    Clearance JobsSan Clemente, CA, US
    serp_jobs.job_card.full_time
    The Logistics Analyst IV plays a critical role in enhancing product workflow by developing and analyzing logistics plans that impact production, distribution, and inventory.This position ensures op...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Assistant Manager (P1-1382881-1)

    Assistant Manager (P1-1382881-1)

    Panda Restaurant GroupSan Clemente, CA, US
    serp_jobs.job_card.full_time
    Assistant Manager Opportunity At Panda Express.Are you craving a career with an industry leader? Panda Express is searching for experienced leaders to join our store management team.Panda is 100% c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • 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_30
    • serp_jobs.job_card.promoted
    LEAD SYSTEMS AND DATABASE ADMINISTRATOR

    LEAD SYSTEMS AND DATABASE ADMINISTRATOR

    VSolvit LLCNorco, CA, US
    serp_jobs.job_card.full_time
    Lead Systems & Database Administrator – Onsite - Norco, CA Job Summary : We are seeking two experienced and security-clearedDatabase Administrator (DBA) and System Administrator (SysAdmin) Leadto ov...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    DATA ANALYST ENGINEER I

    DATA ANALYST ENGINEER I

    VSolvit LLCNorco, CA, US
    serp_jobs.job_card.full_time
    Data Analyst Engineer I – Onsite Role in Norco, CA Job Summary : The Data Analyst Engineer I will provide critical support to Navy operations by developing, maintaining, and enhancing data visualiza...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • 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
    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 Engineer

    Data Engineer

    AMEN CLINICS, INC., A MEDICAL CORPORATIONCosta Mesa, CA, US
    serp_jobs.job_card.full_time
    The Database Administrator assists with development and maintenance of SQL databases and development of business intelligence applications, DBA responsibility including data modeling, performance, ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Online Survey Taker. Earn up to $25 per survey. - Remote

    Online Survey Taker. Earn up to $25 per survey. - Remote

    Earn HausSan Clemente, California, US
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are urgently looking for people interested in taking online surveys for Fortune 500 brands.If you are a self-starter, looking for flexible hours throughout the week, this may be for you! Earn up...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30