dentsu Logo

dentsu

Senior Data Engineer

Reposted 4 Days Ago
Be an Early Applicant
In-Office
New Delhi, Delhi, IND
Senior level
In-Office
New Delhi, Delhi, IND
Senior level
Design, build, and modernize scalable GCP data pipelines integrating Adobe clickstream, Salesforce, POS, and CDPs. Implement Dataform/BigQuery ELT, semantic models, and governed AI-ready datasets to support analytics, self-service reporting, and Gemini-powered GenAI initiatives. Collaborate with analytics and business stakeholders on KPIs, metadata, and deployment best practices.
The summary above was generated by AI

Job Description:

About the Role

We are seeking a highly motivated and analytical Data Engineer to support the evolution of our customer analytics and AI-enabled data platform on Google Cloud Platform (GCP).

This role will focus on integrating Adobe Analytics clickstream data with enterprise systems such as Salesforce, POS, and customer data platforms while building scalable data transformation frameworks using Dataform and BigQuery. The role will play a critical part in enabling a semantic data layer that supports enterprise analytics, self-service insights, and next-generation AI initiatives powered by Gemini and BigQuery.

The ideal candidate combines strong GCP data engineering skills with a solid understanding of customer journey analytics, clickstream data, semantic modeling, and modern AI-ready data architectures.

Key Responsibilities

1. Customer Analytics Data Engineering

  • Design and maintain scalable data pipelines supporting customer journey analytics.
  • Integrate Adobe Analytics clickstream data with:
    • Salesforce CRM
    • POS and transaction systems
    • Marketing platforms
  • Build reliable ingestion, transformation, and serving layers for analytics and AI use cases.
  • Ensure high-quality, governed, and trusted customer analytics datasets.

2. Dataform & Data Transformation Modernization

  • Develop and maintain enterprise-grade ELT pipelines using Dataform and BigQuery.
  • Support migration and modernization of existing workflows into Dataform-based architectures.
  • Implement reusable transformation logic and standardized data engineering patterns.
  • Optimize data processing performance, maintainability, and scalability.
  • Establish best practices around testing, deployment, monitoring, and documentation.

3. Clickstream & Customer Journey Analytics Enablement

  • Build data models supporting customer journey analysis and behavioral insights.
  • Enable tracking and reporting across customer touchpoints and digital experiences.
  • Support creation of unified customer views by integrating digital, CRM, and transaction data.
  • Collaborate with analytics teams to improve data accessibility and business usability.

4. Semantic Layer Development

  • Design and implement semantic data models that simplify enterprise data consumption.
  • Define business-friendly metrics, dimensions, and reusable analytical entities.
  • Support creation of governed semantic layers for reporting, analytics, and AI applications.
  • Collaborate with business and analytics stakeholders to standardize KPIs and data definitions.
  • Contribute to metadata management and enterprise data catalog initiatives.

5. AI & Gemini Data Enablement

  • Build AI-ready datasets and data structures supporting enterprise GenAI initiatives.
  • Support implementation of semantic data foundations for Gemini-powered analytics experiences.
  • Enable integration with Gemini Enterprise and BigQuery connectors.
  • Prepare and optimize datasets for conversational analytics and AI-assisted data interaction.
  • Contribute to future-state AI and knowledge-driven data architectures.
  • Support stakeholder discussions around customer analytics, semantic modeling, and AI readiness.

Technical Expertise Required

Area

Skills / Technologies

Customer Analytics

Adobe Analytics, Clickstream Analytics, Customer Journey Analytics

Cloud Data Engineering

GCP, BigQuery, Cloud Storage

Data Transformation

Dataform, SQL, Python

Data Modeling

Dimensional Modeling, Semantic Modeling

Data Integration

Salesforce Integration, POS Data Integration, Customer Data Platforms

Analytics

Advanced SQL, Reporting Datasets, KPI Frameworks

AI Enablement

Gemini Enterprise, BigQuery Connectors, AI-Ready Data Platforms

Metadata & Governance

Data Catalog, Metadata Management, Lineage

DevOps

Git, CI/CD, Data Pipeline Automation

Qualifications

  • Bachelor's degree in Computer Science, Engineering, Information Systems, Analytics, or related field.
  • 4 - 6 years of experience in cloud data engineering and analytics platform development.
  • Strong hands-on experience with BigQuery, SQL, and Dataform.
  • Experience working with clickstream and customer behavioral datasets.
  • Exposure to Adobe Analytics or similar digital analytics platforms.
  • Experience integrating enterprise systems such as Salesforce, CRM platforms, POS systems, or customer data platforms.
  • Strong understanding of semantic modeling and analytical data structures.
  • Familiarity with AI-enabled analytics ecosystems and modern data platforms.
  • Strong stakeholder communication and problem-solving skills.

Preferred Experience

  • Retail, eCommerce, Digital Commerce, or Customer Experience Analytics domain.
  • Adobe Analytics implementation or support experience.
  • Experience building customer 360 or customer journey analytics platforms.
  • Experience developing semantic layers for self-service analytics.
  • Exposure to Gemini Enterprise, GenAI, or conversational analytics initiatives.
  • GCP Professional Data Engineer certification.

Location:

DGS India - Bengaluru - Manyata N1 Block

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

dentsu Gurugram, Haryana, IND Office

Gurugram, India

dentsu New Delhi, Delhi, IND Office

New Delhi, India

Similar Jobs

Yesterday
In-Office or Remote
India
Senior level
Senior level
Agency • Information Technology
Design and implement data federation and lakehouse architectures (Starburst/Trino), build scalable ETL/ELT pipelines using Python and Spark, optimize Spark and federated queries, manage Delta/Iceberg/Hudi tables, and enforce governance, access control, and data masking for analytics and AI use.
Top Skills: AdlsApache IcebergSparkAws EmrAzure DatabricksDbtDelta LakeDremioGCPGlueHudiKubernetesMedallion ArchitecturePrestoPulumiPysparkPythonS3Snowflake SchemaSQLStar SchemaStarburst EnterpriseTerraformTrino
9 Days Ago
In-Office or Remote
India
Senior level
Senior level
Agency • Information Technology
Design, implement, and optimize Apache DolphinScheduler workflows and ETL pipelines. Integrate with Hadoop, Spark, Flink, Hive, and Kafka. Develop custom plugins, troubleshoot performance and scalability issues, monitor job execution and resource allocation, and maintain CI/CD, version control, and infrastructure automation while collaborating with data engineers and DevOps teams.
Top Skills: Apache DolphinschedulerCi/CdDevOpsFlinkHadoopHiveJavaKafkaPythonScalaSparkVersion Control
9 Days Ago
In-Office or Remote
India
Senior level
Senior level
Agency • Information Technology
Design, develop, test, and deploy high-performance Spark/Scala data processing applications and ETL pipelines on Cloudera (CDH). Optimize Spark and Cloudera platform performance, integrate HDFS/Hive/Impala/HBase/Kafka, ensure data integrity/security, and implement version control and CI/CD for production pipelines.
Top Skills: SparkCloudera CdhFlumeGitGitlabHbaseHdfsHiveImpalaJenkinsKafkaNifiOoziePostgresScalaSpark SqlSQLSqoop

What you need to know about the Delhi Tech Scene

Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account