Analyst, Business Intelligence, MLD, II

Carrington; Frankfort (KY); Remote; USD 75,000 - 95,000; Full time

Benefits offered by this job

Healthcare plans

Discretionary 401(k) match

Employee discounts via portal

Educational reimbursement

Charitable foundation involvement

Job summary

Carrington Mortgage Services is seeking a mid-level BI Reporting Analyst to develop and maintain reports and dashboards for the Mortgage Lending Division. You will collaborate with business units, ensure regulatory reporting timeliness, analyze data for trends, and automate processes using Power BI, SSRS, and SQL.

The role requires Excel proficiency, familiarity with BI tools, and strong communication—plus experience with large datasets and mortgage data knowledge.

Qualifications

• Proficiency in Excel and familiarity with data visualization tools (Power BI, SSRS).
• Intermediate knowledge of Power BI, SSRS, and SQL.
• Strong communication skills and ability to collaborate with cross-functional teams.
• Strong organizational skills and attention to detail.
• Strong analytical and problem-solving skills with the ability to interpret data and provide insights.
• Team-player with self-motivation and ability to work independently.
• Experience with large datasets and relational databases.
• Working knowledge of residential mortgage lending data/terminology.
• Ability to manage multiple tasks and meet deadlines in a fast-paced environment.
• Translate business questions into analytical queries and visualizations.
• Experience with Agile or Jira.
• Experience developing data dictionaries or glossaries.

Responsibilities

• Collaborate with business units to gather reporting requirements and deliver actionable insights.
• Coordinate regulatory reporting requirements (HMDA, Fair Lending, state/federal) and support findings with data.
• Analyze data to identify trends and opportunities for operational improvement.
• Perform data validation and develop exception reports for accuracy.
• Develop and maintain recurring and ad hoc reports using BI tools (Power BI, SSRS, SQL).
• Automate manual reporting processes to improve efficiency and reduce errors.
• Support development of a data dictionary for Mortgage Lending data and document report procedures.
• Provide training and support to business users on reporting tools.

Skills

Excel

Power BI

SSRS

SQL

Data analysis

Education

Bachelor's degree in Business, Finance, Economics, Data Analytics, or related field

High school diploma/GED or equivalent

Tools

Power BI

SSRS

SQL

Job description

Join our amazing team and work Remote !

Responsible for developing and maintaining moderately complex reports and dashboards, performing in-depth data analysis, and identifying trends to support decision-making within the Mortgage Lending Division ("MLD"). Collaborates with cross-functional teams to gather requirements and improve reporting processes. Perform all duties in accordance with the company’s policies and procedures, investor guidelines, all US state and federal laws and regulations, wherein the company operates. This mid-level role requires a solid understanding of business operations, data structures, and BI tools. The target pay range for this position is $75,000 to $95,000.

What you'll do:

• Collaborate with business units to gather reporting requirements and deliver actionable insights.

• Coordinate regulatory reporting requirements as needed and ensure the timeliness and accuracy of the reporting requirements (i.e., HMDA, Fair Lending Analysis, state, and federal required reporting) also assist in responding to findings and provide supporting data to internal committee.

• Analyze data to identify trends, variances, and opportunities for operational improvement.

• Perform data validation and analysis of all reportable data to ensure accuracy and develop exception reports.

• Develop and maintain recurring and ad hoc reports using BI tools (e.g., Power BI, SSRS, SQL, etc.).

• Automate manual reporting processes to improve efficiency and reduce errors.

• Responsible for supporting the development of a data dictionary for Mortgage Lending data and properly documenting the procedures and process of reports developed.

• Provide training and support business users on reporting tools.

What you'll need:

• Proficiency in Excel and familiarity with data visualization tools (e.g., Power BI, SSRS).

• Intermediate knowledge of Power BI, SSRS, and SQL

• Strong communication skills and ability to collaborate with cross-functional teams.

• Strong organizational skills and attention to detail

• Strong analytical and problem-solving skills with the ability to interpret data and provide insights.

• Team-player with strong communication and interpersonal skills possess a high degree of self-motivation and ability to work independently with minimal supervision.

• Experience working with large datasets and relational databases.

• A strong working knowledge of residential mortgage lending data and/or terminology

• Ability to manage multiple tasks and meet deadlines in a fast-paced environment.

• Ability to translate business questions into analytical queries and visualizations.

<

• Experience with Agile or project-based work environments (e.g., Jira).

• Experience developing and maintaining data dictionaries or business glossaries.

• High school diploma/GED or equivalent job experience in business intelligence, report development, data analysis, data integration or information management. Bachelor's degree in Business, Finance, Economics, Data Analytics, or a related field

• preferred. Two (2) to four (4) years' experience as a Business Reporting Analyst I and/or similar role.

• A minimum of two (2) years in the Residential Mortgage Industry experience.

• Microsoft Power BI Certification is preferred.

Our Company:

Carrington Mortgage Services-Retail Lending is part of The Carrington Companies. We offer a wide variety of home purchase and refinance products for government and conventional loan programs, specializing in underserved programs for borrowers with less than perfect credit and low down payment. We hope you'll consider joining our growing team of uniquely talented professionals as we transform residential real estate. To read more visit: www.carringtonmortgage.com .

What is the value proposition to joining the team?

• Full array of mortgage programs.

• Paperless loan file flow and process.

• Aggressive Marketing support including brochures, social media, and CRM.

• Aggressive underwriting; we manual underwrite over 80% of our files.

• Warm exclusive leads.

• Ability to originate nationally.

• Competitive compensation plan, including a base plus commission.

What We Offer:

• Comprehensive healthcare plans for you and your family. Plus, a discretionary 401(k) match of 50% of the first 4% of pay contributed.

• Access to several fitness, restaurant, retail (and more!) discounts through our employee portal.

• Customized training programs to help you advance your career.

• Employee referral bonuses so you'll get paid to help Carrington and Vylla grow.

• Educational Reimbursement.

• Carrington Charitable Foundation contributes to the community through causes that reflect the interests of Carrington Associates. For more information about Carrington Charitable Foundation, and the organizations and programs, it supports through specific fundraising efforts, please visit: carringtoncf.org.

California Privacy Notice: https://oag.ca.gov/privacy/ccpa

Notice to all applicants: Carrington does not do interviews or make offers via text or chat.

Carrington is an equal opportunity employer. It is the policy of the company that applicants be considered for positions for which they qualify without regard to race, color, religion, sex, gender identity, national origin, ancestry, age, marital status, sexual orientation, protected veterans status, physical or mental disability or any other legally protected category. Carrington will make reasonable accommodations for known physical or mental limitations of a qualified applicant or employee with a disability unless the accommodation will impose an undue hardship on the company.