Business Intelligence SME Architect

Dentsu

Thane

On-site

INR 2,500,000 - 4,500,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Merkle in Mumbai (DGS India) seeks a seasoned Business Intelligence – Manager to lead the creation of highly visual dashboards and reports across multiple marketing channels. You will guide client teams, identify reporting needs, and drive analytics engagements that shape strategic decisions for key clients.

You’ll be the reporting SME coordinating with data teams and stakeholders to deliver scalable solutions.

Qualifications

  • 8+ years of experience in data analysis and visualization.
  • Proficiency in BI/Visualization tools, especially Power BI with certification.
  • Strong knowledge of DAX, Power Query, and data modelling (star/snowflake).
  • Experience with Power BI Service features (RLS, workspace, deployment, gateway, refresh).
  • Degree in CS, information systems or related field.
  • Proficiency in SQL and Google BigQuery.
  • Excellent communication and presentation skills.
  • Nice to have: Google Dataform, Looker, Composer.

Responsibilities

  • Gather and analyse reporting requirements from stakeholders and define data needs.
  • Develop and maintain interactive dashboards and reports delivering actionable insights.
  • Provide best practices for reporting and analytics
  • Lead client-facing reporting solutions and engage with data teams
  • QA plans to align deliverables with requirements and troubleshoot issues.
  • Define best practices for design, development, deployment and maintenance of reports.
  • Coordinate with internal and external stakeholders to manage project plans and deadlines
  • Support measurement of marketing effectiveness through dashboards and reports.

Skills

Data analysis
Data visualization
Communication skills
Presentation skills
Problem solving

Education

Bachelors in Computer Science / Information Systems

Tools

Power BI
DAX
Power Query
Data modelling
Power BI Service (RLS, workspaces)
SQL
BigQuery
Looker
Google Dataform
Composer

Job description

Job Description:

Business Intelligence – Manager

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

Requirements:

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence SME / Architect
Business Intelligence SME / Architect

Dentsu International Americas • Thane

On-site
INR 900,000 - 1,300,000
Business Intelligence SME / Architect
Business Intelligence SME / Architect

Dentsu • Thane

On-site
INR 1,500,000 - 2,600,000
Business Intelligence SME / Architect
Business Intelligence SME / Architect

dentsu • Mumbai

On-site
INR 2,400,000 - 4,200,000
Senior Associate Business Intelligence Analytics and Reporting
Senior Associate Business Intelligence Analytics and Reporting

Shashwath Solution • Dadri

Remote
INR 800,000 - 1,200,000
Senior Associate Business Intelligence Analytics and Reporting
Senior Associate Business Intelligence Analytics and Reporting

Shashwath Solution • Pune District

Remote
INR 900,000 - 1,300,000
Senior Associate Business Intelligence Analytics / Reporting
Senior Associate Business Intelligence Analytics / Reporting

Shashwath Solution • Pune District

On-site
INR 900,000 - 1,300,000
Senior Associate Business Intelligence Analytics / Reporting
Senior Associate Business Intelligence Analytics / Reporting

Shashwath Solution • Dadri

On-site
INR 1,500,000 - 2,500,000
Business Intelligence Engineer - Dashboard Design
Business Intelligence Engineer - Dashboard Design

Forward Eye Technologies • Pune District

On-site
INR 1,500,000 - 3,000,000
Business Intelligence Engineer - Dashboard Design
Business Intelligence Engineer - Dashboard Design

Forward Eye Technologies • Dadri

On-site
INR 1,400,000 - 2,400,000
Assistant Manager - Business Intelligence
Assistant Manager - Business Intelligence

Tech Mahindra Limited • Mumbai

On-site
INR 1,400,000 - 2,200,000