Data Engineer - Snowflake

Tiger Analytics; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading analytics consulting firm in Ontario is seeking a skilled Data Engineer to architect and implement advanced analytics capabilities. You will work with large data sets and visualization tools to generate insights driving business solutions. The ideal candidate has over 8 years of industry experience, strong skills in Python, SQL, and data engineering, and a commitment to implementing impactful data strategies. Opportunities for career development exist in this entrepreneurial environment.

Benefits

Significant career development opportunities

Qualifications

• 8+ years in industry, specifically in data engineering.
• 5+ years building large-scale data processing pipelines in production.
• Experience in creating and optimizing data processing pipelines.

Responsibilities

• Architect and design advanced analytics capabilities.
• Build self-service dashboards and visualization tools.
• Support data transformation and workload management.

Skills

Data engineering expertise

Python

SQL

PySpark

Data warehouse systems

Databricks

Data transformation skills

Analytic skills with unstructured datasets

Tools

Snowflake

DBT

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 100 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.

• 8+ years of overall industry experience specifically in data engineering
• 5+ years of experience building and deploying large-scale data processing pipelines in a production environment.
• Strong experience in Python, SQL, and PySpark
• Creating and optimizing complex data processing and data transformation pipelines using python
• Experience with “Snowflake Cloud Datawarehouse” and DBT tool
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Understanding of Datawarehouse (DWH) systems, and migration from DWH to data lakes/Snowflake
• Experience on Databricks is plus
• 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

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.