Business Intelligence Analyst II

About The Company

Carrington Mortgage Services-Retail Lending is a distinguished part of The Carrington Companies, renowned for providing innovative mortgage solutions tailored to a diverse clientele. The company specializes in offering a comprehensive range of home purchase and refinance products, including government and conventional loan programs. With a focus on underserved markets, Carrington Mortgage Services caters to borrowers with less-than-perfect credit histories and low down payments, emphasizing accessibility and affordability in homeownership. Committed to transforming residential real estate, Carrington leverages cutting-edge technology, a customer-centric approach, and a talented team of professionals.

About The Role

We are seeking a skilled Business Reporting Analyst to join our dynamic team within the Mortgage Lending Division (MLD). This mid-level role is instrumental in developing and maintaining complex reports and dashboards, performing detailed data analysis, and identifying trends that support strategic decision-making. The ideal candidate will collaborate closely with cross-functional teams to gather requirements, streamline reporting processes, and ensure compliance with all applicable policies, investor guidelines, and US federal and state laws. The role requires a solid understanding of business operations, data structures, and business intelligence (BI) tools such as Power BI, SSRS, and SQL.

Qualifications

• Proficiency in Excel and familiarity with data visualization tools such as Power BI and SSRS
• Intermediate knowledge of Power BI, SSRS, and SQL
• Strong communication and collaboration skills
• Excellent organizational skills and attention to detail
• Analytical and problem-solving capabilities with the ability to interpret data and generate insights
• Experience working with large datasets and relational databases
• Knowledge of residential mortgage lending data and terminology
• Ability to manage multiple tasks and meet deadlines in a fast-paced environment
• Experience translating business questions into analytical queries and visualizations
• Experience with Agile or project-based environments (e.g., Jira)
• Experience developing and maintaining data dictionaries or business glossaries
• High school diploma or GED; Bachelor’s degree in Business, Finance, Economics, Data Analytics, or related field preferred
• 2-4 years of experience as a Business Reporting Analyst or similar role
• Minimum two years of experience in the Residential Mortgage Industry
• Microsoft Power BI Certification preferred

Responsibilities

• Collaborate with business units to gather reporting requirements and deliver actionable insights that support operational and strategic goals
• Coordinate regulatory reporting requirements, including HMDA, Fair Lending Analysis, and other federal and state-mandated reports, ensuring accuracy and timeliness
• Assist in responding to regulatory findings by providing supporting data and analysis
• Analyze data to identify trends, variances, and opportunities for operational improvements
• Perform data validation and analysis to ensure report accuracy, developing exception reports as needed
• Develop and maintain recurring and ad hoc reports using BI tools such as Power BI, SSRS, and SQL
• Automate manual reporting processes to increase efficiency and reduce errors
• Support the development of a comprehensive data dictionary for Mortgage Lending data, documenting procedures and processes
• Provide training and ongoing support to business users on reporting tools and data interpretation
• Maintain documentation of report procedures and ensure compliance with regulatory standards

Benefits

• Comprehensive healthcare plans for employees and their families
• Discretionary 401(k) plan with a 50% match on the first 4% of contributions
• Access to employee discounts on fitness memberships, dining, retail, and more through our employee portal
• Customized training programs aimed at career development and progression
• Employee referral bonuses to incentivize internal talent growth
• Educational reimbursement programs to support ongoing learning
• Participation in the Carrington Charitable Foundation, supporting community initiatives and causes

Pay

The target compensation for this position ranges from $75,000 to $95,000 annually, reflecting the responsibilities and expertise required.