2027 Investor Services, PEY Data Analyst (12-16 months)

Job Description Summary

As the Data Analyst, you will provide expertise for Data Management spanning both platforms and projects.  At the core of the role is a detailed understanding of Data management principles and the ability to apply them to meet business and client data requirements. Your role is to ensure that data is well documented and managed across RBC Investor Services. You will be called on to find solutions to complicated data requirements and lead the design, development, testing and delivery. 

As a member of a dynamic, fast paced team, this role brings strong data analysis skills and leadership, effective written and verbal communication skills, a strong work ethic and a demonstrated capability to multi-task effectively.  This role requires strong interpersonal, organizational and problem-solving skills as well as a demonstrated sense of urgency to respond to changing priorities at times.  This is complemented by a positive attitude and a willingness to take accountability for results achieved.

Job Description

What will you do?

• Collaborate with product, business development, Client Ops and digital teams on gathering data requirements.
• Analyze data within existing legacy data delivery channels, understand/translate business rules and define data requirements for delivering through modern tools and channels.
• Actively lead and engage in agile-like and business-led initiatives across a matrix environment.
• Leverage data to create efficiencies and reducing business/client risk.
• Build & enhance Data quality frameworks and operating models, which will deliver measurement, execution, monitoring, analysis and resolution support for datasets.
• Consult & confirm critical data elements (CDEs) with business, SME and Domain Experts for implementation of Data Quality Rules.
• Coordinate with data engineers to define Data flows and Data Quality measuring Points
• Provide weekly updates for actively running data quality rules for Master Reference Data and share reports with Stewards
• Actively manage the status of data quality rules enabled on datasets and investigate identified exceptions
• Build “Artificial Intelligence & Machine Learning” solutions that can identify data anomalies within active production pipelines
• Investigate and provide support for client exceptions & escalations

What do you need to succeed?

Must-have

• Working towards a Bachelor or master’s degree in data management, Data Analytics, Data Science, Finance, Business Administration, Economics other related field 
• Strong personal skills and the ability to work effectively independently and within a team environment.
• Professional written and verbal communication skills
• Good analytical, communication and problem solving skills
• Highly organized with good attention to detail and very high level of accuracy
• Ability to prioritize, handle multiple tasks under pressure and meet time-sensitive deadlines
• Ability to think critically and “outside the box”

Nice-to-have

• Prior experience in the financial services industry, and strong understanding of the data lifecycle, including strong focus on data management and data quality practices.
• Technical Skills:
  • Programming Languages: Python, Scala, Java, SQL, etc.
  • Data Management: ETL (PySpark, Apache Spark), Data Transformation, Data Pipelines, Data Integrity Distributed Computing: Hadoop, HDFS, MapReduce, Apache Spark
  • Data Streaming: Apache Kafka
  • Database Management: PostgreSQL, AWS RDS, DynamoDB (NoSQL), Elastic Search
  • Cloud Computing: AWS (S3, EC2, Lambda, RDS), Azure
  • Containerization & Orchestration: Docker, Kubernetes
  • Terraform Jira, Confluence, Postman, APIs
  • CI/CD Tools: Jenkins, Git Data Analysis and Visualization:
  • Data Visualization Tools: Power BI, Tableau

Please note: 

• In order to be eligible for these student positions, you must either: 
• Be returning back to school after the work term end-date; or 
• If you are not returning back to school (i.e. are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully

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. At RBC, you will have opportunities to:
• Interact with leaders who support your development through coaching and managing
• Network and build lasting relationships with students from diverse backgrounds from across Canada
• Make a difference and lasting impact through meaningful work
• Work in a dynamic, collaborative, progressive, and high-performing team

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.