Staff Data Engineer
RBC
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
RBC seeks a Lead Data Engineer to drive data architecture and governance for Investor & Treasury Services. You will lead Azure Databricks ecosystems, optimize Power BI analytics, and collaborate with business SMEs and data stewards to enable scalable self-service analytics.
Experience across cloud platforms, data pipelines, and security controls is essential to delivering enterprise data solutions for a global organization.
Qualifications
- 7+ years of experience in data engineering with hands-on system integration and cloud architecture.
- Strong experience with Azure Databricks, Delta Lake, Spark optimization, and data governance.
- Proficiency across Python, SQL Server, Elastic stack, and Power BI.
Responsibilities
- Design, implement, and support enterprise data architecture and governance across the organization.
- Build real-time data pipelines and integrate data with cloud platforms via APIs.
- Manage Azure Databricks clusters, compute resources, and workspace optimization.
- Optimize Power BI reporting infrastructure, semantic models, and dashboards.
- Establish Power BI administration and workspace governance, plus user access management.
- Collaborate with data scientists and stakeholders on requirements and analytics delivery.
Skills
Education
Tools
Job description
As
As Lead Data Engineer in Investor & Treasury Services Data Engineering team within Technology and operations office, you will design, implement, and support enterprise data architecture best practices and processes across the global Investor and Treasury Services organization, aligning with corporate vision. We seek a strategic thinker and passionate data management leader to drive data strategy execution, including Azure Databricks infrastructure management , Power BI optimization, analytics administration, workspace governance, and reporting infrastructure to enable self-service analytics at scale.
As a member of a dynamic, fast-paced team, this role demands strong data architecture and engineering expertise, advanced analytics platform leadership, exceptional communication skills, strong work ethic, and demonstrated ability to multitask effectively in changing environments.
This role encompasses end-to-end system oversight from data sourcing, lineage, transformation, and storage through Azure Databricks governance and Power BI analytics optimization to support complex advanced analytics and data governance needs, requiring extensive collaboration with Business Architecture, System Architecture, Business SMEs, and Data Stewards.
- Build real-time data pipelines (inbound, outbound) through container-based solutions and Azure Databricks
- Integrate data with cloud-based platforms; publish data through APIs and Portal
- Manage Azure Databricks clusters, compute resources, and workspace optimization for scalable data processing
- Optimize Power BI reporting infrastructure, semantic models, and dashboard performance across the organization
- Establish Power BI administration best practices, workspace governance frameworks, and user access management
- Manage analytics workspaces, capacity planning, and optimization to support enterprise self-service analytics
- Participate in data curation requirements; support data and digital needs of business and technology stakeholders
- Evaluate current state of data access control (authentication, authorization, encryption) across I&TS systems; develop and support remediation strategies
- Work in agile teams with Data Engineers, Developers, and RBC business stakeholders
- Collaborate with data scientists, process engineers, and business stakeholders on requirement gathering; assist with prescriptive and predictive analytics through consolidated data pipelines leveraging Azure Databricks
- 7+ years of experience in data engineering with at least 5 years of hands-on experience in system integration, data and cloud architecture, and technologies listed below:
- Data Engineering: Python, Kafka, MS SQL Server, Elasticsearch stack, Azure Databricks
- Cloud and Containers: Azure (ADLS2, Azure Databricks), OpenShift, Docker
- SQL/Database: Microsoft SQL Server, Azure SQL, Stored procedures
- API: Node.JS, Apigee
- Power BI & Analytics: Power BI (report development, semantic modeling, workspace administration, capacity management), DAX, Power Query
- Security frameworks: LDAP, Kerberos, OAuth 2.0, Vault integration
- Strong knowledge of algorithms and data structures
- Demonstrated experience with Azure Databricks cluster management, Delta Lake, and Spark optimization
- Master's degree in Computer Science or equivalent experience
- Automation/DevOps: Jenkins, Selenium, and similar technologies
- Source code control: GIT
- Experience working in agile/SaFe environment
- Advanced Power BI certifications (Microsoft Certified: Data Analyst Associate or similar)
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
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work
Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis
RBC CENTRE, 155 WELLINGTON ST W:TORONTO
Toronto
Canada
37.5
Full time
TECHNOLOGY AND OPERATIONS
Regular
Salaried
2026-08-24
2026-09-14
Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
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.
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you. Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
