Power BI Developer
dentsu · Posted Sep 23
Integrated advertising, marketing, media, and business transformation services
Get a personal compatibility score
Add a resume for personal matches
About the role
The Business Intelligence team at Merkle (dentsu) supports clients with reporting capabilities, driving engagements that develop dashboards and reports to measure overall marketing effectiveness across multiple marketing channels. The role serves as a point of contact between internal and external stakeholders to identify reporting needs and deliver solutions. This Power BI Developer / Lead Analyst position focuses on building highly visual, interactive dashboards and reports while acting as the reporting Subject Matter Expert for strategic clients.
What you will do
- Gather and analyse reporting requirements from stakeholders, including new data needs, report layout preferences, and business objectives.
- Develop and maintain advanced interactive dashboards and reports that provide actionable insights to stakeholders.
- Provides strategic, technical and or operational reporting best practices and guidance.
- Reporting expertise and knowledge to solve business challenges and provide focus to team members.
- Ability to formulate analytical problem, summarize key findings/insights and make helpful recommendations.
- Thought leadership and guidance in the development of client-facing presentations and read-outs.
- Drives the overall client engagement as the reporting Subject Matter expert (SME) in delivering reporting solutions while collaborating with data team.
- Analysis of reporting requirements; including new data requirements, reporting layout and user needs.
- Define best practices and the design/development, deployment, and maintenance of reports. Ensures that project goals/milestones are met.
Skills used in this role
What the employer is looking for
- 3+ year of experience in data analysis and visualization
- Expertise in in BI/Visualization tools, specifically Power BI (certification must have).
- Strong proficiency in:
- DAX (Data Analysis Expressions) for creating calculated columns, measures, and KPIs.
- Power Query (M language) for data transformation and ETL processes.
- Data Modelling including star schema, snowflake schema, and normalization techniques.
- Power BI Service: row-level security (RLS), workspace management, app deployment, gateway configuration, and scheduled refreshes.
- Degree in computer science, information systems, or another technology-related field.
- Intermediate proficiency in SQL, Google BigQuery.
- Strong analytical and problem-solving skills.
- Excellent communication and presentation abilities.
Preferred qualifications
- Good to have - Familiarity with Google Dataform, Composer and Looker.
- Optional: Marketing Analytics experience.
Benefits and support
- Compensation and benefits are detailed in the job posting
About dentsu
Dentsu Group Inc. is an integrated growth and transformation partner to the world's leading organizations, delivering comprehensive media, customer experience management (CXM), and creative services. Operating globally across approximately 120 countries, the agency combines deep human insights, creative innovation, and advanced data technologies to accelerate business growth. Headquartered in Tokyo, Japan, Dentsu has a rich heritage of shaping the advertising and marketing industry since 1901.
- Industry
- Advertising
- Company size
- 67000+ employees
- Founded
- 1901-07-01
- Location
- Tokyo, Japan
- Funding stage
- Public Company
Funding
Public Company
- 2022-03-29Post Ipo
Leadership
Takeshi Sano
Representative Executive Officer, President & Global CEO
Yoshimasa Watahiki
Representative Executive Officer, EVP & Global Chief Corporate Affairs Officer
Shigeki Endo
Executive Officer & Global CFO
Beth Ann Kaminkow
CEO, Dentsu Americas & Chief Global Client Officer
Yuichi Toyoda
CEO, Dentsu APAC
Recent coverage
Campaign Middle East
dentsu ventures into Hollywood with 'The Angry Birds Movie 3'2026-10-06
Dentsu
Carat Named Media Network Of The Year At Cannes Lions 20262026-06-22
Dentsu
Dentsu Unveils Next Evolution Of Dentsu.Connect, Industry's First Truly Agentic AI-Powered Operating System For Modern Marketing2026-04-07
Dentsu
Dentsu Announces New Global Management Structure — Further Contributing to Client Growth by Strengthening Execution Capabilities2026-02-13