Data Engineer - Snowflake

Tiger Analytics Inc.; Toronto; On-site; CAD 120,000 - 180,000; Full time

Benefits offered by this job

Career development opportunities

Equal employment opportunities

Job summary

Tiger Analytics is seeking a senior Data Engineer in Toronto to architect and implement advanced analytics capabilities, handling large-scale pipelines on AWS and Snowflake/Databricks. You will design data models, create self-service dashboards, and partner with cross-functional teams to drive insights that power business decisions.

The role requires deep expertise in Python, SQL, PySpark, and modern ELT/ETL patterns, with a focus on scalable data architecture and data lake strategies.

Qualifications

• 12+ years of experience in data engineering with a heavy focus on the AWS Cloud stack and AI.
• 8+ years of experience building and deploying large-scale data processing pipelines in a production environment.
• Advanced proficiency in Python, SQL, and PySpark.
• Creating and optimizing complex data processing and data transformation pipelines using Python.
• Advanced working SQL knowledge and experience with relational databases.
• Deep experience with Snowflake/Databricks on AWS, dbt, and distributed computing frameworks like Apache Spark.
• Understanding of Datawarehouses (DWH) systems, and migration from DWH to data lakes/Snowflake.
• Understanding of ELT and ETL patterns and data modeling.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Experience supporting cross-functional teams in a dynamic environment

Responsibilities

• Architect, design, and implement advanced analytics capabilities.
• Build self-service dashboards and visualization solutions.
• Apply skills to generate insights that help solve business challenges.
• Collaborate with cross-functional teams to drive data initiatives.

Skills

Python

SQL

PySpark

Snowflake

Databricks

dbt

AWS

ETL/ELT

Data Modeling

Data Warehouses

Apache Spark

Tools

Apache Spark

Job description

Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 500 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research firms, including Forrester and Gartner. We are looking for top-notch talent as we continue to build the best analytics global consulting team in the world.

The Data Engineer will be responsible for architecting, designing, and implementing advanced analytics capabilities. The right candidate will have broad skills in database design, be comfortable dealing with large and complex data sets, have experience building self-service dashboards, be comfortable using visualization tools, and be able to apply your skills to generate insights that help solve business challenges. We are looking for someone who can bring their vision to the table and implement positive change in taking the company's data analytics to the next level.

Requirements

• 12+ years of overall industry experience specifically in data engineering with a heavy focus on the AWS Cloud stack and AI.
• 8+ years of experience building and deploying large-scale data processing pipelines in a production environment.
• Advanced proficiency in Python, SQL, and PySpark.
• Creating and optimizing complex data processing and data transformation pipelines using python
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Deep experience with Snowflake/Databricks on AWS, dbt, and distributed computing frameworks like Apache Spark.
• Understanding of Datawarehouse (DWH) systems, and migration from DWH to data lakes/Snowflake
• Understanding of ELT and ETL patterns and when to use each. Understanding of data models and transforming data into the models
• Strong analytic skills related to working with unstructured datasets
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Experience supporting and working with cross-functional teams in a dynamic environment

Benefits

Significant career development opportunities exist as the company grows. The position offers a unique opportunity to be part of a small, challenging, and entrepreneurial environment, with a high degree of individual responsibility.

Tiger Analytics provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, national origin, ancestry, marital status, protected veteran status, disability status, or any other basis as protected by federal, state, or local law.