Senior Data Warehouse Developer

Pinnacle; Toronto; Presencial; CAD 120 000 - 170 000; Tempo integral

Resumo da oferta

Pinnacle is seeking a Senior Data Warehouse Developer to lead the modernization of our data platform. The role focuses on migrating the SQL Server data warehouse to Snowflake while keeping legacy systems stable.

You will design and implement end-to-end cloud-native pipelines, manage governance, and drive CI/CD-enabled deployments with dbt and ADF. Collaboration with teams across analytics and engineering is essential.

Qualificações

• 6+ years in cloud data warehousing or data engineering roles.
• Strong Snowflake experience including virtual warehouses, Time Travel, cloning, and performance tuning.
• Proficient in SQL (Snowflake/ ANSI) and dbt for modeling, testing, and CI/CD-driven deployments.

Responsabilidades

• Build and maintain end-to-end cloud-native pipelines ingesting data into ADLS and Snowflake.
• Orchestrate data loads with ADF and design transformations with dbt models.
• Set up and maintain CI/CD-driven DevOps pipelines for deployments.
• Apply dimensional modeling and schema design for performant Snowflake marts used by BI/analytics.
• Optimize compute, clustering, and query performance to balance cost and speed.
• Provide light support for legacy on-prem SQL Server systems during transition.
• Define engineering standards for version control, code review, and testing across ADF and dbt/Snowflake deployments.
• Implement data governance foundations including cataloging, lineage, access control, and quality monitoring.

Conhecimentos

Communication

Analytical thinking

Formação académica

Bachelor's or Master's in Computer Science/Information Systems/Data Engineering

Ferramentas

Snowflake

dbt

Azure Data Factory

Azure Data Lake Storage

Azure DevOps

Microsoft Purview

Descrição da oferta de emprego

Job Title: Senior Data Warehouse Developer

Reports to: Data Warehouse Technical Lead

About us:

Welcome to Pinnacle, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position as one of the globe's foremost licensed online gaming companies. With our cutting-edge offerings, we guarantee an electrifying experience that will keep you on the edge of your seat.

Pinnacle invites you to join our team and become an instrumental figure in the exciting realm of sportsbetting. Our vibrant team is fueled by passion and driven by innovation, working together to redefine the landscape of sports betting and gaming. Together, we constantly strive to surpass limitations and deliver unparalleled experiences to sports enthusiasts worldwide. Prepare yourself for a thrilling journey and discover sports in an entirely new dimension with Pinnacle!

Role Overview

As part of the Data Governance team, you will play a strategic and hands‑on role in modernizing our enterprise data architecture. This position is critical to migrating our SQL Server data warehouse to Snowflake, while ensuring stability and business continuity for the legacy systems that will remain in production throughout the transition.

As a senior data engineer, you will design, implement, and optimize the full‑stack data infrastructure - from Snowflake clusters setup to data ingestion, transformation and report migration. You will drive data governance frameworks aligned with enterprise cataloging, access control, sizing and monitoring Snowflake virtual warehouses.

Key Responsibilities

• Build and maintain end‑to‑end cloud‑native pipelines that ingest data into ADLS and Snowflake, orchestrate data load using ADF, and design transformations with curated DBT models.
• Setup and maintain DevOps pipelines committing CI/CD‑driven deployments.
• Apply dimensional modeling and schema design best practices to build performant, well‑governed Snowflake marts consumed by BI and analytics, apply SDC Type 2 to support “point‑in‑time” reporting.
• Optimize Snowflake compute (warehouse sizing, clustering, query performance) and dbt model performance (materializations, incremental strategies) for cost‑efficient and fast pipelines.
• Provide light‑touch support for legacy on‑premises SQL Server systems only as needed to keep them stable during the transition.
• Define and enforce engineering standards for pipeline development: version control, code review, dbt testing, and CI/CD automation across ADF and dbt/Snowflake deployments.
• Implement and promote data governance foundations, including data cataloging, lineage tracking, access control, data integrity checks and alerts; and quality monitoring (e.g. Snowflake Horizon, Microsoft Purview).
• Work closely with project managers, QA, and other developers; provide support to business users and application developers.

Skills & Qualifications

• Strong verbal and written communication skills with the ability to translate business requirements into scalable technical solutions.
• Proven analytical, conceptual, and problem‑solving skills with a focus on root‑cause analysis and continuous improvement.

Knowledge & Experience

• 6+ years of experience in cloud data warehousing, dimensional modeling and data integration solutions.
• Strong production experience with Snowflake - virtual warehouses, Snowflake Scripting/stored procedures, Streams & Tasks, Time Travel, zero‑copy cloning, and warehouse/query performance tuning.
• Strong hands‑on experience with dbt (dbt Core or dbt Cloud) — building and maintaining models, tests, documentation and CI/CD‑driven deployments.
• Experience with Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) for cloud‑native data ingestion and orchestration.
• Proficiency in Azure DevOps CI/CD, version control, and deployment automation.
• Familiarity with data governance and cataloging tools — Snowflake Horizon, Microsoft Purview, or comparable third‑party catalogs.
• Strong SQL skills (ANSI SQL / Snowflake SQL) for building and tuning analytical queries at scale.
• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or a related field.

Equal Opportunity Employer

We are an equal opportunity employer dedicated to fostering an inclusive and diverse workplace. We prioritize hiring the best candidates based on their skills and qualifications, irrespective of race, gender, age, religion, or any other characteristic. Our strength lies in our diverse teams, and we proudly celebrate and empower everyone to embrace and promote diversity throughout their time with us.

AI Usage

As part of our recruitment process, Pinnacle may use technology‑assisted tools, including AI‑based systems, to support the review and assessment of applications. These tools are used to assist our team and do not make final decisions. All screening, interviewing, and hiring decisions are made by our recruitment and hiring team.