Hybrid Data Engineer: Snowflake & Data Quality

Avanti Software Inc.; Guelph; Hybrid; CAD 70,000 - 75,000; Full time

Benefits offered by this job

Hybrid work arrangement

Competitive salary

Job summary

Royal Distributing in Ontario is hiring a Data Engineer to design and operate our Snowflake-based data warehouse and ETL pipelines. You’ll ensure data quality and provenance so dashboards and reports are trustworthy for marketing, merchandising, and executive teams.

You will work in a hybrid setup based at our Guelph head office, collaborating with analytics stakeholders to translate business questions into robust data models and reliable data flows.

Qualifications

• 2–4 years in data engineering, analytics engineering or a strong BI/data analyst role with pipeline responsibility.
• Strong SQL: joins, window functions, aggregation, incremental patterns.
• Python for data transformation and scripting.

Responsibilities

• Run and extend our ETL pipelines: build new jobs, maintain schedules, handle failures and monitor source freshness.
• Build and maintain integrations to new source systems.
• Write silver-layer transformations in Snowflake SQL — cleaning, conforming and deduplicating source data.
• Own data quality end to end: reconcile warehouse figures against source systems, build validation and testing into pipelines, and document lineage so any number can be traced to its origin.
• Investigate and resolve discrepancies between reports, dashboards and source systems.
• Build and maintain certified data sources for Analytics and business users.
• Support our customer identity resolution program with data preparation, validation and match-quality analysis.
• Contribute to gold-layer marts for customer and sales reporting, working with marketing and analytics stakeholders to understand how the data will be used.

Skills

SQL

Python

Snowflake

ETL

Data validation

Cloud data warehouse

Git

Stakeholder communication

Tools

Snowflake

ETL platform

Git

Job description

Royal Distributing in Ontario is hiring a Data Engineer to design and operate our Snowflake-based data warehouse and ETL pipelines. You’ll ensure data quality and provenance so dashboards and reports are trustworthy for marketing, merchandising, and executive teams.

You will work in a hybrid setup based at our Guelph head office, collaborating with analytics stakeholders to translate business questions into robust data models and reliable data flows.