Junior Business Intelligence Analyst

247Hire; Vienna (VA); On-site; USD 70,000 - 90,000; Full time

Job summary

247Hire is seeking a data reporting professional to create, refresh, and validate recurring QCRM reports and dashboards. You will analyze QC results and communicate insights to leadership, support governance, and assist with audit readiness and strategic decision-making.

The role requires 2–5 years in data analytics, BI or risk reporting, with strong skills in Power BI, SQL, Excel, and ACES tools. You will collaborate across teams to meet reporting deadlines and ensure data quality.

Qualifications

• 2 to 5 years of experience in data analysis, reporting, BI, quality control or risk reporting.
• Understanding of business operations, quality control processes, risk management, and reporting lifecycles.
• Ability to translate business needs into report specs, data elements, audiences and outputs.
• Ability to analyze trends, validate results, explain variances and support root cause analysis.
• Strong attention to detail and ability to meet recurring reporting deadlines.
• Ability to collaborate with stakeholders at all levels and manage multiple priorities.
• Bachelor’s degree or equivalent combination of education, training and experience.

Responsibilities

• Create, refresh, validate, and distribute recurring QCRM reports and dashboards.
• Executive, billable loan, reverification, overturned and unresolved reporting deliverables.
• Analyze QC results, trends, defects, exceptions, and risks to provide insights for leadership review.
• Support audit readiness, governance, and strategic/operational decision-making.
• Apply data validation, cleaning, reconciliation, and quality control before submission.
• Maintain validation records through approved QCRM documentation channels.
• Use Power BI, SQL, Excel, and other tools to build, refresh, troubleshoot, and improve outputs.
• Facilitate discussions with leaders, analysts, business partners, and data teams to gather requirements.
• Support intake and tracking of reporting requests via tools like ADO, Launchpad, Forms, and SharePoint.
• Assist ACES reporting and administration, including access governance and data imports.
• Process authorized user access requests and escalate unclear requests as needed.
• Understand data lineage, source-to-report traceability, change control, and governance practices.
• Develop and maintain reporting procedures, documentation, and audit-ready materials.
• Promote consistency, coverage, knowledge transfer, and process sustainability.
• Support audit, investor, regulatory requests with clear explanations and evidence.

Skills

Data analysis

Reporting

Business intelligence

Quality control reporting

Risk reporting

Operational analytics

Stakeholder communication

SQL

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

Job description

Key Responsibilities:

• Create, refresh, validate, and distribute recurring QCRM reports and dashboards, including monthly QC reporting, Front Line, Middle Management, Senior Management, Servicing
• Executive, billable loan, reverification, overturned and unresolved, and other assigned reporting deliverables.
• Analyze QC results, trends, defects, exceptions, AOR responses, operational patterns, and emerging risks to provide meaningful insights that support leadership review, coaching
• opportunities, business partner communication, audit readiness, and strategic and operational decision-making.
• Apply data validation, cleaning, reconciliation, and quality control techniques before reports are submitted for leadership review, management approval, portal posting, or business unit distribution.
• Maintain documented validation, approval, and evidence records by coordinating with Assistant Managers, Managers, and other designated reviewers through approved QCRM
• documentation channels.
• Use business intelligence tools, Power BI, ACES reporting functionality, SQL, Excel, Power Query, approved data sources, and other reporting tools to build, refresh, troubleshoot, and improve reporting output.
• Facilitate discussions with QCRM leaders, BIAs, analysts, business partners, technology partners, and data teams to gather requirements, define intended audiences, confirm data
• sources, determine refresh cadence, clarify report specifications, and align deliverables to business needs.
• Support intake and tracking of reporting, dashboard, data, system access, user validation, and related requests through approved tools such as ADO, Launchpad, Microsoft Forms,
• SharePoint, or other designated request management processes.
• Assist with ACES reporting and administration, including access requests, role updates, AOR manager updates, ACES Connect support, ACES Servicing and Origination reporting, import processes, and system changes that impact QCRM reporting or access governance.
• Support QCRM access governance by processing authorized user access requests, applying role-based guidance, documenting business justification where required, and escalating
• unclear or unusual requests before access changes are made.
• Understanding of data lineage, source-to-report traceability, change control, and reporting governance practices.
• Develop and maintain Reporting & Analytics procedures, job aids, technical documentation, validation checklists, communication templates, and audit-ready support materials to
• Promote consistency, backup coverage, knowledge transfer, and process sustainability.
• Support audit, exam, investor, regulatory, and management requests by compiling, validating, documenting, and explaining reporting outputs, data sources, calculations,
• assumptions, limitations, and supporting evidence in a clear and defensible manner.
• Identify reporting gaps, data quality issues, process inefficiencies, calculation errors, access concerns, or documentation needs, and recommend practical improvements that strengthen reporting accuracy, transparency, timeliness, and audit defensibility.
• Participate in modernization initiatives, including report automation, ACES data import improvements, Power BI dashboard migration, ACES FIRE/data ingestion work, servicing
• report modernization, and future-state reporting enhancements.
• Communicate findings, updates, risks, report changes, data limitations, and recommend actions clearly to peers, leaders, and stakeholders using plain language appropriate for both technical and nontechnical audiences.

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 used to support accurate and reliable reporting.
• 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 the 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 elevate issues when data, access, reporting logic, or business requirements are unclear.
• Bachelor’s degree in Business Administration, Statistics, Data Analytics, Information Systems, Risk Management, or a related field, or equivalent combination of education, training, and experience.

Preferred Qualifications:

• Experience with Power BI, SQL, Excel, Power Query, ACES, Business Objects, SharePoint, ADO, workflow intake tools, or similar reporting and analytics platforms.
• Experience supporting quality control, mortgage lending, mortgage servicing, investor reporting, audit support, access governance, or risk management reporting.
• Experience developing dashboards, report guides, procedures, validation checklists, technical documentation, or audit-ready evidence.
• Experience supporting role-based access, user access requests, user access reviews, system administration activities, data governance, audit trail documentation, report validation controls, evidence retention, or management approval workflows in a controlled environment.
• Ability to translate complex reporting requirements into practical, user-friendly outputs that support business decisions and reduce operational, compliance, or audit risk