Royal Bank of Canada

Associate Director, Data Engineering

Royal Bank of Canada$120K — $200K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's or Master's in Computer Science, Engineering, Analytics, Accounting, or Finance
  • 4+ years in code analysis and optimization
  • Experience with databases using ORMs and raw queries
  • 3+ years in Python Data Analysis and Visualization (Matplotlib, Seaborn, Tableau, Power BI)
  • Proficient in ETL with Pandas, Numpy, and pySpark
  • Experience in SQL and NoSQL databases like PostgreSQL or MongoDB
  • Strong analytical and project management skills

Responsibilities

  • Produce and maintain management reports ensuring quality and timely delivery
  • Develop and deliver scheduled and ad hoc reporting as requested
  • Interact with business platforms to clarify report requirements
  • Adhere to report quality standards and initiate continuous improvements
  • Document report inventory and related processes
  • Manage KPI metrics effectively
  • Mentor junior engineers to improve team capabilities

Benefits

  • Comprehensive Total Rewards Program with flexible benefits
  • Strong leadership support for personal and professional development
  • Opportunities for impactful contributions in a dynamic environment
  • Collaborative and high-performing team culture
  • Challenging work with opportunities for client relationship building
Full Job Description
Job Description

What is the opportunity?

The Corporate Banking Operation Supervisory (CBOS) Technology group within RBC Capital Markets Quantitative and Technical Solutions builds business-focused solutions that optimize efficiency, automate processes, and enhance audit and compliance. As an Associate Director, Data Engineering, you will manage business requirements, stakeholder engagement, demos, validations, and cross-team coordination various functions to create a centralized reporting capabilities to provide business users insights and tracking capabilities. You will be responsible for the production, development, enhancement, and maintenance of centralized reporting systems across RBC's lines of business.

You will work in a fast-paced environment to comprehend, discover, and develop innovative solutions to address stakeholder business needs and opportunities. You will partner closely with our business partners to deliver management reports, financial reports, and statutory and regulatory reports that drive business decisions.

What will you do?
  • Accountable for the production, maintenance, and enhancements of required management reports, ensuring timely delivery and quality standards.
  • Accountable for the development and delivery of scheduled, new, and ad hoc reports and change requests.
  • Interact with business platforms to ensure accurate understanding of report requirements and provide timely responses to user requests.
  • Ensure report quality standards are adhered to and continuous improvement initiatives are embedded within production and development.
  • Maintain adequate and up-to-date documentation on report inventory, reporting processes, and related activities and components.
  • Manage Key Performance Indicator (KPI) metrics and quality standards.
  • Manage multiple competing priorities effectively, especially during intense period-end close cycles.
  • Establish and maintain self-service multi-environment infrastructure with ability to translate business requirements into detailed technical specifications and governance frameworks
  • Mentor junior engineers and team members to enhance the collective technical expertise of the team.


What do you need to succeed?

Must-Have Qualifications:
  • Bachelor's degree or Master's degree in Computer Science, Analytics , Engineering, Accounting, Finance, or Finance/Accounting designation or equivalent education and experience
  • 4+ years of experience in analyzing existing code and refactoring to optimize codebases for enhanced performance and scalability.
  • Database development and interaction with databases using Object-Relational Mapping (ORMs) and raw queries.
  • 3+ years' experience in Python Data Analysis and Visualization, including Matplotlib, Seaborn, Tableau, and Power BI.
  • Python Data Manipulation and ETL Pipelining, using Pandas, Numpy and pySpark. Custom ETL pipeline development using Apache Airflow and Dagster.
  • Creating and managing databases with SQL and NoSQL technologies such as PostgreSQL, MySQL or MongoDB
  • Visualization using tools such as Tableau, Power BI, or Looker.
  • Proficiency with DAX Studio for data modeling and optimization.
  • Experience with network drive management and data storage administration,
  • Data platform development and optimization using Python, R, or Scala for building scalable data infrastructure and supporting advanced analytics workflows.
  • Strong analytical, problem-solving, written, oral, and presentation skills with ability to assess stakeholder and project communication needs and deliver results on time.
  • Solid project and time management capabilities with proven ability to manage multiple concurrent tasks and deadlines while maintaining high quality standards.
  • Quick learner capable of grasping new reporting tools within a short time frame.


Must-Have Competencies:
  • Curiosity and continuous learning mindset: Proactive approach to developing new skills and staying current with evolving tools and technologies.
  • Openness to change and adaptability: Comfort with evolving platforms, methodologies, technology and business requirements.
  • Business Domain Expertise & Adaptability: Deep understanding of Capital Markets business domains and the ability to quickly adapt to evolving business group requirements, translating business needs into technical solutions including rapid development and deployment of ad hoc dashboards and reports.
  • Cross-functional collaboration and stakeholder management: Ability to work effectively across RBC's lines of business and partner with senior leadership.
  • Detail-oriented with strong problem-solving and validation rigor: Ability to identify issues, validate data accuracy, and implement robust solutions in a complex reporting environment.
  • Ability to manage multiple competing priorities: Particularly during intense period-end close cycles.
  • Business Systems & Change Management: Business Systems and Change Management expertise including the oversight of production Change Requests (CRs), documentation, approvals, and Post-Implementation Validation (PIV) to ensure seamless deployments.
  • Strong communication skills: Ability to clearly articulate technical and reporting concepts to teams and senior leadership.


