dentsu Logo

dentsu

Business Intelligence SME / Architect

Reposted 5 Days Ago
Be an Early Applicant
In-Office
2 Locations
Senior level
In-Office
2 Locations
Senior level
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.
The summary above was generated by AI

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

dentsu Mumbai, Maharashtra, IND Office

Mumbai, India

Similar Jobs

5 Days Ago
In-Office
2 Locations
Senior level
Senior level
AdTech • Marketing Tech • Software
Lead client-facing reporting engagements, gather requirements, design and maintain interactive Power BI dashboards, perform data modeling and ETL, ensure QA and best practices, and guide stakeholders with analytical insights to measure marketing effectiveness.
Top Skills: ComposerDaxGoogle BigqueryGoogle DataformLookerPower BIPower Bi ServicePower Query (M)SQL
Yesterday
Hybrid
Senior level
Senior level
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Lead consulting engagements that translate business requirements into technical solutions. Design and deliver data platforms, ETL pipelines, analytics solutions, architectures, prototypes, testing, deployment, and operations plans using Databricks, Snowflake, Python, PySpark, SQL, and AWS. Manage project teams, distribute tasks, mentor junior staff, communicate with clients, support project planning and risk mitigation, and ensure high-quality delivery across global teams.
Top Skills: SparkAWSDatabricksETLGitPysparkPythonSnowflakeSQL
Yesterday
Hybrid
Junior
Junior
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Build and deliver client technology solutions using ETL platforms, SQL, data warehousing, programming, and cloud technologies. Own assigned activities across project lifecycles, apply Agile or Waterfall methodologies, support requirements, architecture, prototyping, testing, and operations, and assist with project management. Collaborate with global teams and clients while applying creative, analytical, and consulting-oriented problem solving.
Top Skills: AWSETLGoogle Cloud PlatformInformaticaAzureSQLSsisTalend

What you need to know about the Mumbai Tech Scene

From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account