Data Analyst

Data Analyst

Department: Servicing

Employment Type: Full Time

Location: Bloomington, MN

Reporting To: Vice President of Servicing Analytics

Compensation: $70,000 - $80,000 / year

Description

Verus Mortgage Capital is seeking a skilled Fixed Income Analyst with experience in Visual Basic for Applications (VBA) and using SQL.  The ideal candidate will have a strong interest in fixed income mortgage portfolio management and asset management combined with the ability to analyze datasets, automate processes, develop initial models in Excel using VBA and develop initial dashboards in PowerBI.  This role requires strong analytical skills, understanding of programming constructs and SQL, the ability to communicate effectively with stakeholders and a strong fundamental understanding of mortgage finance.  

Responsibilities and Duties:

Data Analysis & Reporting

• Collect, clean, and analyze large datasets to identify trends, patterns, and insights.
• Develop interactive dashboards and reports using SQL, Excel VBA, Power BI, or other BI tools.
• Design and maintain automated reporting processes to improve efficiency.
• Interpret data to support business decisions and performance improvements.

VBA & Automation

• Write and optimize VBA scripts to automate repetitive tasks and improve data processing efficiency.
• Develop macros and custom functions to enhance Excel-based tools and reports.
• Maintain and troubleshoot existing VBA applications to ensure optimal functionality.

Business Intelligence & Process Improvement

• Collaborate with cross-functional teams to translate business requirements into analytical solutions.
• Provide actionable insights and recommendations based on data findings.
• Conduct thorough user acceptance testing for process enhancements.
• Identify opportunities to streamline processes and improve operational efficiencies through automation.

Education and Experience:

• Bachelor’s degree 
• Understanding of discounted cash flows and fixed income calculations.  
• Hands-on experience in Visual Basic programming, SQL, and data automation projects.
• 2+ years of experience as a Data Analyst, Business Analyst, or related role in fixed income or mortgage finance

Key Competencies
• Analytical Thinking: Demonstrated ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Technical Proficiency: Proficient in Excel VBA, SQL, and BI tools such as Power BI, with a strong understanding of data structures and automation techniques.• Collaboration & Influence: Proven track record of working cross-functionally to solve problems, align goals, and influence outcomes.
• Adaptability & Initiative: Self-starter who thrives in a fast-paced environment, welcomes new challenges, and proactively seeks opportunities for improvement and growth.

How this Role Demonstrates Our Core Values:

• Integrity: Upholds data accuracy, confidentiality, and consistency. Acts with honesty and transparency in all reporting and analysis efforts.
• Critical Curiosity: Digs beyond surface-level data to ask thoughtful questions, challenge assumptions, and explore the "why" behind trends and metrics.
• Collaboration: Works cross-functionally to understand business needs, co-create solutions, and foster a team-oriented approach to data and process improvement.
• Excellence: Delivers thoughtful, high-impact work with attention to detail. Continuously seeks out ways to improve efficiency, effectiveness, and the quality of insights.

Benefits

• Great compensation package
• Attractive benefits plans and paid time off
• 401(k) w/ company matching
• Professional learning and development opportunities
• Tuition Reimbursement
• And much more!

Successful applicants will exemplify strong ethics, integrity, respect for others, accountability for decisions and actions, and good citizenship.

Maintaining a reliable, uninterrupted high speed internet connection is a requirement of hybrid or remote positions.

All job duties and responsibilities must be performed within the guidelines of the Verus Residential Mortgage Employee Handbook and established company policies and procedures. It is the responsibility of each employee to maintain confidentiality of the company, its clients and to follow applicable laws and regulations in the performance of duties.

Verus Mortgage Capital is an equal opportunity employer. All qualified applicants are welcomed to apply and will receive consideration for employment without unlawful discrimination because of a person’s race, religious creed, color, national origin, citizenship status, ancestry, marital status, sex, age, or sexual orientation, or because of a person’s disability or medical condition.