Go to content
85066

Data Engineering Analyst

Montreal
Hybrid
Data and Artificial Intelligence

With over 30 years of recognized expertise, COFOMO is now a leading Canadian consulting firm specializing in digital and artificial intelligence. Supported by more than 3,000 experts, 10 Centers of Excellence, and 4 offices across the country, we are uniquely positioned to successfully guide our clients through their transformations. Both strategic and tactical, we help organizations across a wide range of industries thrive in today’s rapidly evolving world.

Our promise

Help our clients succeed and maximize the impact of their transformation initiatives, turning them into powerful drivers of growth and innovation.

 

Job description

and AWS resources. Develop and configure the Snowflake multi-account infrastructure (source Horizon account? consumer analytics account via Direct Share). Implement and configure Snowflake Intelligence (Cortex Analyst) according to the design specifications: deploy the provided semantic models, configure custom statements and the Verified Query Repository (VQR). Develop non-PII aggregate exposure views and pre-share validation mechanisms according to established governance rules. Implement the analytical account RBAC model: creation of functional roles, access profiles by business line, integration with Azure AD and IIQ. Configure Network Security Policies to restrict access to the BNC corporate network. Develop and maintain infrastructure as code via Terraform (account setup, RBAC, Network Policies, warehouses, monitoring). Develop validation and audit pipelines: detection of residual PII, usage monitoring, consumption alerts. Participate in the design of technical solutions in collaboration with the architect and the Security team. Perform code reviews, optimize performance, and support releases. Document configurations, deployment processes, and operational runbooks. Collaborate in an Agile framework (Scrum / Kanban) and actively participate in team ceremonies.Essential SkillsSnowflake & Data
  • Demonstrated expertise on Snowflake: multi-account administration, Data Sharing, advanced RBAC, Network Policies, Resource Monitors.
  • In-depth knowledge of Snowflake security mechanisms: Row Access Policies, Dynamic Data Masking, Aggregation Policies, Object Tagging.
  • Experience with Snowflake Cortex (Analyst, Search, Intelligence) or demonstrated ability to rapidly adopt native AI capabilities.
  • Strong command of advanced SQL (views, stored procedures, Streams & Tasks, complex aggregations).
Cloud and Infrastructure
  • Experience with AWS (IAM, VPC, PrivateLink, CloudWatch) in a Snowflake context.
  • Proficiency in Terraform (IaC) for provisioning Snowflake accounts and resources.
  • Understanding of secure network architectures (segmentation, PrivateLink, DNS).
  • Excellent Python skills for development and automation.
DevOps & Governance
  • Advanced experience with DevOps tools: GitHub, GitHub Actions, Vault, CI/CD, automation.
  • Familiarity with data governance processes: classification, cataloguing (Collibra), lineage.
  • Strong understanding of CI/CD concepts, automated testing, application security.
Methodologies
  • Demonstrated experience in Agile (SAFe, Scrum, Kanban).
  • Strong coding practices, code review, documentation, and testing.
Skills assets
  • Experience with dbt for SQL transformations and model management.
  • Knowledge of Snowflake Organizations and multi-account management.
  • Familiarity with self-service analytics tools (Power BI, Tableau) and their Snowflake integration.
  • Exposure to FinOps concepts (Snowflake cost optimization: warehouses, Intelligence credits).
  • Knowledge of data testing frameworks.
  • Understanding of regulatory requirements in the financial sector (protection of PI, access control, auditability).
Experience and training
  • Minimum 5 years of experience in data engineering in a large company.
  • Minimum 2 years of significant experience with Snowflake (administration or development).
  • SnowPro Core or Advanced certification (required or to be obtained within the first 6 months).
  • Bachelor's degree in Computer Science, Software Engineering, Computer Engineering, or related field.
  • Experience in a regulated environment (banking, insurance, government) is a strong asset.
Desired profile
  • Ability to implement technical solutions based on design specifications.
  • Sensitivity to governance and data protection — "security by design" reflex.
  • Rigour, autonomy and a strong focus on quality and reliability.
  • Ability to solve complex problems and work in distributed environments.
  • Excellent communication skills and collaborative spirit.
  • Curiosity and active monitoring of the Snowflake ecosystem and native AI features.

Why choose a career at COFOMO?*

  • Competitive compensation and benefits
  • Wellness program
  • 24/7 telemedicine access
  • Support for legal, accounting, and mental health needs
  • Focus on growth, development, and skills enhancement
  • Personalized career plan and tailored guidance
  • Hybrid work environment
  • Active social club and year-round events

* Only applicable to permanent COFOMO employees.

Expert discussing the benefits of working at COFOMO, a digital transformation and artificial intelligence firm.
Make things happen.

Join our team.

Make a difference every day by taking advantage of our development programs, access to our Centers of excellence, and a stimulating work environment.

Life at COFOMO
  • Professional development

    We invest in our talent, encourage continuous growth, and support you in every aspect of your career.

  • Latest technologies and best practices

    Leverage your skills, knowledge, and problem-solving abilities on large-scale projects for leading clients.

  • Welcoming and people-focused organization

    A place where you can feel at home. COFOMO is a space where you can grow, learn, create, contribute, and be recognized for your achievements.

Working at COFOMO gives you the opportunity to collaborate today on the technological projects of tomorrow, from green technology to the latest innovations in artificial intelligence and information security.

Our Values

Beyond words, COFOMO’s values guide our actions and shape our policies. Without them, we’d be just another company, and we are anything but that.

Commitment
We are committed to mobilize as a team to achieve common goals.
Courageous
We have the courage to innovate, to speak frankly and act with respect and equity.
Diversity
We believe in the unique richness of each person
Passion
We love what we do, and that passion is what powers our excellence and success.
Creativity
We think creatively to deliver value in everything we do.

At COFOMO :

You are recognized and valued for your skills, expertise, and, most importantly, your potential. That’s how we measure value here.

We hire people based on talent. Period.

Everyone matters, everyone’s voice counts, and everyone is respected.

COFOMO values the differences that enable each of us to make meaningful and unique contributions to our success and shared culture. We foster diversity and inclusion, creating workplaces where new ideas, different experiences, and unique perspectives can be shared, often with people you might not otherwise have the opportunity to collaborate with.

MASCULINE OR FEMININE TERMS ARE USED INTERCHANGEABLY WITHOUT ANY INTENT OF DISCRIMINATION. COFOMO IS AN EMPLOYER OF CHOICE THAT PROMOTES DIVERSITY AND APPLIES FAIR EMPLOYMENT PRACTICES.

Employer of choice

COFOMO is a consulting firm specializing in digital transformation and artificial intelligence. We stand out for the digital ingenuity of our talent, our unique approach, and our values. Make an informed choice and discover what makes us