Business Intelligence SME / Architect

Dentsu Aegis Network Ltd.; Mumbai; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Dentsu Aegis Network Ltd. in Mumbai seeks a Business Intelligence – Manager to lead the design of highly visual dashboards and reports across marketing channels.

You will partner with client teams to tackle analytics challenges and guide stakeholders in shaping scalable reporting solutions. The role focuses on delivering actionable insights, data modeling, and governance, acting as the SME for reporting and ensuring delivery within timeframes.

Qualifications

• 8+ years of experience in data analysis and visualization.
• Expertise in BI/Visualization tools, specifically Power BI (certification must have).
• Strong proficiency in DAX for creating calculated columns, measures, and KPIs.
• Power Query (M language) for data transformation and ETL processes.
• Data modeling including star and snowflake schemas.
• Power BI Service: RLS, workspace management, app deployment, gateway configuration, and scheduled refreshes.
• Degree in computer science, information systems, or related field.
• Intermediate proficiency in SQL and Google BigQuery.
• Strong analytical and problem-solving skills.
• Excellent communication and presentation abilities.

Responsibilities

• Gather and analyse reporting requirements from stakeholders and business objectives.
• Develop and maintain interactive dashboards and reports delivering actionable insights.
• Provide strategic reporting guidance and best practices.
• Serve as reporting SME and drive client engagements.
• Formulate analytical problems and summarize key findings with recommendations.
• Lead client-facing presentations and read-outs.
• Oversee QA plans and troubleshoot issues to align with requirements.
• Define best practices across design, development, deployment, and maintenance of reports.
• Ensure project goals and milestones are met.
• Collaborate with internal and external stakeholders to manage project plan and timelines.

Skills

DAX

Data Modeling

SQL

Google BigQuery

Analytical skills

Problem-solving

Communication

Education

Bachelor's degree in Computer Science / Information Systems

Tools

Power BI

Power Query

M Language

ETL

Job description

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: 全职 Contract Type: 永久

About dentsu

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us Who we are Our Social Impact Our work