Snowflake Data Engineer at Capgemini; responsible for designing and maintaining data warehouse solutions. Focused on analytics support and infrastructure optimization.
Responsibilities
Design, develop, and maintain data warehouse solutions using Snowflake
Work extensively with Snowflake architecture , including: Virtual Warehouses, Micro‑partitions, Clustering, Data Sharing
Develop and optimize complex SQL queries , views, and stored procedures
Build and maintain ETL / ELT pipelines using tools such as: Informatica, Matillion, Apache Airflow or similar frameworks
Implement and optimize data models (Star and Snowflake schemas).
Perform performance tuning and cost optimization in Snowflake
Integrate Snowflake with cloud storage and services.
Ensure adherence to data security , role‑based access control (RBAC), and governance best practices.
Collaborate closely with analytics, reporting, and business teams
Requirements
7–9 years of experience in Data Warehousing & Analytics
Strong hands‑on experience with Snowflake
Advanced proficiency in SQL
Experience with ETL/ELT tools (Informatica, Matillion, Airflow, or similar)
Solid understanding of data modeling concepts
Hands‑on experience with cloud platforms : AWS, Azure, or GCP
Experience with CI/CD pipelines , Git , and version control
Good understanding of analytics engineering best practices.
Experience in large‑scale enterprise data platforms
Exposure to advanced Snowflake features and cost optimization strategies
Prior experience supporting analytics and BI use cases
Benefits
Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility
Administrateur principal de plateformes de données chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Conception, exploitation et gouvernance de plateformes de données infonuagiques.
Senior Data Platform Administrator shaping and operating EDC’s secure enterprise data platforms. Supporting Canadian businesses through Export Development Canada’s trade - finance solutions.
Staff full - stack engineer architecting GitLab’s data products, integrations, and knowledge graph. Building APIs, marketplace data access, and AI - powered developer intelligence.
Data Governance Architect shaping governance strategies and cloud data architectures for Lovelytics’ enterprise data and AI consulting clients. Leading technical delivery, presales, migrations, and governance implementations on Databricks.
Senior Data Engineer owning Databricks lakes, pipelines, and AI data infrastructure. Building Quandri’s AI operating system for insurance agencies and brokerages.
Senior Data Engineer architecting Azure and Databricks data platforms for TTEC Digital’s client experience solutions. Building governed pipelines, APIs, MCP integrations, and agentic AI data services.
Senior Data Engineer building Palantir Foundry data solutions for Unit8, a Swiss AI and data analytics consultancy. Supporting client delivery and establishing its Canadian market presence.
Staff Software Engineer building AWS data infrastructure and integrations for Solink’s cloud video - security platform. Driving scalability, architecture, and engineering mentorship.
Senior Azure Fabric Data Engineer building reliable pipelines and modern data platforms for Data Elephant, a Canadian data, analytics, and AI consultancy. Delivering trusted datasets for reporting, AI, and machine learning.
Senior Data Architect leading Microsoft Fabric implementations for Data Elephant, a Canadian data, analytics, and AI consulting firm. Designing secure Azure, OneLake, and Fabric platforms for clients.