Senior Data Engineer

<div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><p style="text-align:left"><b><u>Job Description</u></b></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><p><b>WHAT IS THE OPPORTUNITY?

</b></p><br /><p>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.

You will blend traditional enterprise data warehousing concepts with modern cloud technologies, specifically leveraging Informatica (PowerCenter/IDMC) and Snowflake, while using Python for advanced scripting, customization, and automation using frameworks such as Django, FastAPI, or Flask, and proficiency in Unix/Linux scripting.</p><br /><p><b>WHAT WILL YOU DO?</b></p><ul><li>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</li><li>Build and optimize complex data mappings, task flows, and transformations using Informatica Intelligent Cloud Services (IICS/IDMC) or PowerCenter</li><li>Manage and tune Snowflake environments, including workload management, query optimization, virtual warehouse sizing, and cost optimization</li><li>Develop custom Python components, reusable frameworks, and PySpark scripts for advanced processing and data validation</li><li>Implement dimensional data models, star/snowflake schemas, and Slowly Changing Dimensions (SCD Type 1 & Type 2) to support analytics requirements</li><li>Establish and maintain automated CI/CD deployment pipelines (Git-based) for database schemas, Python code, and Informatica assets</li><li>Design and implement automated data quality checks, reconciliation processes, audit controls, and end-to-end data lineage</li><li>Partner with architecture, business intelligence, and data science teams to translate complex requirements into scalable technical solutions; mentor junior engineers on best practices</li></ul><br /><p><b>WHAT DO YOU NEED TO SUCCEED?

</b></p><p><b>Must Have:</b></p><ul><li>7–10+ years of professional experience in data engineering, ETL development, and enterprise data warehousing</li><li>5+ years of hands-on development using Informatica PowerCenter or Informatica Cloud (IICS/IDMC)</li><li>5+ years of deep technical expertise in Snowflake, including SnowSQL, Snowpark (Python), and native cloud loading</li><li>Advanced proficiency in Python (including libraries like Pandas or PySpark) and expert-level SQL development (stored procedures, analytical functions, performance tuning).

</li><li>Strong familiarity with cloud ecosystems such as AWS (S3, Lambda, Glue) or Microsoft Azure</li><li>Proven experience with version control systems (Git) and automated deployment tools (Azure DevOps, or GitHub Actions).</li><li>Strong problem-solving, analytical thinking, and excellent communication skills with the ability to collaborate across functions</li></ul><br /><p><b>Nice-to-Have:</b></p><ul><li>Official certifications such as Snowflake Certified Core Engineer or Informatica Cloud Data Integration Specialist.

</li><li>Experience with one of cloud platforms (AWS, Azure, or GCP)</li><li>Exposure to big data tools (Spark, Kafka, etc.)</li><li>Understanding of data security and compliance</li><li>Prior experience preparing and optimizing datasets for machine learning and AI initiatives.</li></ul><br /><p><b>WHAT'S IN IT FOR YOU?</b></p><ul><li>A comprehensive Total Rewards Program including competitive compensation, bonuses, and flexible benefits</li><li>Leaders who invest in your development through coaching and career advancement opportunities</li><li>Ability to drive meaningful impact on RBC's data and technology strategy</li><li>Work with a dynamic, collaborative, high-performing team on enterprise-scale challenges</li><li>Opportunities to take on progressively greater accountabilities and technical leadership roles</li><li>Access to learning resources and career development across RBC's business</li></ul><p><b>#LI-POST</b></p><p><b>#TechPJ</b></p><p></p><p></p><p style="text-align:left"><u><b>Job Skills</b></u></p>Collaboration, Cross-Functional Teamwork, Data Analysis, Data Analytics, Data Architecture Development, Data Development, Data Governance, Data Management, Data Processing, ETL Processing, Quality Management<p></p><p></p><p style="text-align:left"><u><b>Additional Job Details</b></u></p><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><p style="text-align:left"><b>Address:</b></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>745 THURLOW ST:VANCOUVER<div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><div><p style="text-align:left"><b>City:</b></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>Vancouver<div><div><div><div><div><div><d