Data Engineer (Mid/Senior) Lisboa

This is Us

Ingenious Lion is a Digital Tech Hub designed exclusively for Publicis Groupe, one of the world’s leading marketing agencies.

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.

What makes us successful? Two key ingredients: we pursue excellence and aim for the best, which means we cultivate 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 immense value to the team.

If you're curious to learn more about us, here are four things you should know:

• Our company culture is anchored in five powerful values: Joy, Honesty, Connectivity, Own Challenger, and Greater World. Do these values resonate with you?
• We are committed to diversity and inclusion because we believe our unique differences make us stronger.
• We encourage open communication and create an environment where everyone’s voice is heard and every contribution is valued.
• 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.

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.

Feeling Ingenious already?

A Sneak Peek at Your Future Role

As a Data Engineer, your mission is to design, build, and optimise data solutions thatsupport the transition towards a modern Lakehouse architecture. You’ll work oncreating efficient data workflows, ensuring that information is reliable, structured, andready to power
- making across the organisation.

This role focuses on enabling seamless data movement and transformation, combiningthe flexibility of a data lake with the performance of a data warehouse. You’ll play a keypart in shaping the platform, strengthening data foundations, and unlocking advancedanalytics opportunities.

You’ll take ownership of data solutions
-
- end, from modelling and transformationto workflow automation, to ensuring performance and quality. Collaborating with aninternational team, you’ll align technical delivery with business priorities, whilepromoting best practices in scalability, governance, and reliability.

Here Are the Key Tasks You'll Be Working on Every Day

• Design, build, and optimise data workflows that support
  - scale migrationsand transformations, ensuring accuracy, reliability, and performance acrossdifferent environments.
• Develop and maintain processes that orchestrate
  -
  - end data operations, enabling efficient movement and integration of datasets for analytical andoperational purposes.
• Contribute to the evolution of a modern data platform that combines thescalability of a data lake with the structure and governance of a data warehouse, supporting the Lakehouse architecture.
• Collaborate with colleagues in an agile setting, aligning technical delivery withbusiness priorities and ensuring solutions are fit for purpose.
• Take ownership of monitoring, troubleshooting, and improving data workflows, continuously enhancing processes for efficiency, scalability, and resilience.

We're Thrilled to Have You Consider Joining Our Team. Here Are the Qualifications We're Seeking

• At least three years of experience with Databases and creating scalable datapipelines.
• Experience designing and maintaining scalable data pipelines with Databricks, also notebooks and jobs to support ETL processes.
• Proficiency with SQL, Python (with Py
  Spark), and Databricks.
• Working experience with AWS Redshift, including proficiency with Redshift SQL.
• Strong understanding of modern data architectures, particularly the Delta
  Lakehouse model.
• Knowledge of data warehouse and data lake concepts, with practical experience inpreparing and managing data tables.
• Strong communication skills in English, both written and spoken.

Skills That Would Make You Shine Even Brighter!

• You are familiar with Terraform, including workflow automation andconfiguration (YAML-based).
• You know
  -
  - code concepts and structuredworkflow management.
• You have previous involvement with Airflow and Dagster.