Power BI Expert (Advanced DAX) with French

Descrizione del lavoro:

Job Description:
We Dream. We Do. We Deliver.

Merkle, a dentsu company, powers the experience economy. For more than 35 years, the company has put people at the heart of its approach to digital business transformation. As the only integrated experience consultancy in the world with a heritage in data science and business performance, Merkle delivers holistic, end-to-end experiences that drive growth, engagement, and loyalty. Merkle's expertise has earned recognition as a "Leader" by top industry analyst firms, in categories such as digital transformation and commerce, experience design, engineering and technology integration, digital marketing, data science, CRM and loyalty, and customer data management. With more than 16,000 employees, Merkle operates in 30+ countries throughout the Americas, EMEA, and APAC. For more information, visit www.merkle.com.

Who are we looking for?

We are looking for an Power BI Expert (Advanced DAX) to lead the design, implementation, and governance of business intelligence solutions in a complex, multi-stakeholder environment. This role combines deep technical expertise with strong data governance and stakeholder enablement capabilities.

Key Responsibilities

* Act as the Power BI subject matter expert and référent across the organization
* Design and implement scalable data models (star schema / snowflake)
* Develop and optimize advanced DAX measures and calculations
* Build and maintain robust Power BI dashboards and reports
* Lead data transformation processes using Power Query (M)
* Ensure implementation of data security models (RLS / OLS)
* Manage and optimize Power BI Service deployment, including workspaces, pipelines, and access governance
* Drive governed self-service BI, enabling business users while maintaining data integrity
* Collaborate with cross-functional teams to translate business needs into data solutions
* Contribute to best practices, standards, and BI governance frameworks

Required Skills & Experience:

* 5+ years of hands-on experience with Power BI in complex environments
* Strong expertise in:
* Advanced DAX
* Data modeling (star schema / snowflake)
* Power Query (M)
* Proven experience with:
* Row-Level Security (RLS) and Object-Level Security (OLS)
* Power BI Service deployment and administration
* Experience working in large, multi-business organizations
* Strong understanding of data governance and self-service BI frameworks
* Ability to work with both technical and business stakeholders
* Fluent in English and French

Nice to Have

* Experience with Microsoft Fabric
* Background in airport, aviation, or transport environments
* Experience in regulated industries (e.g., financial services, FINMA-regulated environments)
Why choose dentsu?

Global Reach with Local Expertise: Join a network that spans 145 countries, with over 70,000 talented employees. Collaborate with bright minds worldwide and gain insights from diverse industries and markets.
Innovation at Our Core: For over 120 years, we have been pushing boundaries to connect brands with their audiences through cutting-edge technology, creativity, and transformative solutions.
Commitment to Impact: We focus on driving meaningful outcomes for our clients and their communities, whether through increasing revenue, influencing behavior change, or fostering positive organizational culture.
Collaborative Network: Work alongside six global brands all united in delivering highly integrated and scaled transformation solutions.

These are some of the things we offer:

🏝️ 25 days of holidays
💝 2 volunteer days for charitable activities
💖 Mental Health: Benefit from 3 extra wellness days on top of your vacation days and a Mental Health First Aider and Employee Assistance program to support your well-being
🕐40-hour week & overtime compensation
⏰ Flexible working hours model (flextime)
🏠 Independent home office management
💻State-of-the-art, creative office space with ergonomically equipped workstations
🐶 Pet friendly offices (Zurich and St. Gallen)
🎓 Full access to Dentsu Academy, on-site learning sessions, online language courses
💸 Referral bonus program 
✈️Workation possibility
🍹 Team events: company parties, monthly breakfasts, aperos

#LI-MERKLE #LI-SOFI

Location:Geneva

Brand:Merkle

Time Type:Full time

Contract Type:Permanent