Senior Data Engineer

CNB (City National Bank), an RBC company, is modernizing its data architecture as a core part of our digital transformation strategy.

We're seeking a Senior Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem.

In this critical role, you will design end-to-end data solutions leveraging Informatica (PowerCenter/IDMC) and Snowflake, while driving our data modernization initiatives forward.

Responsibilities

• Design, build, and maintain robust batch and near-real-time ETL/ELT pipelines to ingest and transform data from diverse enterprise sources (APIs, databases, third-party systems) into Snowflake
• Build and optimize complex data mappings, task flows, and transformations using Informatica Intelligent Cloud Services (IICS/IDMC) or PowerCenter
• Manage and tune Snowflake environments, including workload management, query optimization, virtual warehouse sizing, and cost optimization
• Develop custom Python components, reusable frameworks, and PySpark scripts for advanced processing and data validation
• Implement dimensional data models, star/snowflake schemas, and Slowly Changing Dimensions (SCD Type 1 & Type 2) to support analytics requirements
• Establish and maintain automated CI/CD deployment pipelines (Git-based) for database schemas, Python code, and Informatica assets
• Design and implement automated data quality checks, reconciliation processes, audit controls, and end-to-end data lineage
• Partner with architecture, business intelligence, and data science teams to translate complex requirements into scalable technical solutions; mentor junior engineers on best practices

Requirements

• 7–10+ years of professional experience in data engineering, ETL development, and enterprise data warehousing
• 5+ years of hands-on development using Informatica PowerCenter or Informatica Cloud (IICS/IDMC)
• 5+ years of deep technical expertise in Snowflake, including SnowSQL, Snowpark (Python), and native cloud loading
• Advanced proficiency in Python (including libraries like Pandas or PySpark) and expert-level SQL development (stored procedures, analytical functions, performance tuning).
• Strong familiarity with cloud ecosystems such as AWS (S3, Lambda, Glue) or Microsoft Azure
• Proven experience with version control systems (Git) and automated deployment tools (Azure DevOps, or GitHub Actions).
• Strong problem-solving, analytical thinking, and excellent communication skills with the ability to collaborate across functions

Nice-to-Have

• Official certifications such as Snowflake Certified Core Engineer or Informatica Cloud Data Integration Specialist.
• Experience with one of cloud platforms (AWS, Azure, or GCP)
• Exposure to big data tools (Spark, Kafka, etc.)
• Understanding of data security and compliance
• Prior experience preparing and optimizing datasets for machine learning and AI initiatives.

Benefits

• A comprehensive Total Rewards Program including competitive compensation, bonuses, and flexible benefits
• Leaders who invest in your development through coaching and career advancement opportunities
• Ability to drive meaningful impact on RBC's data and technology strategy
• Work with a dynamic, collaborative, high-performing team on enterprise-scale challenges
• Opportunities to take on progressively greater accountabilities and technical leadership roles
• Access to learning resources and career development across RBC's business