Associate Director, Data Engineering

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?

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 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

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.