Senior Data Warehouse Developer
Pinnacle
Job Title:
Senior Data Warehouse DeveloperReports to:
Data Warehouse Technical LeadAbout 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.
#J-18808-Ljbffr
Senior Data Warehouse DeveloperReports to:
Data Warehouse Technical LeadAbout 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.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Senior Data Warehouse Developer in Winnipeg, MB vacancy
- Build data warehouse and BI solutions at Novo Nordisk using T-SQL and Power BI. Shape reporting capabilities that support business decisions.As a Senior Application Developer, you will adapt data warehouses, ETL processes, and reporting platforms for evolving analytical requirements...Senior
- About the Role Our client, a reputable analytics firm, is seeking an experienced Senior Data Warehouse Developer to join their growing business intelligence team in Kimberley. This role is critical in designing, developing, and maintaining the organization's data warehouse...SeniorWork at officeRemote work
- ...development using various versions of Teradata6+ years of Enterprise Data Warehouse ETL development.6+ years of experience with proficiency in SQL... ..., releases.Excellent written and verbal communication skills.Develops statements of problems and requirements. Can translate both...Senior
$180k - $200k per year
...Job Title: Staff Data Scientist (AI & Machine Learning) Location: Vancouver, BC – 3 days a week onsite Job ID: 87597 Overview As... ...visionary and a strategic leader within our AI organization. While a Senior Data Scientist excels at building and deploying specific models,...Senior3 days per week- A software solutions provider is seeking an experienced ETL developer in Canada with strong proficiency in Teradata SQL and BTEQ. Candidates... ...ETL development experience and 6+ years working in enterprise data warehouses. Strong documentation skills and the ability to translate...Senior
$94.62k - $128.02k per year
...impactWe're looking for an experienced data developer who can build, support and improve the data... ...analysts and business partners. As a Senior Data Developer you'll design, develop,... ...monitoring, data governance, data lake or data warehouse concepts Experience working in Agile...SeniorPermanent employmentFlexible hours- ...and collaboration, we’re building a stronger, more resilient Stantec every day. Your OpportunityWe are seeking an Oracle BI/Data Warehouse Developer with strong experience across the Oracle analytics and reporting ecosystem. This role focuses on translating business needs...Long term contractFull timeTemporary workPart timeCasual work
- ...requesting resumes for the following position : Senior Data DeveloperResume Due Date : Wednesday,... ...OverviewJOB FUNCTIONAs a Senior Data Developer, you will be responsible for building... ...supportable & performant data lake & data warehouse products to meet the organization’s need...SeniorLong term contract
- ...Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This permanent, full-time role connects critical business... ..., databases, and pipelines for performance and reliability Develop ETL/ELT processes from multiple source systems Support Power...Permanent employmentFull time
- ...powered advice on this job and more exclusive features. Job DescriptionAs a Senior Data Developer, Analytics, you will design, build, and maintain reliable data pipelines and analytics warehouse workflows that ensure accurate, timely, and accessible data across MEDFAR. You...SeniorPermanent employmentFull timeWork at officeRemote work
- Lead data warehouse delivery through Tableau, AWS, SQL, and PL/SQL expertise. Build scalable ETL/ELT processes and analytics solutions for business... ...warehouse modeling. You will collaborate with stakeholders, develop Tableau reports, and provide technical guidance. AWS...Senior
$105k - $135k per year
...#1 virtual care provider in Canada. By developing our Integrated Health Platform, we provide... ...the role on our official careers page.Senior Data Platform Developer We are looking for... ...Access Control: Optimize our Snowflake warehouse for performance and cost efficiency....SeniorInternshipWork at officeRemote work3 days per week- ...les systèmes en aval dans l'ensemble du maillage de données ( data mesh ) de SSENSE. Évoluant au sein du groupe Technologie et ingénierie... ...of 100 million monthly page views. About the RoleAs a Senior Data Developer, Data & AI, you will be responsible for designing and...SeniorLong term contractPermanent employmentFull timeContract workTemporary workWork at office
- Employment Type: Permanent Job Description: Senior Data Developer- Montreal onlyOur data platform powers analytics and AI products for over 200 global travel partners and we need a technical leader to build pipelines that can handle this scale. This is your chance to own complex...SeniorPermanent employmentWorldwide
- AI Platform & Data Engineering builds and operates the data platform behind TS Imagine’s... ..., common data, and corporate actions.As a Senior Data Engineer, you will own production data... ...vendors, internal systems, APIs, and files.Develop and maintain dbt models and Snowflake data...SeniorWork at office
$122k - $150k per year
...working toward Teck’s purpose of providing the essential resources the world relies on. Role OverviewReporting to the Lead, the Senior Data Developer is responsible for supporting the development of reliable site data that enables Operations performance reporting and...SeniorLong term contractWork at office$107k - $157.3k per year
The Forma Data Delivery group at Autodesk is looking for a Senior Software Developer to help build reliable, scalable data products and platform capabilities for the construction... ...with large datasets, analytical data stores, warehouses, lakehouse architectures, or object storage...Senior- ...advanced SQL, query optimization, and data integration for a long-term opportunity... ...to complex applications.This Senior Oracle PL/SQL Developer role requires 10+ years of Oracle database... ...tune database performanceDesign data warehouses and support ETL developmentTranslate business...SeniorLong term contract
- Lead Cognos reporting and data analytics in a hybrid senior developer assignment, working onsite three days weekly and remotely two days.This Senior Software... ...on Cognos 11.X, business intelligence, and data warehouse development. You will support PEAR, Panorama Enhanced Analytic...SeniorRemote work
- Job Title : Senior Data Warehouse/BI Architect Location : Burnaby, BC Work Setting : Hybrid, Monday to Friday. This role requires working... ...In this role, you will be responsible for architecting and developing enterprise data models, data governance frameworks, ETL/pipelines...SeniorFull timeInternshipWork at officeMonday to friday1 day per week
- ...teammates, you'll feel right at home here. About The TeamOur Data team is the backbone of Nesto Cloud, managing the flow of... ...that powers Canada's most advanced mortgage platform. As a Senior Data Reliability Developer, you won't just be "checking results"; you will be a...SeniorLong term contractInternshipWork from homeShift work
- Must HavesAzure DatabricksPython,Azure Data Factory, Power BIDescriptionData Science Developer – Deliverables The candidates will perform Data Science Developer work by creating, enhancing, maintaining, supporting, and sustaining existing pipelines, analytics models, and...SeniorWork at office3 days per week
$140k - $170k per year
...part of how we build products and improve internal operations. Our Data team brings strong data engineering and science foundations; this role adds dedicated production AI engineering. As a Senior AI Developer, you'll design, build, and operate the AI systems and agentic...SeniorLong term contractWork at officeLocal areaRemote workWork from homeWorldwideFlexible hoursShift work- Join AtkinsRéalis as a Senior Data Developer focused on enterprise data platforms. Leverage Azure Data technologies to deliver impactful data engineering solutions in a collaborative environment. As a Staff Data Developer at AtkinsRéalis, you will play a crucial role in optimizing...Senior
- Job TitleRQ-2026-009857 - Senior Data Science Developer for the Mental Health & Addiction program Location: 3 days on-site as per manager's discretion (525 University Avenue,Toronto)Description Background Information: The Agency Mental Health & Addiction program requires...Senior
- Shape cloud data warehouses and production pipelines for Beatport’s global music brands while working remotely from Canada or the USA Pacific Northwest.This Senior Data Engineer role focuses on ownership, design, and delivery across finance and data warehousing. You will work...SeniorRemote work
- Precision Technologies is seeking an experienced Power BI Developer with a strong BI and data warehousing background in Canada. You will design scalable data solutions, develop ETL processes, and transform complex data into actionable insights. Proficiency in DAX, SQL, Snowflake...Senior
- 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...Senior
- Explore new possibilities in public transit as a Creative Senior Data Developer at Transit. Join a passionate team committed to transforming rider experiences through data. In your senior capacity at Transit, you'll blend your engineering expertise with a passion for data...Senior
- Lead automated data and software quality testing as a Senior ETL Developer in a hybrid assignment requiring three onsite days weekly. Work with Azure, Databricks, and Power BI.This senior role combines data engineering, QA, and DevOps practices under the IT QA Lead. You will...Senior
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Warehouse Developer. Be the first to apply!
Related searches
- senior financial accountant Winnipeg, MB
- senior sales consultant Winnipeg, MB
- senior communications specialist Winnipeg, MB
- senior bookkeeper Winnipeg, MB
- senior system administrator Winnipeg, MB
- senior technical recruiter Winnipeg, MB
- senior director Winnipeg, MB
- senior technical specialist Winnipeg, MB
- senior internal auditor Winnipeg, MB
- senior line cook Winnipeg, MB

