Real Estate Lending Data & Reporting Analyst

Jobtailor; Town of Florida (NY); On-site; USD 70,000 - 100,000; Full time

Job summary

BRMi is seeking a data analytics professional in the United States to create and maintain QCRM reports and dashboards using Power BI, SQL, and ACES tools. The role emphasizes data validation, quality control, and governance while partnering across teams to meet recurring reporting deadlines.

The ideal candidate will translate business needs into clear report specifications, analyze trends, and support audit-ready documentation. This position is W2 with no visa sponsorship in scope.

Qualifications

• 2 to 5 years of experience in data analysis, reporting, business intelligence, quality control reporting, risk reporting, operational analytics, or a related field.
• Basic understanding of business operations, quality control processes, risk management, reporting lifecycles, or mortgage/servicing-related business functions.
• Effective skill using business intelligence applications, reporting platforms, dashboard tools, spreadsheet applications, cloud-based reporting tools, or data visualization tools.
• Knowledge of data cleaning, validation, reconciliation, data structures, data quality practices, and data manipulation techniques.
• Ability to translate business needs into report specifications, required data elements, intended audiences, data source requirements, and user-friendly reporting outputs.
• Ability to apply research, analytical thinking, and problem-solving skills to identify trends, validate results, explain variances, and support root cause analysis.
• Strong attention to detail, sound judgment, effective written and verbal communication skills, and ability to meet recurring reporting deadlines.
• Ability to influence decisions, build partnerships, and communicate effectively with stakeholders at all organizational levels.
• Ability to collaborate across teams, manage multiple priorities, document work clearly, and escalate issues when data, access, reporting logic, or business requirements are unclear.
• BRMi will not sponsor applicants for work visas for this position
• This is a W2 opportunity only

Responsibilities

• Create, refresh, validate, and distribute recurring QCRM reports and dashboards
• Analyze QC results, trends, defects, exceptions, AOR responses, operational patterns, and emerging risks
• Apply data validation, cleaning, reconciliation, and quality control techniques
• Maintain documented validation, approval, and evidence records
• Use Power BI, ACES reporting functionality, SQL, Excel, Power Query, approved data sources, and other reporting tools
• Facilitate requirements discussions with QCRM leaders, analysts, business partners, technology partners, and data teams
• Support intake and tracking of reporting, dashboard, data, system access, and user validation requests
• Assist with ACES reporting and administration, including access requests, role updates, AOR manager updates, ACES Connect support, reporting, imports, and system changes
• Support QCRM access governance and escalate unclear or unusual requests
• Develop and maintain reporting procedures, job aids, technical documentation, validation checklists, communication templates, and audit-ready materials
• Support audit, exam, investor, regulatory, and management requests
• Identify reporting gaps, data quality issues, process inefficiencies, calculation errors, access concerns, and documentation needs
• Participate in modernization initiatives including report automation, ACES data import improvements, Power BI dashboard migration, ACES FIRE/data ingestion work, and reporting enhancements
• Communicate findings, updates, risks, report changes, data limitations, and recommended actions to peers, leaders, and stakeholders

Skills

Data Analysis

Power BI

SQL

Quality Control Reporting

Risk Management Reporting

Data Validation

Data Cleaning

Data Reconciliation

Data Quality Practices

Report Automation

Dashboard Development

Technical Documentation

Analytical Thinking

Problem-Solving

Data Manipulation Techniques

Education

Bachelor’s degree in Business Administration, Statistics, Data Analytics, Information Systems, Risk Management, or related field

Tools

Power BI

SQL

Excel

Power Query

ACES

Business Objects

SharePoint

ADO

Workflow Intake Tools

Cloud-Based Reporting Tools

Job description

BRMi is seeking a data analytics professional in the United States to create and maintain QCRM reports and dashboards using Power BI, SQL, and ACES tools. The role emphasizes data validation, quality control, and governance while partnering across teams to meet recurring reporting deadlines.

The ideal candidate will translate business needs into clear report specifications, analyze trends, and support audit-ready documentation. This position is W2 with no visa sponsorship in scope.