Senior Data Architect — Snowflake, Cloud & AI Solutions

Capgemini; England; Hybrid; GBP 70,000 - 110,000; Full time

Benefits offered by this job

Disability Confident Employer

Great Place to Work for Wellbeing

Job summary

Capgemini UK is seeking an architecture-led role to drive enterprise-scale cloud, data, and AI initiatives using GenAI, LLMs, microservices and multi-cloud platforms. You will influence architecture strategy, engineering excellence, and innovation across the organization, with a blend of Capgemini offices, client sites, and home-based work.

You will design, develop and maintain Snowflake-based data warehouses, build ETL/ELT pipelines, and collaborate with stakeholders to deliver scalable data

Qualifications

• Hands-on experience with Snowflake Data Warehouse.
• Strong proficiency in SQL and database concepts.
• Experience in ETL/ELT development and data integration.
• Knowledge of Snowflake Tasks, Streams, Snowpipe and Time Travel.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Good understanding of data warehousing and data modelling concepts.
• Experience with Python, Shell scripting, or Java for automation.
• Knowledge of Git and CI/CD processes.

Responsibilities

• Design, develop and maintain data warehouse solutions using Snowflake.
• Develop and optimize ETLELT pipelines for data ingestion and transformation.
• Create and manage Snowflake databases, schemas, tables, views, tasks and streams.
• Implement data modelling techniques like Star and Snowflake schemas.
• Optimize queries, warehouse performance and storage utilization.
• Integrate Snowflake with ETL tools such as Informatica, Matillion, Talend, DBT or Azure Data Factory.
• Develop data quality validation and monitoring processes.
• Ensure data security, governance and compliance using Snowflake features.
• Collaborate with business stakeholders, architects and analytics teams to deliver data solutions.

Skills

Snowflake Data Warehouse

SQL

ETL/ELT development

Snowflake features

Cloud platforms

Data Warehousing concepts

Automation scripting

Git / CI–CD

Tools

Informatica

Matillion

Talend

DBT

Azure Data Factory

Job description

Capgemini UK is seeking an architecture-led role to drive enterprise-scale cloud, data, and AI initiatives using GenAI, LLMs, microservices and multi-cloud platforms. You will influence architecture strategy, engineering excellence, and innovation across the organization, with a blend of Capgemini offices, client sites, and home-based work.

You will design, develop and maintain Snowflake-based data warehouses, build ETL/ELT pipelines, and collaborate with stakeholders to deliver scalable data