2025 Winter - CAO, Analyst - Data Lineage and Controls Intern (Bedford, NS - 4 Months)

Job Summary:
The Analyst, Data Lineage & Control is responsible for documenting all aspects of the data lineage lifecycle from the original source of the data to the point of consumption of the data into a report, including any associated data transformations. They maintain relationships with various business & IT stakeholders to understand & communicate details of data lineage.

What is the opportunity?

Are you interested in the opportunity to work as a Data Student at RBC? By applying to this job posting, you will be considered for multiple roles available across CDO Data Shared Services Team.

Some exciting roles you will be considered for are:

• Analyst, Data Lineage and Controls

What will you do?

• Understand and document the lineage of CDEs from originating source to point of consumption of data into a report or other risk management activity.
• Collaborate with other Data Management Offices, Data Custodians and Data Stewards to understand data lineage reporting standards and best practices.
• Leverage data lineage artifacts captured by other Data Management Offices and share artifacts captured by Risk Data Management Office to avoid duplication of effort.
• Identify & communicate options to optimize the process of data lineage capture and documentation.
• Develop knowledge and become valuable team resource, supporting development of Data Lineage in general.
• Work as part of an agile team responsible for end-to-end delivery of business needs
• Work on transformational projects delivering new value
• Constantly seek out better ways to do things, new tools, new technologies, new processes

What do you need to succeed?

Must Have

• Currently enrolled at a Canadian post-secondary institute with a focus on Finance, Data Analysis or any other related data programs
• Excellent intrapersonal and highly developed written and verbal communication skills
• Ability to learn and absorb new concepts (in business and in systems) quickly and apply new knowledge
• Knowledge of data manipulation and analysis tools such as Datameer, SQL
• Strong MS Office skills - Word, Outlook, Excel, PowerPoint, and Visio

Nice to Have

• Knowledge of handling and deriving information from large data sets.
• Knowledge of Sarbanes Oxley (SOX) controls and compliance
• Knowledge of data governance and metadata management tools such as Collibra
• Knowledge of Lean or Process Improvement Designations
• Knowledge of Management consulting experience with an emphasis on business strategy or Process / Productivity Improvements

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.

• Network and build lasting relationships with students from diverse backgrounds from across Canada
• Participate in fun events and gamification challenges to help build your career tool kit while enjoying a work-life balance
• Leaders who support your development through coaching and learning opportunities
• Work in a dynamic, collaborative, progressive and highly performing team
• Hands on Data management experience
• End-of-term presentation with Senior Leadership for visibility and potential future opportunities
• Ability to make a difference and lasting impact
• Enjoy a comfortable work environment with the option to dress casually

Please note: This posting is for a 4-months Winter 2025 Student placement with a start date of January 2025, and end date of April 2025. In order to be eligible for this 4-months Student position, you must either:

• Be returning back to school after the work term end-date of April 2025 ; or
• If you are not returning back to school (i.e. are graduating in April 2025), you must require the full 4-months work term as a mandatory component to in order to graduate successfully.

Please ensure that you meet these eligibility requirements before applying - candidates who apply but are found to be ineligible are not able to be considered.

We encourage you to apply as soon as possible as we accept applications on a rolling basis, but please note that the formal application deadline is October 25, 2024. Should you be selected to progress, someone from our team will reach out directly to provide instructions on next steps. Otherwise, feel free to check for progress updates by logging in to your RBC profile. If the status has not changed, it denotes the fact that your application is still under review.

RBC is committed to supporting flexible work arrangements when and where available. The successful candidate for this role will be required to be located within Ontario for the duration of the work term. Details regarding the specific virtual, hybrid, and in-office arrangements for this Integrated Learning/ Co-op position are to be discussed with the Hiring Manager.

ET25

Business Analytics, Communication, Computer Literacy, Critical Thinking, Data Administration, Data Movement, Detail-Oriented, Group Problem Solving, Interpersonal Relationships, Listening Effectively, Personal Development, Personal Initiative, Professional Networking

Additional Job Details

175 WESTERN PKY:BEDFORDBEDFORDCanada37.5Full timeSTRATEGY AND ADMINISTRATIONStudent/Coop (Fixed Term)Salaried2024-10-102024-10-26

Inclusion and Equal Opportunity Employment