Lead Data Analyst
| Company | Royal Bank of Canada |
|---|---|
| Location | Toronto, ON, Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Mid Level, Senior |
Requirements
- Bachelor’s degree or equivalent in business, finance, accounting, or engineering
- Strong understanding of cash management products and services, including process and procedure implementation
- Proven experience in data system analysis, modeling, and/or system administration
- Proficiency in SQL and ability to create entity relationship diagrams for relational data modeling
- Familiarity with database models and data mapping concepts
- Excellent communication and interpersonal skills, with the ability to present complex information to diverse audiences
- Experience with JIRA, Confluence, and Microsoft Office applications (PowerPoint, Excel, Word)
Responsibilities
- Document data requirements and identify gaps in collaboration with stakeholders from various departments
- Standardize data within the capital markets domain, including trade data, reference data, payments, and other structured/unstructured datasets
- Develop and maintain data catalogs using industry-standard tools and frameworks
- Define data formats to support standardized reporting and integrate them with existing systems
- Identify and document system lineage, data flows, and control points to ensure data integrity and security
- Collaborate with cross-functional teams to develop target operating models and implement data governance practices
- Analyze data quality issues and recommend solutions to improve data accuracy and completeness
- Participate in Agile Scrum ceremonies to prioritize tasks and track project progress
Preferred Qualifications
- Knowledge of industry data standards like FpML, CDM, ISO 20022
- Advanced understanding of change management principles and business operations