Talent.com
Data Analyst (SQL)

Data Analyst (SQL)

Mutual of Omaha MortgageOmaha, NE, US
30+ days ago
Job type
  • Full-time
  • Quick Apply
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

    Create a job alert for this search

    Data Analyst • Omaha, NE, US

    Related jobs
    • Promoted
    • New!
    Risk Adjustment Data Analyst

    Risk Adjustment Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Risk Adjustment Data Analyst to develop and maintain data processes and analytics related to the CMS HCC risk adjustment model for the Medicare population.Key Responsibil...Show moreLast updated: 15 hours ago
    • Promoted
    Data Analytics Consultant

    Data Analytics Consultant

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Data Analytics Consultant I.Key Responsibilities Makes business insights from data analytics accessible to non-technical stakeholders Communicates project information ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Governance Analyst-Remote

    Senior Data Governance Analyst-Remote

    SentaraOmaha, NE, United States
    Remote
    Full-time
    Supports executive leadership and Vice Presidents on the Data Governance Council to drive the data governance program across the enterprise. Helps lead and coordinate major initiatives in support of...Show moreLast updated: 3 days ago
    • Promoted
    Staff Data Analyst

    Staff Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Staff Data Analyst with strong FinOps experience to support Data Platform / Engineering teams. Key Responsibilities Analyze cloud spend and identify optimization opportuni...Show moreLast updated: 30+ days ago
    • Promoted
    Master Data Analyst

    Master Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Master Data Analyst to provide analysis and recommend solutions on data challenges.Key Responsibilities Work with business owners to analyze data challenges and recomme...Show moreLast updated: 30+ days ago
    • Promoted
    Data Management Analyst

    Data Management Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Data Management Analyst responsible for data analysis and management within the Engineering Decision Support department. Key Responsibilities Interface with stakeholders...Show moreLast updated: 30+ days ago
    • Promoted
    Data Analyst

    Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Data Analyst to support decision-making and enhance organizational tools through data analysis. Key Responsibilities Improve and manage the organizational learning machi...Show moreLast updated: 30+ days ago
    • Promoted
    Data Analyst III

    Data Analyst III

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Data Analyst III responsible for handling complex data projects and leading other Data Analysts. Key Responsibilities Provide advanced analytical support for business op...Show moreLast updated: 30+ days ago
    • Promoted
    Product Data Analyst

    Product Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Product Data Analyst to join their team.Key Responsibilities Identify the causes of changes in business process dynamics Analyze user behavior and discover hidden patt...Show moreLast updated: 30+ days ago
    • Promoted
    Healthcare Analytics Senior Analyst

    Healthcare Analytics Senior Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Senior Analyst, Healthcare Analytics - SQL / Power BI - Remote.Key Responsibilities Conduct research and analysis of complex healthcare claims, pharmacy, and lab data to ...Show moreLast updated: 30+ days ago
    • Promoted
    Remote Financial Analyst - AI Trainer

    Remote Financial Analyst - AI Trainer

    Data AnnotationBellevue, Nebraska
    Remote
    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 q...Show moreLast updated: 26 days ago
    • Promoted
    Senior Business Data Analyst

    Senior Business Data Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Senior Business Data Analyst to join their Data Science and Analytics group.Key Responsibilities Partner with cross-functional teams to understand business needs and de...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Epic Certified Reporting Analyst

    Epic Certified Reporting Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for an Epic Reporting Analyst to support internal stakeholders by developing and maintaining reports and resolving data requests. Key Responsibilities Develop and maintain rep...Show moreLast updated: 15 hours ago
    • Promoted
    Compliance and Data Analyst

    Compliance and Data Analyst

    FiservOmaha, NE, US
    Full-time
    Calling all innovators find your future at Fiserv.We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial instit...Show moreLast updated: 30+ days ago
    • Promoted
    SQL Database Administrator

    SQL Database Administrator

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a System Administrator III - SQL Database Administrator.Key Responsibilities Administer SQL databases for Lenel and CCURE 9000 Manage content flow between access control...Show moreLast updated: 30+ days ago
    • Promoted
    Senior BI Analyst

    Senior BI Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a Senior Business Intelligence (BI) Analyst to guide data-driven decision-making across various departments. Key Responsibilities Lead the development and alignment of key...Show moreLast updated: 30+ days ago
    • Promoted
    Enterprise Data Architect

    Enterprise Data Architect

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for an Enterprise Data Architect to lead the design and governance of scalable data strategies.Key Responsibilities Lead the design and implementation of enterprise-scale dat...Show moreLast updated: 20 days ago
    • Promoted
    BI Analyst

    BI Analyst

    VirtualVocationsOmaha, Nebraska, United States
    Full-time
    A company is looking for a BI Analyst with strong knowledge of SQL and Tableau.Key Responsibilities Develop and maintain dashboards and reports using Tableau, SQL, and Python Collaborate with va...Show moreLast updated: 1 day ago