Remote Data & BI Analyst – Mortgage Insights & Dashboards

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

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.