Senior Snowflake Data Platform Engineer

IGT; City of Moncton; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading global lottery company is seeking a skilled Data Platform Engineer to architect and optimize their enterprise data platform. The role will focus on Snowflake, requiring robust database schema design and data integration skills. The ideal candidate will have over 5 years of data engineering experience, proficiency in SQL, and programming skills in Python or Java. The position offers an opportunity to work with advanced analytics in a diverse and inclusive environment.

Qualifications

• 5+ years of experience in data engineering, database design, or data platform development.
• Strong expertise in Snowflake, including schema design and performance tuning.
• Proficiency in SQL with experience writing complex queries.
• Experience with data integration from various sources such as APIs and flat files.
• Understanding of ETL/ELT frameworks and orchestration tools.
• Solid programming skills in Python or Java.

Responsibilities

• Design and implement robust, scalable, and performant Snowflake database schemas.
• Define and maintain semantic layers for self-service analytics.
• Develop and optimize SQL for data transformation.
• Integrate data from diverse sources including relational databases.
• Monitor and tune performance of data pipelines.

Skills

Data engineering

Database design

Data platform development

Snowflake

SQL

Data integration

Python

Java

Tools

Snowflake

dbt

Airflow

AWS

Azure

GCP

Tableau

Power BI

Job description

A leading global lottery company is seeking a skilled Data Platform Engineer to architect and optimize their enterprise data platform. The role will focus on Snowflake, requiring robust database schema design and data integration skills. The ideal candidate will have over 5 years of data engineering experience, proficiency in SQL, and programming skills in Python or Java. The position offers an opportunity to work with advanced analytics in a diverse and inclusive environment.