Senior Data Engineer

At Kantar XTEL, we understand large FMCG players like nobody else. We are a leading software provider of sales automation solutions for the Consumer Goods Industry worldwide.

Our mission is to partner with our customers to unlock growth through smart investment and ensure that they take the right steps to drive more sales, optimising their promotional plans.

To continue making data accessible and help our clients make strategic business decisions, we are seeking an experienced Data Engineer with strong business-oriented mindset, good command of ETL tools, and a true passion for Technology.

As a Data Engineer, sitting within the Product team and reporting to the CTO, you will be the point of reference for the client (Product Owners) and the project team on analytics, data practices, and harmonisation.

You will have the creativity to build a rich Data Visualization layer to the Analytics solution and to ensure a solid and scalable architecture of the solution.

You will use data to provide visibility on key metrics, performance, and business opportunities to global FMCG companies.

Are we a phenomenal fit? We are looking for someone who…..

• Is Optimistic – whether it’s sorting out a knotty problem or calming a stressed-out collaborator, can you look on the forward-thinking side?

• Is Original – we love to hear ideas on how we can be doing things differently so that we can all be more engaged and successful with our clients.

• Makes and takes Opportunities – are you the kind of person who will step up and volunteer to take something on, even if it’s outside of your comfort zone?

• Takes Ownership – for the team! You use your strengths to help us grow together.

• Has an Open Mind – we favor constructive feedback given in a kind way and appreciate the same in return.

Our Senior Data Engineer will:

• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Design, maintain and improve optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure technologies
• Identify, design, and implement ETL/ELT process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for scalability and stability
• Define and ensure the Analytics architecture meets all requirements of quality, security, modifiability, extensibility, etc. Approving final product before launch.
• Develop and document ETL/ELT policies and procedures, standards, and metrics to support customer analytics business rules.
• Provide technical guidance and coaching to developers and engineers
• Establish data quality processes and compliance with data standards for data domains.
• Troubleshoot issues with data quality as identified by customers.
• Understand critical data relationships and customer data domains.
• Collaborate with Product Owners, data producers, and data consumers to get an understanding of current processes and systems that has a direct impact on the quality of the enterprise data.
• Work with Software Architects to define and maintain a customer data model and Analytics solutions.
• Being responsible for the troubleshooting activities in case of performance and production problems related to the Analytics solution.
• Exhibit Agile leadership: exhibit the behaviours of an Agile Leader with an Agile Mindset. Helps the team embrace Agile Values, adopt, and apply Agile Principles, and implement Agile practices.

A great candidate will have:

• Bachelor's or Master's degree in Statistics, Computer Science, Engineering, Mathematics
• Good experience with complex Analytics architecture and infrastructure.
• Experience with physical and relational data modelling
• Advanced SQL knowledge and experience in working with relational databases
• Strong understanding of Azure ETL and Data Storage technologies (e.g., Data Lakes, Data Bricks, Azure Synapse Analytics, Azure Data Factory)
• Accustomed to working with distributed version control systems (GIT, DevOps)
• Data Viz oriented, and acquainted with latest data visualization tools (Power BI, Tableau…)
• Good knowledge of the CI/CD principles and implementation
• Strong written and verbal communication skills
• Detail oriented and able to prioritise tasks with strong analytical skills.
• Fluent in English with sound Business English knowledge
• Create and manage data using a lakehouse
• Design pipelines to copy data into your lakehouse
• Use Spark job definitions to submit batch/streaming job to Spark cluster
• Use notebooks to write code for data ingestion, preparation, and transformation
• (Considered a plus) experience MS Fabric and OneLake

What will you get:

· Challenging position in a fast-growing AI-driven revenue management company.

· Being a part of a diverse and international team with a strong ownership and can-do mentality.

· The opportunity to meaningfully contribute to the continued growth and development of the organization.

· A cross-functional role that spans across geographies and departments in the company.

· Flexible working with possibility of hybrid work (the company HQ is based in Bologna).

· We as a team have a passion for learning and growing to be the best version of ourselves.

Do you have strengths you can share? If so, we’d love to hear from you. We appreciate that everyone has different backgrounds and experience, so if you don’t meet all the criteria above, please don’t be deterred from applying. We could be just what you are looking for!

Please note that this job description provides a general overview of the responsibilities and qualifications required. It is not an exhaustive list, but we believe it captures the essence of this exciting role.

Kantar XTEL is an equal opportunity employer and values diversity. All applicants will be considered for employment without attention to race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.