Data analyst

Capgemini; Greater London; Hybrid; GBP 90,000 - 120,000; Full time

Benefits offered by this job

Training opportunities

Wellbeing program

Job summary

Capgemini ищет архитектора данных с фокусом на Snowflake и облачные решения. Вы будете проектировать и развивать архитектуру данных, внедрять конвейеры ETL/ELT и сотрудничать с бизнес-стейкхолдерами по всему Enterprise.

Требуется практический опыт Snowflake, SQL, и интеграции с инструментами ETL в многооблачной среде. Работа предполагает гибридный режим, офисы Capgemini, клиентские площадки и удалённую часть в разумных рамках.

Qualifications

• Опыт работы с Snowflake Data Warehouse
• Опыт разработки ETL/ELT и интеграции данных
• Знание SQL и базовых концепций баз данных
• Знакомство с Snowflake Tasks, Streams, Snowpipe, Time Travel
• Опыт работы с облачными платформами AWS/Azure/GCP
• Навыки автоматизации на Python, Shell script или Java
• Знание Git и процессов CI/CD

Responsibilities

• Проектирование и поддержка решения хранения данных на Snowflake
• Разработка и оптимизация ETL/ELT конвейеров
• Создание баз данных, схем, таблиц, представлений, заданий и потоков в Snowflake
• Моделирование данных: Star/Tower Snowflake схемы
• Оптимизация запросов и использование пространства
• Интеграция Snowflake с инструментами ETL (Informatica, Matillion, Talend, DBT, ADF)
• Разработка процессов контроля качества данных и мониторинга
• Обеспечение безопасности данных, политики управления и соответствия
• Сотрудничество с бизнес-стейкхолдерами, архитекторами и аналитиками

Skills

SQL

Data Warehousing

ETL/ELT development

Data modeling

Cloud platforms

Automation

Git & CI/CD

Tools

Snowflake

Informatica

Matillion

Talend

DBT

Azure Data Factory

Python

Shell scripting

Java

Job description

Описание: Join a high-impact architecture role where you'll drive enterprise-scale cloud, data, and AI initiatives. Work with modern technologies including GenAI, LLMs, microservices, and multi-cloud platforms while influencing architecture strategy, engineering excellence, and innovation across the organization.

Задачи:

• 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 stakeholder’s architects and analytics teams to deliver data solutions

Требования:

• Handson 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 conceptsExperience with Python Shell Scripting or Java for automation
• Knowledge of Git and CICD processes

Условия:

The places that you work from day to day will vary according to your role, your needs, and those of the business; it will be a blend of Company offices, client sites, and your home; noting that you will be unable to work at home 100% of the time. You’d be joining an accredited Great Place to work for Wellbeing in 2024. To help support wellbeing we have trained ‘Mental Health Champions’ across each of our business areas, and we have invested in wellbeing apps such as Thrive and Peppy. You will be empowered to explore, innovate, and progress. You will benefit from Capgemini’s ‘learning for life’ mindset, meaning you will have countless training and development opportunities from thinktanks to hackathons, and access to 250,000 courses with numerous external certifications from AWS, Microsoft, Harvard Manage Mentor, Cybersecurity qualifications and much more.