• Define and maintain risk reporting framework to support the monitoring and management of risk reporting oversight and monitoring activities for applicable Risk categories.
• Engage with internal and external stakeholders to understand needs and ensure reporting and outputs are in alignment to key risk programs.
• Responsible for design, implementation and maintenance of intuitive dashboards that deliver valuable insights for enabling data-driven decision making and automation of processes.
• Responsible for periodic risk reporting and analysis to support 2LOD Risk Reporting Workstream and various risk and compliance programs.
• Foster and maintain good working relationships with colleagues to meet expected service levels.
• Lead efforts involving analysis and reporting of risk profile, control performance, and benchmark process performance against Key Risk Indicators and Risk Appetite Metrics, highlighting any exceptions or areas of concern.
• Develop aggregated view for all divisions covered by 2LOD Workstream and other materials as needed.
• Collaborate with larger Bank-level programs (e.g., new system implementation or data initiatives) to identify impacts and dependencies on reporting requirements.
• Collaborate with 1LOD and Parent (Royal Bank of Canada) to support target operating model of risk reporting and analytics.
• Discover patterns, insights, trends and anomalies from straightforward analyses, data sets and visualization tools.
• Understands concepts of data lineage and data stewardship in order to develop effective data analytics that provide the insights.
• Identify data quality issues and concerns and support data governance initiatives.
• Stay abreast on specific reporting standards, department reporting requirements and bank system changes/enhancements.
• Understand, interpret, and present recommendations for action based on a data-driven analysis.
• Lead efforts involving analysis and reporting of risk profile, control performance, and benchmark process performance against Key Risk Indicators and Risk Appetite Metrics, highlighting any exceptions or areas of concern.
• Measure and report on bank risk appetite metrics, and solicit for key measures on the Bank’s risk posture.
• Participate in risk mitigation development to ensure that strategies are in place to maintain risk profile within established limits.
• Utilize analytical tools and methodologies to support analysis of internal and external risk metrics.
• Develop and report metrics consistent with bank's Risk Management Framework and risk pyramid, ensuring uniform reporting throughout all 2nd line risk functions.
• Work with multiple business units to aggregate and analyze data and information.
• Report on existing and emerging areas of risk, implications of risk appetite and tolerance, and the ability of the risk management and control infrastructure to support business activities.
• Participate in workshops and lead activities on key business initiatives, ensuring that existing and emerging risks for new products, processes and transformational initiatives are identified. This also includes the annual business strategy review process and assessments.
• Coordinate with external banking partners, Royal Bank of Canada (RBC) and other managed affiliates to fulfill regulatory reporting requirements.
• Successfully completes all required training and special projects as requested.
• Promote a risk-aware culture, ensure efficient and effective risk and compliance management practices by adhering to required standards and processes.

Must-Have*

• Bachelor's Degree or equivalent
• Minimum 10 years of experience in one or a combination of the following: reporting, analytics, or modeling
• Minimum7 years of experience with SAS or SQL, or other data management, reporting and query tools (SharePoint, SAP, Business Objects, Tableau, Crystal reports/Dashboard, etc.)
• Minimum 5 years of experience in banking/operations
• Minimum 3 years of experience in risk management

Skills and Knowledge

• Master's Degree Preferred.
• Strong analytical and organizational skills with emphasis on report production and program management.
• Ability to effectively manage projects.
• Hands on experience gathering requirements, designing and coding new reports, maintaining and enhancing existing reports, as well as designing dashboards.
• Report development experience utilizing Microsoft SQL Server Reporting Services (SSRS), Tableau, Business Objects, Crystal Reports or similar report development software.
• Advanced experience designing and generating scheduled and ad hoc reports using reporting/query tools (i.e. Brio, Toad, SQL Developer, MS Access, Crystal Reports, Business Objects, etc.)
• Expertise in statistical programming, data mining and machine learning tools (Python, SAS, R, etc.)
• Experience developing business applications using VBA code and Access forms.
• Must be detail-oriented and possess effective organizational and analytical skills.
• Understanding of banking processes and risk management programs.
• Ability to handle complexity and ambiguity.
• Must have excellent verbal and written communications skills and ability to communicate clearly and professionally with all levels of the organization.