Senior Data Engineer - Snowflake​/Azure; Hybrid

Position: Senior Data Engineer - Snowflake/Azure (Hybrid)
Senior Data Engineer (Corporate Data and Analytics)

Location:

Toronto, Ontario, Canada

Posting Type:  Replacement Position

Salary Range:  $106,202 - $148,682 (base)

Reporting Relationship:  Manager, Data Engineering

As the Senior Data Engineer, you will create data collection, extraction, and transformation frameworks for structured and unstructured data. You will develop data infrastructure systems (e.g., data warehouses, data lakes) including data access points; prepare and manipulate data using Kafka, Talend, MS SQL, Azure Data Factory and other data pipeline tools. You will also organize data into formats and structures that improve reuse and efficient delivery to businesses and analytics teams, integrate data across the lake, warehouse and system applications, and be accountable for efficient architecture and system design.

What You’ll Do

Lead the architecture, design and implementation of complex data architecture and integration solutions including best practices for the full development life cycle, coding standards, code reviews, source control management, build processes, testing, and operations.

Build and evolve the data service layer and engage the team to bring together components for an outstanding customer offering.

Engage with partners to establish clear needs and links to solutions, including setting up prototypes and involving multiple parties in design sessions.

Develop data pipelines using modern tools.

Create efficient load processes including logging and handling of exceptions, notification to support, and overall visibility operations.

Perform database monitoring and collaborate with database administrators to optimize performance.

Lead the analysis of database entities, relationships, and attributes to determine efficient design solutions.

Collaborate with company partners to ensure adherence to standards for code, design, documentation, testing and deployment.

Collaborate with data governance and strategy to ensure data lineage is well understood and constructed to highlight data reuse and simplicity.

Assess new opportunities to simplify the data operation with new tools, technologies, file storage, management and process, and bring forward for team assessment and implementation.

What You Bring

Bachelor's degree required (master's an asset) in Software Engineering, Computer Science, or equivalent work experience in a technology or business environment.

Minimum of 10 years of experience working in developing and following structured work processes in data engineering.

Minimum of 4 years of experience in Data Solutions Architecture.

Minimum of 4 years of experience in integration solutions development with any pipeline tools (Informatica, Data Stage, SSIS, Talend).

Proficiency in Snowflake, Talend, Where Scape, Data Vault 2.0, Kafka, Active Batch, Azure Data Bricks, Python, SQL.

Experience with cloud platform services such as Azure and AWS.

Proficient in multiple programming languages and coding; excellent ability to design and engineer moderately complex enterprise solutions.

Proficient in data management, governance, data design and database architecture; experience manipulating, processing and extracting value from large, disconnected datasets.

Proficient in data modelling, data integrations, data orchestration, and supporting methodologies.

Proficient in leading large‑scale projects or project steps and communicating progress and approach with technical and non‑technical peers, clients and leaders.

Nice-to-Have

Knowledge of Business Intelligence, Analytics and Reporting.

Build dashboards and data visualizations (Power

BI, Collibra).

Experience working with Dev Ops pipelines (Git, Maven, Git Lab, Jenkins), continuous integration/delivery, automated testing (unit, functional, performance).

What You Get

Comprehensive Total Rewards Program including bonuses, flexible benefits starting from day 1 and choice of either a health spending account (HSA) or personal spending account (PSA).

RRSP matching & defined contribution pension plan.

Learning & development programs and resources including unlimited free access to Coursera and an Educational Assistance Program.

Holistic approach to well‑being with an…