A key IT role within Wealth Management Technology & Solutions, Data Services Canada team, you will be a Business System Analyst that will act as an SME for Global Wealth Management Data Hub and provide leadership covering a range of data analysis functions. These include data mapping, data profiling, data quality, extract-transform-load (ETL) requirements, metadata enrichment and management, data provenance and lineage and other specialized data management functions. You will work in collaboration with IT and Business Partners to assess, research, and analyze data needs in order to support business insights and strategy.

What will you do?

• Work with IT and Business Partners to understand the business meaning of data, provide analysis and requirements so that data design is fully understood and the development initiatives are in line with intended design and standards

• Develop and maintain knowledge of data available from upstream sources and data within various data platforms and provide expert counseling to application development community

• Elicit, analyze, interpret business and data requirements to develop complete solutions, including data mapping, business rules and system specifications

• Contribute to process standardization and creation of Wealth Data Hub scalable solutions

• Provide guidance to colleagues and clients related to gathering and assessing data to ensure that appropriate data-management practices are known and complied with

• Lead complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning

• Monitor work processes and client satisfaction, recommend changes for continuous improvement

• Engage with data managers, stewards and owners to implement, maintain, and enhance data governance, quality and related policies, aligning with RBC standards and frameworks

What do you need to succeed?

Must-have:

• Strong business domain understanding of Wealth-Management and Trading life cycle, excellent data analysis and solid background dealing with Wealth Management application

• Really Good SQL knowledge to query databases in order to complete data analysis. Worked closely with in-memory or relational databases to provide data services to other IT partners or business.

• Ability to work independently, apply critical and strategic thinking to issues, and manage deadlines while multi-tasking amongst different projects and priorities

• Really good at creating Technical Specifications for development team to build the solution whether it's batch file extract, API real-time call or Kafka near real-time notifications.

• Superior relationship building, communication & presentation skills, organizational knowledge and leadership skills with a proven ability to work effectively in a cross-functional and complex environment

• Professional with experience on large projects/programs with multiple applications with multiple interfaces and/or 3rd parties.

• Experience with Agile methodology and familiar with Confluence and Jira tools.

• Proven leader and experienced in managing a small team that brings strong planning, estimating, budget management, reporting and coordination experience

Nice-to-have:

• Knowledge of key Databases, primarily dealing with large data volume, database schema design and exposure to enterprise reporting and analytic tools based on Hadoop/HDFS sourced data like Tableau.

• Team player known for providing creative thought leadership while also listening to and engaging others

• Commitment to challenging the status quo is essential.

• Working experience with databases, Front, Middle and Back office teams of Asset Management, Wealth Management, Broadridge Portfolio Management, Brokerage Institutions, Prime Brokerage Services of various asset class such as Fixed Income, Equities, Derivatives, Money Market Instrument and OTC Derivatives

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable

• Leaders who support your development through coaching and managing opportunities

• Ability to make a difference and lasting impact 

• Work in a dynamic, collaborative, progressive, and high-performing team 

• Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities 

• Opportunities to building close relationships with clients

• Access to a variety of job opportunities across business and geographies

#LI – POST

Job Skills

Additional Job Details

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

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.