Power BI Expert (Advanced DAX)
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)
Benefits
* 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
Location
Geneva
#J-18808-Ljbffr