Senior Data Analyst: Snowflake & ETL Expert (Hybrid)

Capgemini; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Job summary

Capgemini in London is seeking a Sr Data Analyst to design, develop and maintain enterprise-scale data warehouse solutions using Snowflake. You will build and optimize ETL/ELT pipelines, manage Snowflake databases and implement data modelling techniques in a hybrid setup with access to office, client sites and home working.

You will work with cloud platforms (AWS/Azure/GCP), collaborate with stakeholders, and ensure data quality, security and governance through Snowflake features and modern

Qualifications

• Hands-on experience with Snowflake Data Warehouse.
• Strong proficiency in SQL and database concepts.
• Experience in ETLELT development and data integration.
• Knowledge of Snowflake Tasks, Streams, Snow Pipe 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 including Star Schema and Snowflake Schema.
• 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

Snowflake Tasks/Streams/Time Travel

Cloud platforms (AWS/Azure/GCP)

Data warehousing concepts

Python/Shell scripting/Java

Git & CI/CD

Tools

Informatica

Matillion

Talend

DBT

Azure Data Factory

Job description

Capgemini in London is seeking a Sr Data Analyst to design, develop and maintain enterprise-scale data warehouse solutions using Snowflake. You will build and optimize ETL/ELT pipelines, manage Snowflake databases and implement data modelling techniques in a hybrid setup with access to office, client sites and home working.

You will work with cloud platforms (AWS/Azure/GCP), collaborate with stakeholders, and ensure data quality, security and governance through Snowflake features and modern