Snowflake Data Engineer

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 financial services, consumer products, manufacturing & life sciences). Our offerings include end-2-end data integration to cloud platform, complete suite of AI engineering capabilities and a category of sector-based advanced analytics / AI solutions.

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

Why you should consider Capgemini:

Growing clients’ businesses while building a more sustainable, more inclusive future is a tough ask. When you join Capgemini, you’ll join a thriving company and become part of a collective of free-thinkers, entrepreneurs and industry experts. We find new ways technology can help us reimagine what’s possible. It’s why, together, we seek out opportunities that will transform the world’s leading businesses, and it’s how you’ll gain the experiences and connections you need to shape your future. By learning from each other every day, sharing knowledge, and always pushing yourself to do better, you’ll build the skills you want. You’ll use your skills to help our clients leverage technology to innovate and grow their business. So, it might not always be easy, but making the world a better place rarely is.

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. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2025 global revenues of €22.5 billion. Make it real | www.capgemini.com