Senior Data Analyst - Snowflake & Cloud DW (Hybrid)

Capgemini; Greater London; Híbrido; GBP 60.000 - 90.000; Jornada completa

Descripción de la vacante

Capgemini in London is seeking a Sr Data Analyst to design, develop and optimize data warehouse solutions using Snowflake. You will build and enhance ETL/ELT pipelines, implement star and snowflake schemas, and integrate Snowflake with leading ETL tools across a multi-cloud environment.

You will partner with architects, analytics teams and stakeholders to deliver scalable data platforms, ensure data security and governance, and drive automation with Python, SQL and CI/CD practices.

Formación

• Hands-on Snowflake data warehouse experience.
• Strong SQL/database concepts.
• ETL/ELT development experience.
• Knowledge of Snowflake Tasks/Streams/Time Travel.
• Experience with cloud platforms (AWS/Azure/GCP).
• Familiarity with Python/Shell/Java for automation.
• Git and CI/CD knowledge.

Responsabilidades

• Design, develop and maintain data warehouse solutions using Snowflake.
• Develop and optimize ETL/ELT pipelines for data ingestion and transformation.
• Create and manage Snowflake databases, schemas, tables, views, tasks and streams.
• Implement data modelling techniques including Star and Snowflake schemas.
• Optimize queries, warehouse performance and storage utilization.
• Integrate Snowflake with ETL tools (Informatica, Matillion, Talend, DBT, 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.

Conocimientos

Snowflake

SQL

ETL/ELT

Data modelling

Python

Shell scripting

Java

Git

CI/CD

Cloud platforms

Data warehousing

Herramientas

Informatica

Matillion

Talend

DBT

Azure Data Factory

Descripción del empleo

Capgemini in London is seeking a Sr Data Analyst to design, develop and optimize data warehouse solutions using Snowflake. You will build and enhance ETL/ELT pipelines, implement star and snowflake schemas, and integrate Snowflake with leading ETL tools across a multi-cloud environment.

You will partner with architects, analytics teams and stakeholders to deliver scalable data platforms, ensure data security and governance, and drive automation with Python, SQL and CI/CD practices.