Junior Business Intelligence Analyst

• Multiple locations
• Hybrid
• Hourly salary: $42 - $51

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.