Senior Software Engineer - Snowflake Engineer

About the job you’re considering

The successful candidate will design, build, and maintain a robust and scalable data infrastructure to support business intelligence, analytics, and data science initiatives. The responsibility includes managing the end-to-end data lifecycle, including data ingestion, transformation, storage, and accessibility for various stakeholders.
  

Your role

• Design, develop, and maintain efficient and scalable data pipelines to extract, transform, and load data from various sources.
• Build and maintain data models within the Enterprise Data Warehouse, ensuring data is organized and accessible for analysis and reporting.
• Gather business reporting requirements and translate them into technical specifications for data solutions.
• Develop and implement ETL/ELT solutions to support data integration needs.
• Integrate data from external partner applications and other internal systems.
• Develop and support dashboards, analytics, and reports using Power BI.
• Perform integration testing to ensure data quality and system functionality.
• Design and implement data security measures and access controls.
• Collaborate with cross-functional teams to ensure data solutions meet business needs.
• Ensure data integrity and accuracy across the EDW solution and source systems.
• Provide support for production data environments and troubleshoot data-related issues.
• Participate in cutover planning and execution for new data solutions.
• Stay up-to-date with industry trends and emerging technologies in data engineering.

Your skills and experience

• A minimum of 10+ years of proven experience in Data Engineering is required, including designing, developing, and supporting complex data environments.
• Experience in designing, implementing, and optimizing enterprise data warehouses (EDWs) is required.
• Expertise in data modeling and schema design (e.g., relational, dimensional) is required to ensure efficient data storage and retrieval.
• Snowflake: Hands-on experience with Snowflake data warehousing, including optimization techniques, is required.
• A deep understanding and experience with ETL/ELT processes and tools are required.
• A strong understanding of data modeling principles and best practices is required.
• Data Quality and Governance: Experience implementing data quality checks and validation processes is required.
• Ensuring data security and access controls are implemented and maintained is required.
• Data Security: Experience implementing industry-standard data security measures, including encryption and access controls, is required.
• Testing and Validation: Experience in designing and executing integration testing for data pipelines and EDW is required.

Life at Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

• Flexible work
• Healthcare including dental, v