Power BI Developer

dentsu; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Merkle is seeking a Business Intelligence – Lead Analyst (DCF Level - 30) in Pune to develop highly visual dashboards and reports, supporting marketing channels and client engagement. You will be the reporting SME, translating stakeholder needs into scalable BI solutions and guiding the data team.

The role emphasizes dashboard development, data modelling, and delivering insights to measure marketing effectiveness across strategic clients. Permanent, full-time position in DGS India, Pune.

Qualifications

• 3+ years of data analysis and visualization experience.
• Expertise in BI/Visualization tools, specifically Power BI (certification required).
• Strong proficiency in DAX for calculated columns, measures and KPIs.
• Strong proficiency in Power Query (M language) for data transformation and ETL processes.
• Data modelling knowledge including star/snowflake schemas and normalization.
• Power BI Service experience: RLS, workspace, app deployment, gateway, refresh scheduling.
• Degree in computer science, information systems, or related field.
• Intermediate SQL and Google BigQuery skills.
• Strong analytical and problem-solving abilities.
• Excellent communication and presentation skills.
• Nice to have familiarity with Looker, Dataform, and Composer.
• Optional: Marketing Analytics experience.

Responsibilities

• Gather and analyse reporting requirements from stakeholders, including new data needs and report layouts.
• Develop and maintain advanced interactive dashboards and reports with actionable insights.
• Provide strategic and technical reporting guidance to the team.
• Apply reporting best practices to solve business challenges and focus the team.
• Summarize key findings and provide actionable recommendations.
• Contribute to client-facing presentations and read-outs as SME for reporting.
• Lead client engagement as the reporting SME in delivering solutions with data team.
• Analyze reporting requirements and define best practices for design, development and maintenance of reports.

Skills

Power BI

DAX

Power Query

Data Modelling

Power BI Service

SQL

BigQuery

Education

Bachelor's degree in Computer Science / Information Systems or related field

Tools

Power BI

SQL

Google BigQuery

Job description

Job Description

Business Intelligence – Lead Analyst (DCF Level - 30)

Job Description

A qualified professional with experience in developing highly visual dashboards and reports optimizing multiple marketing channels. The Senior Analyst role is 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 requirementsfrom 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.

Required Skill

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

Location

DGS India - Pune - Indiqube Orchid

Brand

Merkle

Time Type

Full time

Contract Type

Permanent