Back
Merkle logo

Lead Analyst - Marketing Analytics

Merkle · Posted Oct 9

Data-driven customer experience management, marketing, and digital transformation services

Bengaluru, IndiaFull-timeOnsiteLead/Staff7+ years₹28.0L–₹42.0L yearly72 applicants
Digital MarketingCustomer Experience ManagementData AnalyticsConsulting ServicesCRMPublic Company
Full time

Get a personal compatibility score

Add a resume for personal matches

About the role

Merkle (dentsu) is hiring within its Marketing Analytics & AI Solutions team in Bengaluru, delivering marketing analytics, data engineering on Microsoft Fabric and applied AI for clients. The team owns client problems end to end, turning marketing and clickstream data into dashboards, insights and AI-driven automation. This role leads a team of 8–10 analysts and engineers while remaining hands-on with SQL, Python, Fabric and Power BI.

What you will do

  • Own client problems from start to finish: frame the business question, design the solution, build it, and land the insight with stakeholders.
  • Act as a trusted advisor to client and internal stakeholders; translate marketing and business goals into clear data and analytics requirements.
  • Break down ambiguous, cross-functional problems instead of working on siloed tasks; connect data, reporting and AI into one solution.
  • Present findings and recommendations in a clear, simple, business-first way.
  • Lead analysis of campaign, channel and website performance using clickstream and marketing data (e.g., Adobe Analytics, media platforms).
  • Build and interpret funnel, journey, attribution and conversion analyses to drive optimisation decisions.
  • Define KPIs and measurement frameworks that link marketing activity to business outcomes.
  • Manage ETL/ELT pipelines that ingest marketing and clickstream data from APIs, cloud apps and databases.
  • Apply Microsoft Fabric concepts – Lakehouse, OneLake, Data Factory pipelines, Notebooks and the Medallion (Bronze, Silver, Gold) architecture.
  • Enforce data quality, governance and documentation; keep pipelines reliable, performant and cost-effective.
  • Lead the design and build of Power BI dashboards and semantic models (data modelling, DAX, row-level security, performance tuning).
  • Move reporting from manual effort to automated, self-serve insight for business users.
  • Identify use cases where AI agents add value – e.g., insight generation, anomaly detection, reporting commentary, analyst co-pilots.
  • Design, build and deploy AI agents, preferably on Azure AI Foundry, integrated with Fabric data and Power BI.
  • Judge when rule-based automation (scripts, scheduled pipelines, Power Automate) is the better and cheaper choice than an agent; build the business case on cost, accuracy and effort.
  • Monitor agent quality, cost (e.g., token usage) and responsible AI guardrails in production.
  • Lead, coach and grow a team of 8–10 analysts and engineers; set clear goals, review work and build skills in AI and Fabric.
  • Own operational metrics – utilisation, on-time delivery, SLA adherence, quality/rework, backlog health and client satisfaction.
  • Plan capacity, allocate work and manage risks and escalations across multiple workstreams.
  • Drive process improvements, reusable assets and automation that raise team productivity.

Skills used in this role

Power BIDAXSQLPythonpandasPySparkMicrosoft FabricOneLakeAzure Data FactoryAzure AI FoundryAzureCopilot StudioSemantic KernelLangChainLangGraphAdobe AnalyticsGA4BigQueryAzure DatabricksAlteryxPower AutomateETLLLM

What the employer is looking for

  • 7+ years of experience in marketing analytics, digital analytics or data & analytics roles.
  • Proven experience managing ETL/ELT data pipelines end to end.
  • Strong hands-on experience building Power BI dashboards and data models.
  • Hands-on experience building or deploying AI agents or LLM-based solutions, with a clear view on when automation is the cheaper option.
  • Experience leading a team of 8–10 people and managing operational metrics.
  • Consulting or client-facing experience, ideally in an agency or professional services setting.

Preferred qualifications

  • AI agents: Azure AI Foundry (preferred); exposure to Copilot Studio, Semantic Kernel or LangChain/LangGraph is a plus.
  • Microsoft Fabric: Lakehouse, OneLake, Data Factory pipelines, Notebooks, Medallion architecture.
  • Clickstream: Adobe Analytics and/or GA4, including raw hit-level data (data feeds / BigQuery export).
  • Marketing analytics: campaign performance, attribution, funnel and journey analysis.
  • Power BI: data modelling, DAX, semantic models, performance tuning.
  • Python and SQL: data manipulation (pandas, PySpark) and advanced SQL.
  • Microsoft certifications such as DP-600 (Fabric Analytics Engineer), DP-700 (Fabric Data Engineer) or AI-102 (Azure AI Engineer).
  • Exposure to Azure Databricks, Alteryx or similar ETL tools.
  • Understanding of consent, privacy and data governance in marketing data.

Benefits and support

  • Compensation and benefits are detailed in the job posting

About Merkle

Merkle logo

Merkle

Company website
LinkedInXCrunchbaseGlassdoor★3.6

Merkle is a data-driven, technology-enabled customer experience management (CXM) company and part of the dentsu network. It specializes in delivering unique, personalized customer experiences across platforms and devices by leveraging deep capabilities in data science, analytics, and CRM. The company operates globally, helping enterprise brands drive business growth and long-term customer loyalty.

Industry
Digital Marketing
Company size
10001+ employees
Founded
1988
Location
Columbia, Maryland, USA
Funding stage
Acquired

Funding

Acquired

TCVDentsu Group

Leadership

PS
Pete Stein

Global President

DW
David Williams

Chairman / Former CEO

DK
Dan Knauf

Chief Technology Officer, Americas

MF
Missy Foristall

Chief Operating Officer, Americas

Recent coverage

Apply on company site