Snowflake Data Engineer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Make it real: Capgemini Global Insights & Data business line is a market leader in the data, platform, and analytics across all regions and cross many sectors (including financi.
Key Skills for This Role
Responsibilities
- Build Snowflake data pipelines, tables, views, procedures, tasks, streams, and transformation logic.
- Implement ingestion, staging, cleansing, transformation, enrichment, and consumption layers.
- Develop source to target mappings for investment, portfolio, accounting, market data, reference data, and operational data sources.
- Build reusable data models for portfolios, holdings, transactions, instruments, valuations, cash, entities, performance, and historical records.
- Support public and private investment data structures, including historical backfill and reconciliation requirements.
- Implement data quality checks, exception handling, audit fields, reconciliation logic, and validation rules.
- Optimize Snowflake performance, including warehouse usage, clustering, query design, data loading, and cost aware engineering.
- Support data security requirements, including role based access, masking, secure views, and data segregation.
- Work closely with Business Analysts, Solution Architect, Integration Engineer, Data Governance Lead, and Test Lead.
- Prepare technical documentation, deployment scripts, data dictionaries, and handover materials.
Requirements
- Snowflake development experience
- Advanced SQL skills
- Data modeling and transformation experience
- Data quality engineering experience
- Historical data backfill experience
- Performance tuning experience
- Investment data awareness
- Documentation and testing discipline
Full Job Posting
Role Overview
- Capgemini Global Insights & Data business line is a market leader in data, platform, and analytics.
- Your Role: Build Snowflake data pipelines, tables, views, procedures, tasks, streams, and transformation logic.
- Implement ingestion, staging, cleansing, transformation, enrichment, and consumption layers.
Responsibilities
- Build Snowflake data pipelines, tables, views, procedures, tasks, streams, and transformation logic.
- Implement ingestion, staging, cleansing, transformation, enrichment, and consumption layers.
- Develop source to target mappings for investment, portfolio, accounting, market data, reference data, and operational data sources.
- Build reusable data models for portfolios, holdings, transactions, instruments, valuations, cash, entities, performance, and historical records.
- Support public and private investment data structures, including historical backfill and reconciliation requirements.
- Implement data quality checks, exception handling, audit fields, reconciliation logic, and validation rules.
- Optimize Snowflake performance, including warehouse usage, clustering, query design, data loading, and cost aware engineering.
- Support data security requirements, including role based access, masking, secure views, and data segregation.
- Work closely with Business Analysts, Solution Architect, Integration Engineer, Data Governance Lead, and Test Lead.
- Prepare technical documentation, deployment scripts, data dictionaries, and handover materials.
Skills
- Snowflake development
- Advanced SQL
- Data modelling and transformation
- Data quality engineering
- Historical data backfill
- Performance tuning
- Investment data awareness
- Documentation and testing discipline
Why Capgemini
- Growing clients businesses while building a more sustainable, more inclusive future.
- Join a thriving company and become part of a collective of free thinkers, entrepreneurs and industry experts.
- By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you'll build the skills you want.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Capgemini
Program Manager
United Arab Emirates, UAE
Capgemini is seeking a Program Manager to lead overall program delivery across discovery, design, build, migration, testing, go-live, and support transition. The role involves managing project governance, stakeholder coo
Investment Data Architect
Dubai, UAE
Capgemini seeks an Investment Data Architect to implement and configure BlackRock Aladdin and eFront platforms for investment management clients. The role involves platform implementation, testing, data migration, and st
System Integration Engineer
Dubai, UAE
Capgemini is seeking a System Integration Engineer to join their Global Insights & Data business line. You will analyze source-system integration requirements, build integrations into Snowflake, and support data ingestio
System Integration Engineer
, UAE
Capgemini seeks a System Integration Engineer to analyze source-system integration requirements and define data ingestion patterns into Snowflake. Responsibilities include building integrations from various systems, desi
Sr. Backend Distributed Systems Engineer
Toronto, CAN
Capgemini is seeking a Senior Software Engineer to work on one of the world's largest social media platforms, handling petabytes of data daily. You will design and implement distributed systems solutions using cutting-ed
Sr. Backend Distributed Systems Engineer
Toronto, CAN
Capgemini is seeking a Senior Software Engineer to work on one of the world's largest social media platforms, handling petabytes of data daily. You will design and implement distributed systems solutions using cutting-ed
Investment Data Architect
Dubai, UAE
Capgemini seeks an Investment Data Architect with hands-on experience in BlackRock Aladdin and/or eFront platforms. You will lead platform implementation, configuration, testing, and data integration for investment manag
System Integration Engineer
Dubai, UAE
Capgemini seeks a System Integration Engineer with 5+ years of experience to analyze source-system integration requirements and build data ingestion patterns into Snowflake. The role involves designing ingestion workflow
Program Manager
United Arab Emirates, UAE
Investment Data Architect
Dubai, UAE
System Integration Engineer
Dubai, UAE
System Integration Engineer
, UAE
Sr. Backend Distributed Systems Engineer
Toronto, CAN
Sr. Backend Distributed Systems Engineer
Toronto, CAN
Investment Data Architect
Dubai, UAE
System Integration Engineer
Dubai, UAE