Talent.com
Data Analyst (SQL)
Data Analyst (SQL)Mutual Of Omaha Mortgage • Omaha, Nebraska, United States
Data Analyst (SQL)

Data Analyst (SQL)

Mutual Of Omaha Mortgage • Omaha, Nebraska, United States
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[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.

    [job_alerts.create_a_job]

    Data Analyst • Omaha, Nebraska, United States

    [internal_linking.related_jobs]
    Insurance Data Analyst

    Insurance Data Analyst

    National Indemnity Company • Omaha, NE, United States
    [job_card.full_time]
    NICO National Indemnity Company.Want to work for a company with.Our companies, as members of the Berkshire Hathaway group of Insurance Companies, provides opportunities for professionals interested...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Engineer (Omaha)

    Senior Data Engineer (Omaha)

    Akkodis • Omaha, NE, US
    [job_card.part_time]
    Akkodis is searching for a Senior Data Engineer who has extensive experience with Databricks, Python, and PySpark.Any Data Engineer who has experience working with SAP data would be a tremendous fi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Nurse RN - Labor & Delivery - $2,155 to $2,293 per week in Blair, NE

    Travel Nurse RN - Labor & Delivery - $2,155 to $2,293 per week in Blair, NE

    TravelNurseSource • Blair, NE, US
    [job_card.full_time]
    TravelNurseSource is working with Fusion Medical Staffing to find a qualified Labor / Delivery RN in Blair, Nebraska, 68008!. Fusion Medical Staffing is seeking a skilled Labor and Delivery RN for a 1...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel CT Tech - $2,316 per week in Omaha, NE

    Travel CT Tech - $2,316 per week in Omaha, NE

    Atlas MedStaff • Bellevue, Nebraska, US
    [job_card.full_time]
    Atlas Medstaff is currently seeking candidates in the CT Tech (CT Tech) profession for a 13 week contract in the Omaha, Nebraska area. Atlas Medstaff is a premier staffing firm dedicated to matching...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Junior Data Analyst

    Junior Data Analyst

    Barbaricum • Omaha, Nebraska, United States
    [job_card.full_time]
    Barbaricum is a rapidly growing government contractor providing leading-edge support to federal customers, with a particular focus on Defense and National Security mission sets.We leverage more tha...[show_more]
    [last_updated.last_updated_30] • [promoted]
    NC3 Data Analyst

    NC3 Data Analyst

    Calvert Systems Engineering Inc • Bellevue, NE, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Location : Offutt AFB / Bellevue, NE.Minimum Clearance Required : Top Secret / SCI.This position requires the ability to obtain and maintain a Top Secret / SCI U. Citizenship status is required, as this pos...[show_more]
    [last_updated.last_updated_variable_days]
    Travel CT Tech - $2,316 per week in Omaha, NE

    Travel CT Tech - $2,316 per week in Omaha, NE

    AlliedTravelNetwork • Bellevue, Nebraska, US
    [job_card.full_time]
    AlliedTravelNetwork is working with Atlas MedStaff to find a qualified CT Tech in Omaha, Nebraska, 68124!.Atlas Medstaff is currently seeking candidates in the CT Tech (CT Tech) profession for a 13...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Analyst

    Data Analyst

    SunSoft Online • Arizona, Arizona, USA
    [job_card.full_time]
    This position is expected to work 20 hours a week.Seeking a skilled and detail-oriented Data Analyst to join to support statewide efforts to end veteran homelessness as part of the Homes to Heroes ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data & Reporting Analyst (Omaha)

    Data & Reporting Analyst (Omaha)

    Lutz • Omaha, NE, United States
    [job_card.full_time]
    Experienced (5-8 years of professional experience).Lutz is a business solutions firm, partnering with customers to provide expert advisory and compliance services in Accounting, Financial, Tech, M&...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Manager, Pharmacy Healthcare Analytics - Tableau / Power BI / SQL - Remote

    Manager, Pharmacy Healthcare Analytics - Tableau / Power BI / SQL - Remote

    Omaha Staffing • Omaha, NE, US
    [filters.remote]
    [job_card.full_time]
    Collects, validates, analyzes, and organizes data into meaningful reports for management decision making as well as designing, developing, testing, and deploying reports to provider networks and ot...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Cath Lab Tech - $2,458 to $2,825 per week in Omaha, NE

    Travel Cath Lab Tech - $2,458 to $2,825 per week in Omaha, NE

    Fusion Medical Staffing • Bellevue, Nebraska, US
    [job_card.full_time]
    Fusion Medical Staffing is seeking a skilled Cath Lab Tech for a 16-week travel assignment in Omaha, Nebraska.As a member of our team, you'll have the opportunity to make a positive impact on the l...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Data Annotation • Bellevue, Nebraska
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Analysis-NC3

    Data Analysis-NC3

    Client Server Software Solutions • 68113, NE, US
    [job_card.full_time]
    Nuclear Command, Control, and Communications (NC3) represents the capabilities which enable the President to exercise nuclear command and control authorities and the Department of Defense’s (...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Open Database Administrator

    Open Database Administrator

    SunSoft Online • Arizona, Arizona, USA
    [job_card.full_time]
    Hybrid Position • The Open Data Administrator will be responsible for collecting organizing evaluating and publishing datasets as well as collaborating with internal departments to ensure data quali...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel MRI Tech - $2,011 per week in Omaha, NE

    Travel MRI Tech - $2,011 per week in Omaha, NE

    Atlas MedStaff • Bellevue, Nebraska, US
    [job_card.full_time]
    Atlas Medstaff is currently seeking candidates in the MRI Tech (MRI Tech) profession for a 18 week contract in the Omaha, Nebraska area. Atlas Medstaff is a premier staffing firm dedicated to matchi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Manager, Pharmacy Healthcare Analytics - Tableau / Power BI / SQL - Remote

    Manager, Pharmacy Healthcare Analytics - Tableau / Power BI / SQL - Remote

    Nebraska Staffing • Omaha, NE, US
    [filters.remote]
    [job_card.full_time]
    Collects, validates, analyzes, and organizes data into meaningful reports for management decision making as well as designing, developing, testing, and deploying reports to provider networks and ot...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Engineer

    Senior Data Engineer

    Akkodis • Omaha, NE, United States
    [job_card.full_time]
    Akkodis is searching for a Senior Data Engineer who has extensive experience with Databricks, Python, and PySpark.Any Data Engineer who has experience working with SAP data would be a tremendous fi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel CT Tech - $2,205 to $2,534 per week in Winnebago, NE

    Travel CT Tech - $2,205 to $2,534 per week in Winnebago, NE

    AlliedTravelNetwork • Bellevue, Nebraska, US
    [job_card.full_time]
    AlliedTravelNetwork is working with Fusion Medical Staffing to find a qualified CT Tech in Winnebago, Nebraska, 68071!.Facility in Winnebago, Nebraska. Fusion Medical Staffing is seeking a skilled C...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]