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.
Responsibilities
•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 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
Requirements
•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
Conditions
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, Capgemini has trained 'Mental Health Champions' across each of its business areas, and has invested in wellbeing apps such as Thrive and Peppy. You will be empowered to explore, innovate, and progress, benefiting from Capgemini's 'learning for life' mindset, with training and development opportunities from thinktanks to hackathons, and access to 250,000 courses with numerous external certifications from AWS, Microsoft, Harvard ManageMentor, Cybersecurity qualifications and more.
