BI Backend Developer

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 seek the good and the best, meaning we cultivate a thriving company culture. We’re committed to creating an environment where people don’t just work; they grow, challenge themselves, strive for excellence, and are recognized for their invaluable contributions 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 BI Backend Developer, your mission is to support the development of BI backend solutions by helping design and implement scalable, efficient systems that integrate data and maintain its integrity.

In this role, you’ll collaborate with developers and cross-functional teams to implement guidelines and workflows that enhance the performance and reliability of our BI systems.

Your efforts will directly impact the performance, reliability, and scalability, ensuring they meet the evolving needs of the business. You'll be part of a team where continuous improvement and collaboration are key to delivering impactful, high-quality BI solutions.

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

• Interpreting and delivering business-oriented tickets related to data pipelines, including the creation, adjustment, and restructuring of data fields and tables.
• Managing and executing data operations, from column updates to complex movements across internal and external systems.
• Designing and maintaining data processes to ensure accurate data flow, supporting ongoing reporting requirements.
• Collaborating with data analysts and cross-functional teams to understand context, validate data outcomes, and ensure alignment between technical delivery and business expectations.
• Contributing to the quality and consistency of data operations by handling tasks of varying complexity, with increasing autonomy and ownership.

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

• At least three years of professional hands-on experience developing data warehouse or data lake solutions, with a strong understanding of data modeling principles.
• Proficiency in Python and building reliable ETL/ELT pipelines to support business-driven data flows.
• Experience with SQL, including query building, optimization, and database management.
• Proficiency with Azure services such as Data Factory, Blob Storage, and Key Vault, and the ability to use them in real-world data scenarios.
• Solid experience with Databricks, handling workflows, and managing data pipelines.
• Understanding of data architecture concepts, including dimensional modeling and versioned data handling (e.g., SCD).
• Familiarity with Gitflow processes for CI/CD, contributing to pipeline development, and branch management.
• Fluent in English, both verbal and written.

Skills That Would Make You Shine Even Brighter!

• You know Microsoft Power Platform, Power Query, and Excel.
• You are familiar with the media/advertising industry.