Data Engineer

About Capgemini

Capgemini is a diverse collective of more than 350,000 strategic and technological experts based across more than 50 countries, partnering with world-renowned clients to transform and manage their businesses. We are dedicated to leveraging cloud, data, AI, connectivity, software, digital engineering, and platforms to address the entire breadth of their business needs. This passion drives a powerful commitment - to unlock the true value of technology. Over the last 18 months, we have tripled our business in Australia and New Zealand, with over 3,500 team members devoted to helping clients get the future they want.
- Now is the time to join our rapidly growing team who are at the forefront of finding new ways technology can help us reimagine what’s possible, collecting unique career experiences with global brands and game-changing tech projects._

Let’s talk about the team:
Our Insights and Data team helps our clients make better business decisions by transforming an ocean of data into streams of insight. Our clients are among Australia's top performing companies, and they choose to partner with Capgemini for a very good reason - our exceptional people. Due to continued growth within Capgemini's Insights & Data practice we intend to recruit a Senior Data Engineer with relevant consulting and communication skills. If you are already working in a consultancy role, or have excellent client-facing skills gained within large organizations, we would like to discuss our consultant opportunities with you.

This is a full time, permanent position to be based either at our Auckland or Wellington, New Zealand office.

Let’s talk about your role:
As a Senior Data Engineer with at least 4-5 years’ experience in data warehousing, you will be working both independently and alongside other team members in a small development squad.

You will be technically proficient with a strong background in data engineering and have demonstratable experience on Microsoft data technologies. This will include a modern approach to building cloud-based data lakes, data warehouses and data marts in Azure.

You will have worked as part of a development team and have a good working knowledge of agile software delivery concepts including product backlogs, sprints/iterations, Kanban boards and delivering a mínimal viable product (MVP).

Lets talk about your responsibilities:

- Responsible for the design, build and oversight of projects to ensure they are successful
- Provide oversight and support for junior team members in their day-to-day project responsibilities
- Build robust, efficient and reliable data platforms for our clients
- Collaborate with architects and other technology SME's to define the architecture and technology selection
- Share knowledge and best practices with peers that promote better technical practices across the organisation

Let’s talk about your capability and experience:
Technical skills:

- Microsoft Data Platform (SQL Server, SSIS, SSAS, SSRS)
- Strong SQL development skills
- Good working knowledge of core database concepts and SQL Server
- Microsoft Azure cloud data platform
- Azure SQL
- Azure DW / Synapse Analytics
- Azure Data Lake
- Strong knowledge of data warehousing techniques and data modelling skills using one of the well-known methodologies such as:

- Kimball
- Inmon
- Data Vault
- Strong ETL and data pipeline development skills
- Azure Data Factory
- Azure Functions using either C# or Python
- Knowledge of Power BI including DAX and Power Query
- Data Ops
- Infrastructure as code (IAC)
- Monitoring and alerting
- Testing and test automation

Non-technical skills:

- Design and architecture documentation
- Can produce and contribute to technical design documentation
- Can follow design specifications
- Can produce as built and other development documentation, including how-to guides, wikis and technical specifications
- Familiar with online documentation and wiki tools, such as Confluence, MS Teams, etc

Advantageous:

- Microsoft Azure cloud platform
- Knowledge of other Azure cloud concepts such as infrastructure and networking
- Working knowledge of other Synapse Analytics components, like
- Spark Pools
- Delta Lake
- Serverless SQL Pools
- Synapse Pipelines
- Continuous integration / continuous deployment (CI/CD) experience
- Data security and security models
- Familiar with agile delivery tools such as Azure DevOps for backlog and task management (or an equivalent platform such as JIRA)

Let's talk about what's in it for you
- We believe technology is about more than business transformation - it’s also about building a more sustainable, inclusive future. This starts with our people, working with you to get the future you want. We invite everyone to bring their whole selves to work, contributing to our inclusive culture and a safe place for our people to be themselves and truly belong. Through championing our staff-led community groups, we are committed to being active