Manager, Data Quality and Operations

What is the opportunity?

As a Manager-Data Quality and Operations, you'll work in the Financial Resource Optimization (FRO) Data, Systems and Business Solutions team supporting the team build and maintain the bank's next generation data architecture solution for Regulatory and Economic Capital Measurement. In this regard, the candidate needs to be a highly motivated and detail-oriented individual with a high focus on compliance. This role is crucial in ensuring the accuracy, completeness, and consistency of data used in the bank's capital measurement. The successful candidate will play a key part in establishing and maintaining robust data governance frameworks, implementing data quality controls, and utilizing data analysis and visualization tools to monitor and analyze data integrity.

What will you do?

• Data Quality Management:
  • Develop and implement data quality rules, checks, and validation procedures for data used in capital measurement calculations (e.g. RWA, capital ratios).
  • Identify, investigate, and resolve data quality issues, working closely with data owners and IT teams.
  • Collaborate with IT and business teams to implement data quality improvements.
  • Conduct regular data quality assessments to identify and resolve data discrepancies, inconsistencies, and errors and initiate corrective actions.
  • Monitor data pipelines and data flows to ensure data integrity and completeness.
  • Monitor data quality metrics and generate regular reports on data quality performance.
  • Implement data cleansing and data enrichment processes in production.
    
• Data Governance:
  • Contribute to the development and implementation of data governance policies, standards, and procedures for capital data.
  • Support the definition and maintenance of data dictionaries, data lineage, and metadata.
  • Participate in data governance meetings and initiatives.
  • Ensure compliance with regulatory requirements related to data governance and data quality.
    
• Data Analysis and Investigation:
  • Utilize SQL and other techniques (Python, Spark, Shell Script) to extract, manipulate, and analyze large datasets from various sources including automation of repetitive tasks.
  • Perform root cause analysis to identify the source of data quality issues and propose solutions.
  • Investigate data anomalies and discrepancies to ensure compliance with regulatory requirements.
    
• Documentation and Compliance:
  • Very high focus on documentation is required in this role as the process in heavily audited.
  • Develop and maintain comprehensive documentation of data quality processes, rules, and procedures.
  • Support regulatory audits and examinations by providing data quality documentation and analysis.
  • Stay up to date with changes in regulatory requirements and industry best practices.
  • Ensure data quality meets regulatory requirements as identified by senior management.
    
• Data Visualization and Reporting:
  • Create interactive dashboards and visualizations using Tableau/other visualization tools to communicate data quality metrics and trends.
  • Develop ad-hoc reports and analyses to support business and regulatory needs.
  • Present data findings to senior management.

What you need to succeed?

Must Have

• Bachelor's degree or higher in a quantitative field such as Finance, Mathematics, Statistics, Business Analytics, or a related discipline.
• 2+ years of experience in data analysis, preferably in risk management industry.
• Demonstrated advanced experience in SQL is required for data extraction, manipulation, and analysis.
• Proven experience with data visualization tools, particularly Tableau.
• Advanced knowledge in Excel particularly in Pivot Tables, VBA, Macros are required for this role.
• Knowledge of data governance and data management principles.
• Excellent analytical and problem-solving skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Strong attention to detail.

Nice to Have

• Automation skills using Python or other scripting languages.
• Knowledge of distributed computing and cloud data warehousing (e.g. Spark, DataBricks, Snowflake)
• Knowledge of bank capital measurement concepts (e.g., RWA, capital ratios) is highly desirable.
• Knowledge of risk management principles and practices.
• Experience with data quality tools and platforms.
• Familiarity with data warehousing and ETL processes.
• Certifications related to data management or financial risk management.

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.