POSITION SUMMARY:

We are seeking a Business Intelligence Analyst to join our growing and dynamic team.

As part of the Business Intelligence Team, your responsibilities will include managing and enhancing the in-house mortgage loan database, creating performance and investor reports and dashboards, implementing data management protocols and systems, and writing queries to generate ad-hoc reports for research as needed. Analysts must be proficient at manipulating and analyzing large sets of data and have a good knowledge of fixed income mathematics and statistics.

This is a small team, and any candidate must be a team-player, able and willing to work on cross-over projects, able to pick up complex concepts and communicate effectively to both internal and external constituents. The position will allow the candidate to collaboratively work across the Company's cross-functional teams (Data Research & Reporting, Trading & Analytics, Asset Management, Capital Markets, Transaction Management, and Collateral Management) and to learn from the firm's industry leading professionals. The ideal candidate will be intellectually curious, a self-starter, have a strong attention to detail, and be able to work under time sensitive deadlines.

ESSENTIAL DUTIES:

• Reconciliation of monthly loan servicer cash reporting and other loan attributes;
• Coordinates and communicate with data providers to reconcile data in a timely manner;
• Produces monthly cash flow reporting for internal and external stakeholders;
• Identifies data errors and reviews findings with more senior team members;
• Learning and maintaining proprietary mortgage database in Microsoft SQL;
• Develop SQL scripts that improve the efficiency of processes, analysis, and reporting;
• Ensures the accurate compilation, analysis and reporting of data;
• Running analyses using in house software tools;
• Identifies markets for future development and methods to improve existing products by analyzing technology trends;
• Automation of monthly portfolio performance reconciliations and Data Quality Control; and
• Any ad hoc analysis that may be requested.

EXPERIENCE, QUALIFICATIONS, AND SKILLS:

• Education: Bachelor's degree from a top undergraduate program.
• Experience: 2-6 years of experience with data analytics.
• Excellent organization skills with strong attention to detail.
• Strong knowledge of Excel/VBA.
• Familiarity with SQL is a plus.
• Experience using BI tools and building dynamic reporting dashboard (Tableau, superset, etc.)
• Exceptional verbal, written and interpersonal communication skills with the ability to apply common sense to carry out instructions and instruct others, train personnel, write reports, correspondence and procedures, speak clearly to customers and employees.
• Ability to deal with advanced problems involving multiple facets and variables in standardized or specialty situations.
• Excellent written and verbal communication skills are required.

BENEFITS:

• 4 weeks of PTO
• Medical, dental, and vision insurance
• 401(k) retirement plan matching
• Charitable giving employee matching program
• Continuing education and professional certification expense reimbursement
• 13 paid holidays

We are committed to maintaining a positive and collaborative work environment that is safe and respectful of others; our shared success depends on it.