Senior Data Engineer
About The Position
Join RBC Insurance Online Experience squad to design and maintain enterprise data solutions for our customer data platform and online analytics. You'll work with technology professionals delivering scalable analytics infrastructure for the Insurance business and our clients. We embrace Agile development, DevOps, and modern cloud-native tools. This role offers the opportunity to make a real difference by architecting data pipelines, optimizing ETL processes, and enabling analytics that directly impact RBC's success. You'll partner across IT and business lines to solve complex data challenges while building resilient, high-performance systems that serve RBC staff and clients.
Requirements
- 3+ years of experience in data engineering, data warehousing, or analytics with focus on enterprise platforms
- Strong hands-on experience with Snowflake and/or Teradata, including data modeling, performance tuning, and system optimization
- Knowledge of CDP and online analytics tools and concepts
- Proficiency in SQL and at least one programming language (Python, Java, or Scala)
- Experience designing and implementing ETL/ELT processes and data pipelines
- Strong understanding of data governance, data quality, security, and compliance principles
- Proven problem-solving skills with ability to troubleshoot complex technical issues
Nice To Haves
- Experience with cloud platforms (AWS, Azure, or Google Cloud) and modern data stack tools
- Familiarity with agile development methodologies and version control systems (e.g., Git)
- Snowflake or Teradata certifications
- Familiarity with Salesforce applications including Salesforce Financial Services cloud and Salesforce Marketing cloud.
- Demonstrated adaptability, critical thinking skills, and a growth mindset
Responsibilities
- Understand and support our Tealium Customer Data Platform (CDP) and Amplitude analytics tooling.
- Build and optimize ETL/ELT pipelines to ingest, transform, and load data from multiple sources
- Utilize enterprise data warehouse platforms, including Snowflake and Teradata solutions.
- Develop and maintain data models, dimensional schemas, and data transformation logic to support business intelligence and analytics
- Implement data governance, quality checks, and performance tuning across warehouse environments
- Collaborate with cross-functional teams including analytics, business stakeholders, and IT to ensure data availability and integrity
- Troubleshoot and resolve technical issues related to data ingestion, transformation, and query performance
- Develop and maintain comprehensive documentation of data architectures, lineage, and technical configurations
Benefits
- A comprehensive Total Rewards Program including bonuses and flexible benefits
- competitive compensation
- commissions
- stock where applicable
- Leaders who support your development through coaching and career opportunities
- Ability to make a difference and create 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
- Opportunities to take on progressively greater accountabilities
- Opportunities to building close relationships
- Access to a variety of job opportunities across business and geographies
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
