Data Engineer (Mid/Senior)

<p><strong>This is Us</strong></p><p>Ingenious Lion is a Digital Tech Hub designed exclusively for Publicis Groupe, one of the world’s leading marketing agencies.</p><p>As the marketing industry continues to drive digital transformation, Publicis Groupe empowers its clients with innovative data solutions and media ecosystems. Ingenious Lion has one mission: to partner with Publicis’ global teams in creating innovative data and digital tech products that will shape the future.</p><p>What makes us successful? Two key ingredients: we pursue excellence and strive for the best, meaning we nurture a thriving company culture. We focus on creating an environment where people don’t just work; they grow, challenge themselves, strive for excellence, and are recognized for their incredible value to the team.</p><p>If you're curious to learn more about us, here are four things you should know:</p><ul> <li>Our company culture is anchored in five powerful values: Joy, Honesty, Connectivity, Own Challenger, and Greater World. Do these values resonate with you?</li> <li>We are committed to diversity and inclusion because we believe our unique differences make us stronger.</li> <li>We encourage open communication and create an environment where everyone’s voice is heard and every contribution is valued.</li> <li>Finally, we’re somewhat “obsessed” with quality. We believe in continuous learning and knowledge sharing; when we hit a roadblock, we don’t just complain—we create solutions to overcome it.</li> </ul><p>In one sentence, we are a group of people with an unusual aptitude for generating great ideas, groundbreaking concepts, and infusing them with positive energy and good fun.</p><p>Feeling Ingenious already?</p><p><strong><strong>A Sneak Peek at Your Future Role</strong></strong></p><p>As a Data Engineer, your mission is to design, build, and optimise data solutions that <br/>support the transition towards a modern Lakehouse architecture. You’ll work on <br/>creating efficient data workflows, ensuring that information is reliable, structured, and <br/>ready to power decision-making across the organisation.</p><p> This role focuses on enabling seamless data movement and transformation, combining <br/>the flexibility of a data lake with the performance of a data warehouse. You’ll play a key <br/>part in shaping the platform, strengthening data foundations, and unlocking advanced <br/>analytics opportunities.</p><p> You’ll take ownership of data solutions end-to-end, from modelling and transformation <br/>to workflow automation, to ensuring performance and quality. Collaborating with an <br/>international team, you’ll align technical delivery with business priorities, while <br/>promoting best practices in scalability, governance, and reliability.<strong></strong></p><p><strong><strong>Here Are the Key Tasks You'll Be Working on Every Day</strong></strong></p><ul> <li>Design, build, and optimise data workflows that support large-scale migrations and transformations, ensuring accuracy, reliability, and performance across different environments.</li> <li>Develop and maintain processes that orchestrate end-to-end data operations, enabling efficient movement and integration of datasets for analytical and operational purposes.</li> <li>Contribute to the evolution of a modern data platform that combines the scalability of a data lake with the structure and governance of a data warehouse, supporting the Lakehouse architecture.</li> <li>Collaborate with colleagues in an agile setting, aligning technical delivery with business priorities and ensuring solutions are fit for purpose.</li> <li>Take ownership of monitoring, troubleshooting, and improving data workflows, continuously enhancing processes for efficiency, scalability, and resilience.<strong><strong></strong></strong></li> </ul><p><strong><strong><strong>We're Thrilled to Have You Consider Joining Our Team. Here Are the Qualifications We're Seeking</strong></strong></strong></p><ul> <li>At least three years of experience with Databases and creating scalable data pipelines.</li> <li>Experience designing and maintaining scalable data pipelines with Databricks, also notebooks and jobs to support ETL processes.</li> <li>Proficiency with SQL, Python (with PySpark), and Databricks.</li> <li>Working experience with AWS Redshift, including proficiency with Redshift SQL.</li> <li>Strong understanding of modern data architectures, particularly the Delta Lakehouse model. </li> <li>Knowledge of data warehouse and data lake concepts, with practical experience in preparing and managing data tables.</li> <li>Strong communication skills in English, both written and spoken.</li> </ul><p><strong><strong><strong>Skills That Would Make You Shine Even Brighter!</strong></strong></strong></p><ul> <li>You are familiar with Terraform, including workflow automation and configuration (YAML-based).</li> <li>You know infrastructure-as-code concepts and structured workflow management.</li> <li>You have