Mortgage Data Analyst

Central Bancompany - Columbia, MO

Full-time

Columbia, MO

Management of Companies and Enterprises

About the position

The Mortgage Data Analyst will be a key player in the mortgage systems unit, focusing on data-driven decision-making within the mortgage department. This role involves extracting, analyzing, and interpreting complex mortgage data to track key performance indicators, ultimately supporting the department's strategic goals. The ideal candidate will have strong Excel skills and a passion for data analysis, with the ability to adapt to new technologies.

Responsibilities

• Utilize SQL, Excel, and other relevant tools to extract and transform mortgage data from various sources.
• Partner with business teams to understand their data needs and provide tailored analysis and reporting solutions.
• Calculate secondary market margins and build/maintain financial and statistical models.
• Employ statistical methods and data visualization techniques to analyze mortgage data and identify trends, patterns, and anomalies.
• Develop clear and informative reports, dashboards, and visualizations to communicate data-driven insights to stakeholders.
• Identify opportunities to improve data quality, efficiency, and accuracy through data governance and process optimization.

Requirements

• Bachelor's degree in a quantitative field (e.g., Statistics, Mathematics, Economics, Finance) or equivalent work experience.
• Advanced knowledge of Microsoft Excel, including data analysis, visualization tools, and VBA.
• Ability to learn and master various software applications.
• Excellent organizational and time management skills.
• Strong attention to detail and accuracy.

Nice-to-haves

• Working knowledge of large data manipulation and data mining using intermediate to advanced SQL.
• Experience with Tableau or other data visualization tools.
• Proficiency in programming languages such as C#, VBA, or Python.
• Familiarity with statistical analysis for financial modeling and forecasting.
• Experience in the mortgage industry, including secondary market operations or loan origination.