Data Engineering Analyst

CoFoMo Inc.; Montreal (administrative region); On-site; CAD 100,000 - 170,000; Full time

Job summary

CoFoMo Inc. in Montreal, Canada, is seeking an experienced Data Engineer to manage a multi-account Snowflake infrastructure and automate provisioning with Terraform. You will implement Snowflake BI features, RBAC, and secure network policies while maintaining IaC across accounts.

You will also develop validation pipelines, collaborate with architecture and security teams, review code, and contribute to agile processes to deliver scalable data solutions.

Qualifications

• Minimum 5 years of data engineering experience in a large organization.
• Minimum 2 years with Snowflake administration or development.
• SnowPro Core or Advanced certification, or plan to obtain within 6 months.
• Bachelor's degree in CS/SE/CE or related field.
• Proficient in multi-account Snowflake administration, data sharing, and monitoring.
• Familiar with Snowflake security: per-row policies, dynamic data masking, labeling.
• Experience with Snowflake Cortex or AI features.
• Master SQL including views, procedures, streams, tasks, and complex aggregations.
• Experience with AWS: IAM, VPC, PrivateLink, CloudWatch in Snowflake context.
• Understand secure network architectures: segmentation, PrivateLink, DNS.
• Develop automation using Python.
• Use GitHub, GitHub Actions, Vault, and CI/CD pipelines.
• Apply data governance: classification, cataloging, and lineage.
• Knowledge of automated testing, application security, and CI/CD practices.
• Work in an Agile framework (SAFe, Scrum, or Kanban).
• Adopt strong coding, documentation, code review, and QA practices.
• Knowledge of dbt is an asset.
• Snowflake Organizations multi-account management concepts are an asset.
• Power BI or Tableau integrated with Snowflake is an asset.
• FinOps principles related to Snowflake cost optimization is an asset.
• Data testing frameworks are an asset.
• Experience in regulated environments (banking, insurance, government) is an asset.
• Demonstrate rigor, autonomy, collaboration, safety, quality, and problem solving.

Responsibilities

• Master Terraform to automate provisioning of Snowflake and AWS accounts and resources.
• Develop and configure a multi-account Snowflake infrastructure including data sharing mechanisms.
• Implement and configure Snowflake's native business intelligence features according to design specifications.
• Design aggregated exposure views without personal information and validation mechanisms before sharing.
• Implement the analytical RBAC model, including functional roles, access profiles and identity integration.
• Configure network security controls and access policies.
• Maintain infrastructure as code covering accounts, roles, network policies, data warehouses, and monitoring.
• Develop validation and audit pipelines for residual PII detection, usage tracking, and consumption alerts.
• Collaborate with architecture and security stakeholders on design of technical solutions.
• Perform code reviews, optimize performance, and support releases.
• Document configurations, deployment processes, and operational procedures.
• Actively participate in the team's Agile activities.

Skills

Autonomy

Rigor

Collaboration

Problem solving

Communication

Education

Bachelor's degree in CS/SE/CE or related field

Tools

Terraform

Snowflake

AWS

Python

SQL

GitHub

GitHub Actions

Vault

CI/CD

dbt

Power BI

Tableau

PrivateLink

VPC

IAM

CloudWatch

Job description

Here's a brief overview of the tasks and responsibilities you'll have:

• Master Terraform to automate the provisioning of Snowflake and AWS accounts and resources;
• Develop and configure a multi-account Snowflake infrastructure including data sharing mechanisms;
• Implement and configure Snowflake's native business intelligence features according to design specifications;
• Design aggregated exposure views without personal information and validation mechanisms before sharing;
• Implement the analytical account RBAC model, including functional roles, access profiles and integration with identity management solutions;
• Configure network security controls and access policies;
• Maintain infrastructure as code covering accounts, roles, network policies, data warehouses, and monitoring mechanisms;
• Develop validation and audit pipelines for residual personal information detection, usage tracking, and consumption alerts;
• Collaborate with architectural and security stakeholders on the design of technical solutions;
• Perform code reviews, optimize performance, and support releases;
• Document configurations, deployment processes, and operational procedures;
• Actively participate in the team's Agile activities.

Qualifications

• Have a minimum of five (5) years of experience in data engineering within a large organization;
• Possess a minimum of two (2) years of significant experience with Snowflake in administration or development;
• Have a SnowPro Core or Advanced certification, or commit to obtaining it within the first six months;
• Have a bachelor's degree in computer science, software engineering, computer engineering, or a related field;
• Proficient in multi-account Snowflake administration, data sharing, advanced RBAC, network policies, and consumption monitoring mechanisms;
• Be familiar with Snowflake security mechanisms, including per-row access policies, dynamic data masking, aggregation policies, and object labeling;
• Demonstrate experience with Snowflake Cortex (Analyst, Search or Intelligence) or a strong ability to adopt native AI features;
• Master advanced SQL, including views, stored procedures, streams, tasks, and complex aggregations;
• Experience with AWS, including IAM, VPC, PrivateLink, and CloudWatch in a Snowflake context;
• Understand secure network architectures, including segmentation, PrivateLink, and DNS;
• Develop automation solutions using Python;
• Use DevOps tools such as GitHub, GitHub Actions, Vault, and CI/CD pipelines;
• Apply data governance principles, including data classification, cataloging, and lineage;
• Demonstrate a good understanding of automated testing, application security, and CI/CD practices;
• Work effectively in an Agile framework such as SAFe, Scrum, or Kanban;
• Adopt strong coding, documentation, code review, and quality assurance practices;
• Knowledge of dbt for SQL transformations and template management (an asset);
• Proficiency in Snowflake Organizations multi-account management concepts (an asset);
• Use self-service analytics tools such as Power BI or Tableau integrated with Snowflake (an asset);
• Understand the FinOps principles related to Snowflake cost optimization (an asset);
• Knowledge of data testing frameworks (an asset);
• Experience in a regulated environment, including banking, insurance, or government (an asset);
• Demonstrate rigor, autonomy, a strong collaborative spirit and an approach focused on safety, quality and complex problem solving.