Job Summary

We are seeking an Enterprise Risk Reporting & Analytics Consultant to support the continued enhancement of a Risk & Controls Center of Excellence (COE). This role will contribute to modernizing risk reporting, dashboard development, data aggregation, and executive analytics capabilities across multiple Lines of Business (LOBs). The position is a hands-on reporting development role requiring strong expertise in Power BI, data analysis, dashboard design, reporting automation, and data aggregation. The consultant will independently gather and analyze data from multiple sources, build reporting solutions from the ground up, create executive-level dashboards, and establish reporting quality controls within a banking or financial services environment.

Key Responsibilities
• Design, develop, and maintain executive-level dashboards and reporting solutions using Power BI, Excel, SharePoint, and other reporting tools.
• Build scalable, repeatable reporting solutions supporting executive leadership, risk committees, and Board-level stakeholders.
• Develop executive-ready dashboards highlighting risk trends, emerging risks, control deficiencies, performance metrics, and areas requiring management attention.
• Create drill-down reporting capabilities across line of business, product, risk category, control framework, risk statement, and regulatory requirements.
• Design and maintain risk heat maps, trend reporting, scorecards, and interactive visualizations.
• Consolidate and integrate data from multiple repositories, including SharePoint, Excel, Power BI datasets, data marts, and other enterprise sources.
• Develop and maintain SQL queries, data models, and reporting logic to support reporting requirements.
• Identify, document, and map data sources across the organization to create repeatable reporting processes.
• Aggregate risk data across multiple programs to identify patterns, themes, emerging risks, and root-cause trends.
• Support automation of data collection, refresh cycles, reporting production, and dashboard distribution.
• Develop reporting solutions across risk and controls programs, including Risk & Control Self-Assessments (RCSA), Issues Management, Operational Risk Events, Key Risk Indicators (KRIs), Metric Threshold Breaches, Regulatory Findings, Complaints, Fraud, Control Testing Results, and Training Compliance.
• Partner with Risk, Controls, Governance, and Business Line stakeholders to understand reporting requirements and improve reporting capabilities.
• Support efforts to standardize reporting methodology, definitions, and metrics across business lines.
• Develop controls that ensure reporting accuracy, completeness, reconciliation, auditability, and data quality.
• Execute report validation, testing, quality control, and reconciliation procedures.
• Document data lineage, reporting methodologies, ownership structures, and control frameworks.
• Establish reporting governance processes, change management controls, and escalation procedures.
• Create operating procedures, reporting standards, testing procedures, and data mapping artifacts.

Required Qualifications
• 5+ years of experience in reporting, business intelligence, analytics, or dashboard development.
• Advanced Power BI dashboard development experience.
• Strong experience building reports and dashboards from the ground up rather than simply consuming existing reporting.
• Experience writing SQL queries and working with structured data sources.
• Demonstrated experience consolidating and aggregating data from multiple repositories.
• Experience developing executive-level reporting and management dashboards.
• Strong understanding of reporting validation, reconciliation, and quality control processes.
• Experience working within banking, financial services, risk, controls, audit, compliance, or governance environments.
• Experience designing, implementing, or enhancing risk reporting, management reporting, executive dashboards, or committee-level reporting within financial services or another regulated industry.
• Strong experience with data mapping, data lineage, reconciliations, data quality controls, evidence retention, and audit-ready documentation.
• Proficiency with reporting and analytics platforms such as Power BI, SQL, Power Platform, Excel, SharePoint, data warehouse solutions, and GRC platforms.
• Ability to translate business and risk requirements into functional specifications, reporting designs, governance documentation, and implementation plans.
• Strong stakeholder management and requirements gathering skills.
• Strong communication skills with the ability to engage senior business and risk leaders.

Preferred Qualifications
• Experience supporting First Line Risk, Operational Risk, Controls, Audit, Governance, or Compliance organizations.
• Knowledge of RCSA, Issues Management, KRIs, Operational Risk Events, Regulatory Findings, and Control Testing programs.
• Experience supporting large regional banks or Category III banking organizations.
• Experience creating reporting governance frameworks and reporting standards.
• Experience automating reporting processes and dashboard refresh capabilities.
• Experience with enterprise risk reporting frameworks and standardized reporting methodologies.
• Experience developing automated reporting solutions and executive analytics.