Snowflake Data Engineer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Capgemini is looking for a Snowflake Data Engineer to build data pipelines, models, and transformations for investment and financial data. The role requires 4+ years of data engineering experience with strong Snowflake and SQL skills, preferably in financial services.
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
- 4+ years of data engineering experience, with strong hands on experience in Snowflake
- Experience building data pipelines, ELT processes, data models, and analytical data layers
- Strong SQL skills and experience with complex transformations
- Experience working with investment, financial services, accounting, portfolio, or market data is preferred
- Experience with historical data migration, backfill, reconciliation, and data quality validation
- Experience with ETL/ELT tools, orchestration, cloud storage, APIs, and BI/reporting consumption layers
- Familiarity with data governance, lineage, access control, and sensitive financial data
Full Job Posting
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.
Your Role
- 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.
Your Profile
- 4+ years of data engineering experience, with strong hands on experience in Snowflake.
- Experience building data pipelines, ELT processes, data models, and analytical data layers.
- Strong SQL skills and experience with complex transformations.
- Experience working with investment, financial services, accounting, portfolio, or market data is preferred.
- Experience with historical data migration, backfill, reconciliation, and data quality validation.
- Experience with ETL/ELT tools, orchestration, cloud storage, APIs, and BI/reporting consumption layers.
- Familiarity with data governance, lineage, access control, and sensitive financial data.
Skills
- Snowflake development
- Advanced SQL
- Data modelling and transformation
- Data quality engineering
- Historical data backfill
- Performance tuning
- Investment data awareness
- Documentation and testing discipline
Technical
- Snowflake
- Cloud data platform
- ETL/ELT
- Data integration
- Governance
- Reconciliation
- BI/reporting consumption
About Capgemini
- Capgemini is an AI powered global business and technology transformation partner, delivering tangible business value.
- We imagine the future of organisations and make it real with AI, technology and people.
- With our strong heritage of nearly 60 years, we are a responsible and diverse group of over 420,000 team members in more than 50 countries.
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
Analyste d'affaires et fonctionnel PLM 3DEXPERIENCE/PLM 3DExperience Business & Functional Analyst
Montréal, CAN
Capgemini Engineering seeks a PLM Functional Analyst to design, implement, and optimize PLM solutions (3DExperience, Teamcenter, Windchill) for clients in Montreal. You will gather business needs, map processes, and cond
Analyste d'affaires et fonctionnel PLM 3DEXPERIENCE/PLM 3DExperience Business & Functional Analyst
Montréal, CAN
Capgemini Engineering seeks a PLM Functional Analyst for a hybrid role in Montreal, QC. You will design, implement, and optimize PLM solutions (3DEXPERIENCE preferred) for clients, gathering requirements, mapping process
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
Snowflake Data Engineer
United Arab Emirates, UAE
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...
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
Investment Data Architect
Dubai, UAE
Capgemini is seeking an Investment Data Architect to support end-to-end implementations of BlackRock Aladdin and eFront platforms. The role involves configuration, testing, data integration, and stakeholder management. C
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
Analyste d'affaires et fonctionnel PLM 3DEXPERIENCE/PLM 3DExperience Business & Functional Analyst
Montréal, CAN
Analyste d'affaires et fonctionnel PLM 3DEXPERIENCE/PLM 3DExperience Business & Functional Analyst
Montréal, CAN
Program Manager
United Arab Emirates, UAE
Snowflake Data Engineer
United Arab Emirates, UAE
Investment Data Architect
Dubai, UAE
System Integration Engineer
Dubai, UAE
Investment Data Architect
Dubai, UAE
Sr. Backend Distributed Systems Engineer
Toronto, CAN