Data Engineer

Insight Global; Burnaby; On-site; CAD 90,000 - 130,000; Full time

Job summary

Insight Global is seeking a Data Engineer to design, build, and maintain scalable data pipelines in Snowflake using Python and dbt. You will partner with business stakeholders to translate requirements into robust data solutions and drive performance, quality, and cost improvements across the data platform.

The role involves delivering data workflows, integrating BI tools such as Looker, Power BI, and Tableau, and leveraging Snowflake Cortex for AI-enabled insights.

Qualifications

• 2+ years of hands-on Snowflake, dbt, and Python work within the last 4 years.
• Strong SQL proficiency, including writing, optimizing and troubleshooting complex queries.
• Experience implementing and managing CI/CD pipelines for data projects.
• Proficiency with GitHub for source control and collaborative development workflows.
• Experience designing, building, and deploying new data pipelines with stakeholder input.
• Experience maintaining pipelines with defect resolution, performance tuning, and cost control.
• Ability to translate requirements into robust data solutions with business stakeholders.
• Experience with BI tools like Looker, Power BI, and Tableau.
• Knowledge of semantic views and semantic models to support AI agents and analytics.
• Familiarity with Snowflake Cortex and AI-driven insights in Snowflake.

Responsibilities

• Design, build, and maintain scalable data pipelines in Snowflake.
• Partner with business stakeholders to gather requirements and validate architecture.
• Optimize pipelines for performance, data quality, defects, and cost reduction.
• Implement and maintain CI/CD pipelines for data projects.
• Support BI/analytics teams using Looker, Power BI, and Tableau.
• Develop AI-enabled data solutions within Snowflake, including semantic models.

Skills

Snowflake

dbt

Python

SQL

CI/CD pipelines

GitHub

Data pipeline design

BI tools

Snowflake Cortex / AI in Snowflake

Semantic models

Natural language querying

Job description

Job Description

Insight Global is looking for a Data Engineer for one of our clients who will be responsible for designing, building, and maintaining scalable data pipelines that ingest, transform, and store data within Snowflake, leveraging Python and dbt to support enterprise reporting and analytics. The role will partner closely with business stakeholders to understand requirements, validate solution architecture, and deliver efficient, reliable data solutions. The successful candidate will optimize existing pipelines by enhancing performance, improving data quality, resolving defects, and reducing overall platform costs.

Skills and Requirements

• 2+ years of hands-on experience with Snowflake, dbt, and Python, with this experience demonstrated within the most recent 4 years of professional work history.
• Strong proficiency in SQL, including writing, optimizing, and troubleshooting complex queries.
• Experience implementing and managing CI/CD pipelines for data engineering projects.
• Proficiency with GitHub for source control, code management, and collaborative development workflows.
• Proven experience designing, building, and deploying new data pipelines, including gathering business requirements, validating solution architecture, and implementing scalable data solutions.
• Experience maintaining and enhancing existing data pipelines, including issue resolution, bug fixes, performance tuning, optimization, and ongoing support.
• Ability to collaborate with business stakeholders to translate requirements into robust and efficient data engineering solutions.Experience working with BI and data visualization tools, such as Looker, Power BI, and Tableau.
• Hands-on experience with Snowflake Cortex, including leveraging AI and ML capabilities within the Snowflake ecosystem.
• Experience designing and building AI agents within Snowflake.
• Knowledge of semantic views and semantic layers, including developing semantic models that support AI agents and business-facing analytics.
• Familiarity with enabling natural language querying and AI-driven insights through semantic modeling and agent-based architectures in Snowflake.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.