About Capgemini

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2024 global revenues of €22.1 billion.

Job Description

As a Lead Data Engineer,, you are a core member of the team responsible for providing digital solutions to data challenges through implementation of Azure native data solutions to support use cases.

This role will be responsible for developing, optimizing, and standardizing data pipelines, creating robust data models for data publishing while complying with, and adding value to, the data architecture. You will need a blend of superb problem-solving and innovation skills to resolve a wide variety of technical challenges. Perform data profiling, data model design, data formatting, and ETL development optimized for efficient storage, access, and computation to serve various use cases.

• Developing, and successfully operationalizing complex/large scale data management projects
• Understanding existing data model and how the data is used within client organization.
• Perform data profiling to discover how to design and harmonise To-Be data model for data migration purposes.
• Design and develop ETL / ELT framework for a configuration-based approach to ingest, cleanse, transform and load data. The framework will be using Azure native services like ADLS, Azure synapse analytics, Azure SQL DB, Azure EventGrid, Azure Logic apps, Azure Functions, Azure Analysis Service, Databricks etc.
• Adopt a DevOps approach towards implementing job orchestration, CICD pipelines, audit trail, dynamic parameter passing, and error/exception handling.
• Write and execute test plans, test cases, and testing ELT/ETL code and data model integrity.
• Collaborates with downstream consumers, understand their requirement of data engineering and do implementation
• Contribute to project related documentation such as technical specifications.
• Participate actively in all activities throughout the project lifecycle.
• Proactively identify development and technical risks, propose mitigation plans and flag to the team accordingly.
• Promptly assist in the resolution of bugs identified.

Job Requirements

• Minimum 5-6 years of experience in ETL/ELT framework development, and certified preferably in Azure Data Engineering.
• Experience in interfacing with cloud DevOps design patterns within Public Sector.
• Past experience of working in Singapore Public Sector with relevant clearances will be advantageous.
• The following additional certificates will be an added advantage: Azure Solutions Architect Expert, AWS Certified Data Engineer, Salesforce Platform Developer II, Salesforce Consultant Certificates.
• Knowledge or understanding of project lifecycle.
• Knowledge or working experience in public sector is preferred.
• Experience with CI/CD tools, release management and integration preferred.
• Eagerness to learn and adapt to new technologies.
• Excellent verbal and written skills.

Let's talk about what's in it for you!

Passionate people are Capgemini's Ace of Spades - join us to discover a career that will challenge, support and inspire you. Working at Capgemini you'll find the rewards are more than just financial. You will work alongside some very smart and inspiring people on exciting projects and you will also enjoy incredible benefits. We offer flexible work practices and 40 hours of self-development every year with a huge selection of learning opportunities to choose from.

As "Architects of Positive Futures", Capgemini actively supports the community in 3 ways:

Diversity and Inclusion - we believe diversity of thought fuels excellence and innovation, which is why we positively encourage applications from suitably qualified candidates regardless of their gender identity, ethnicity, sexual orientation, religion, ability, intersex status or age. To support our commitment to diversity and inclusion, we celebrate special events and days of significance that are important to our employees such as Diwali, Bastille Day, Pride, IDAHOBIT, IWD and International day of people with Disabilities. Our Employee Resource Groups Women@Capgemini and OutFront support the grassroots passion of employees to drive our diversity agenda and effect change.

Digital inclusion - at Capgemini we are using our skills to drive social impact initiatives focusing on helping society address the impact of the digital and automation revolution. We also provide employees with opportunities to give back to the community through charity projects and volunteer days.

Environmental Sustainability - Capgemini joined the CDP's (Carbon Disclosure Project) prestigious "A list" for its commitment to the Net-Zero economy. We are focusing on helping our clients transform towards more sustainable business models and committing to reduce our own carbon emissions (GHG) by 20% per employee by 2020.

Recognized by Ethisphere as one of the World's Most Ethical Companies for the last 8 years in a row, ethics and values are at the heart of Capgemini's corporate culture and business. Embedded in our DNA, our seven values - Honesty, Boldness, Trust, Team Spirit, Freedom, Fun and Modesty - have remained the same since company inception in 1967. To see how we bring these values to life, click here to listen to some of our employee’s stories.

Come join us, bring your whole self to work, create new possibilities for you, your customers and your community and help us to be Architects of Positive Futures.