Nice-to-have:
  • Experience in AI implementations or leveraging AI tools for testing
  • Exposure to performance testing and system monitoring tools
  • Experience with task scheduling and workflow automation tools such as Windows Task Scheduler, Control-M, or equivalent orchestration platforms
  • Containerization experience using Docker and Kubernetes
  • Quick learner with ability to pick up new technologies, tools, and business knowledge
  • Ability to facilitate between and influence key decision makers
  • Strategic thinker with excellent interpersonal skills to work across functions and businesses


What's in it for you?

  • A comprehensive Total Rewards Program include competitive compensation and flexible benefits, such as 401(k) program with company-matching contributions, health, dental, vision, life, disability insurance, and paid-time off.
  • 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 build close relationships with clients.


The expected salary range for this particular position is $120,00-$200,000 depending on your experience, skills, and registration status, market conditions and business needs.

You have the potential to earn more through RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.

RBC's compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:
  • Drives RBC's high-performance culture
  • Enables collective achievement of our strategic goals
  • Generates sustainable shareholder returns and above market shareholder value


Job Skills
Agile Engineering, Agile Methodology, API Development, Business Analysis, Cloud Architectures, Collaboration, Communication, Database Administration, Database Architecture, Data Pipelines, Decision Making, ETL Development, Group Problem Solving, Leadership, Long Term Planning, Performance Optimizations, Problem Solving, Stakeholder Management, System Integration, Teamwork, Technical Leadership, Time Management

Additional Job Details

Address:

GOLDMAN SACHS TOWER, 30 HUDSON STREET:JERSEY CITY

City:

Jersey City

Country:

United States of America

Work hours/week:

40

Employment Type:

Full time

Platform:

CAPITAL MARKETS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-06-18

Application Deadline:

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

About Royal Bank of Canada

Royal Bank of Canada Careers

Join the dynamic team at Royal Bank of Canada (RBC), a global leader in financial services and a company committed to excellence and innovation. At RBC, we offer a wide range of job opportunities that empower professionals to shape their career paths with leadership, diversity training, and continuous growth.

Work You’ll Do

At Royal Bank of Canada, we are not just hiring; we are building a culture of innovation and leadership. Our team members are at the forefront of the financial industry, driving transformation and delivering targeted solutions that meet the evolving needs of our clients and communities.

Explore Job Opportunities and Employment at RBC

Whether you are starting your career or looking to take it to the next level, RBC offers positions that challenge your skills and fuel your ambition. From entry-level positions to leadership roles, our job opportunities span across various functions and regions. Join us and be part of a team that values professional growth and diversity.

Internship and Professional Development

Kickstart your career with an internship at Royal Bank of Canada. Our internships provide invaluable hands-on experience, networking opportunities, and insights into the financial services industry. Interns at RBC gain the skills necessary to excel and are often considered for full-time positions within the company.

Benefits and Culture

At RBC, we prioritize the well-being and satisfaction of our employees. Our benefits package is designed to support our team members at every stage of their life and career. RBC’s culture is built on a foundation of respect, integrity, and responsibility, fostering an environment where everyone can thrive.

Career Growth and Innovation

We believe in nurturing the potential of our employees through continuous learning and career development programs. At RBC, you will find endless opportunities to grow professionally through on-the-job experiences, formal training programs, and leadership development initiatives. Our commitment to innovation means we are constantly seeking out new ideas and perspectives, making RBC a perfect place for those who aim to lead and innovate.

Diversity and Inclusion

Diversity is our strength. At Royal Bank of Canada, we are committed to building an inclusive workplace where every employee feels valued and respected. Our diversity training programs are designed to educate and inspire, creating a more inclusive and equitable workplace.

Join Our Team

Search open positions that match your skills and interests. We look for passionate, curious, creative, and solution-driven team players. Start your journey with RBC today and be part of a world-class team known for its commitment to client service, community involvement, and innovation.

Stay Connected

Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here at Royal Bank of Canada.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities awaiting you at RBC. Explore the possibilities with Royal Bank of Canada, where your future is filled with potential and the path to success is paved with countless opportunities for professional and personal growth. Join us and shape not just your career but the future of the financial industry.
Learn more about Royal Bank of Canada
Size
86,007 employees
Market Cap
$130.3 billion
Industry
5 Year Trend
+8.7%
NASDAQ

Similar Jobs

More Jobs at Royal Bank of Canada

More Information Technology Jobs

Find similar Associate Director, Data Engineering jobs: