Business Intelligence SME / Architect

Sorry, this job was removed at 06:53 p.m. (UTC) on Tuesday, Sep 29, 2026
Be an Early Applicant
2 Locations
In-Office
Senior level
AdTech • Marketing Tech
The Role
Lead development of advanced interactive dashboards and reports, gather and analyze stakeholder requirements, provide BI best practices and QA, mentor teams, manage client engagements, and measure marketing effectiveness using Power BI, DAX, Power Query, SQL and BigQuery.
Summary Generated by Built In

Job Description:

Business Intelligence – Manager

Job Description:

A qualified professional with experience in developing highly visual dashboards and reports optimizing multiple marketing channels. The Manager role is focused on collaborating with client teams to tackle high-impact, complex analytics challenges. Guide client stakeholders in developing effective problem-solving strategies and scaling analytics efforts that drive strategic decision-making within their organizations.  Focused on supporting our clients with reporting capabilities and will be driving the overall engagement in developing dashboards and reports on strategic clients and helping measure their overall marketing effectiveness. Will serve as a point of contact between multiple stakeholders both internal and external to identify reporting needs and deliver the solution.

Key Responsibilities:

  • 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.
  • Create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues.
  • Define best practices and the design/development, deployment, and maintenance of reports. Ensures that project goals/milestones are met.
  • Work with various internal and external stakeholders to develop project plan, manage the day-to-day tasks and meet project deadlines

Required Skill:

  • 8+ 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.
  • Good to have - Familiarity with Google Dataform, Composer and Looker.
  • Optional: Marketing Analytics experience.

Location:

DGS India - Mumbai - Thane Ashar IT Park

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Skills Required

  • 8+ years of experience in data analysis and visualization
  • Power BI certification
  • Expertise in DAX (Data Analysis Expressions)
  • Expertise in Power Query (M language)
  • Data modeling experience (star schema, snowflake, normalization)
  • Power BI Service experience (RLS, workspace management, app deployment, gateway configuration, scheduled refreshes)
  • Degree in computer science, information systems, or related field
  • Intermediate proficiency in SQL
  • Intermediate proficiency in Google BigQuery
  • Strong analytical and problem-solving skills
  • Excellent communication and presentation abilities
  • Familiarity with Google Dataform, Composer and Looker
  • Marketing Analytics experience

dentsu Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about dentsu and has not been reviewed or approved by dentsu.

  • Parental & Family Support — Paid parental leave at full pay and caregiver supports (including backup care) are emphasized as standout elements. Feedback suggests family-oriented benefits are a strong part of the package.
  • Leave & Time Off Breadth — Flexible or unlimited PTO, extensive paid holidays, and a year-end office closure are established components. Feedback suggests time-off policies are generous and add meaningful flexibility.
  • Retirement Support — A large, established 401(k) plan with employer matching is clearly documented. Feedback suggests retirement benefits feel competitive and straightforward.

dentsu Insights

Similar Jobs

Mastercard Logo Mastercard

Senior Software Engineer

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Pune, Maharashtra, IND
38800 Employees

Mastercard Logo Mastercard

Software Engineer

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Pune, Maharashtra, IND
38800 Employees

Mastercard Logo Mastercard

Senior Data Engineer

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Pune, Maharashtra, IND
38800 Employees

Mastercard Logo Mastercard

Manager, Software Engineering - Java, Springboot, Kafka, SQL

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Pune, Maharashtra, IND
38800 Employees
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Minato
15,492 Employees

What We Do

We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next

Similar Companies Hiring

MFour Data Research Thumbnail
Marketing Tech • Software
Irvine, CA
98 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
30 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account