Senior Data Engineer

Job Description:

DCF Level: L30

About the Role

We are seeking a highly analytical and business-focused Senior Experimentation Analytics Consultant to support the evolution of our experimentation and customer analytics ecosystem.

This role is primarily focused on understanding customer behavior, analyzing experimentation outcomes, and delivering actionable business insights that drive product and customer experience decisions. The ideal candidate will possess strong expertise in experimentation analytics, clickstream analysis, customer journey analytics, and statistical analysis, while also having sufficient technical proficiency in GCP, BigQuery, and Dataform to independently access, prepare, and analyze large-scale datasets.

This position emphasizes the ability to answer critical business questions such as:

• Why did an experiment succeed or fail?
• What customer behaviors influenced the outcome?
• What was the true business impact of a feature rollout?
• Did seasonality, customer migration, or cannibalization affect the results?
• What actions should the business take based on the findings?

The successful candidate will serve as a trusted analytics partner to Product, Experimentation, Business, and Technology teams by translating complex data into clear business recommendations.

Key Responsibilities

1. Experimentation Analytics & Business Impact Assessment

• Lead analysis of A/B tests, multivariate tests, and feature rollout experiments.
• Evaluate experiment outcomes against predefined business objectives and success metrics.
• Identify and explain the key drivers behind experiment performance.
• Assess impact across conversion, revenue, engagement, retention, customer experience, and operational metrics.
• Translate analytical findings into actionable recommendations for product and business stakeholders.
• Partner with experimentation teams to develop measurement strategies and success criteria.
• Build repeatable frameworks for experiment performance evaluation and business impact measurement.

2. Customer Behavior & Journey Analytics

• Analyze clickstream, customer journey, and behavioral data to understand customer interactions across digital channels.
• Identify customer behavior patterns, friction points, and conversion opportunities.
• Conduct funnel analysis to understand customer progression through digital experiences.
• Develop customer segmentation and behavioral cohort analyses.
• Evaluate customer engagement, adoption, retention, and conversion trends.
• Support initiatives focused on customer experience optimization and personalization.

3. Advanced Analytical Investigations

• Perform deep-dive investigations into unexpected experiment outcomes and business performance changes.
• Quantify and explain:• Cannibalization effects
• Incrementality impacts
• Seasonality influences
• Customer migration patterns
• Traffic shifts
• Feature adoption behavior
• Funnel performance changes
• Customer retention trends

• Conduct root-cause analyses to identify factors influencing customer and business outcomes.
• Develop analytical frameworks that help quantify business value realization from product and customer experience initiatives.

4. Stakeholder Consulting & Business Storytelling

• Serve as the primary analytics liaison across:• Experimentation Teams
• Product Management
• Customer Experience Teams
• Business Stakeholders
• Data Engineering Teams

• Translate complex analytical findings into business-friendly narratives.
• Present recommendations and insights to both technical and executive audiences.
• Facilitate discussions that align business objectives with analytical approaches.
• Drive adoption of data-driven decision-making across the organization.

5. Reporting, KPI Development & Visualization

• Design and maintain experimentation dashboards and performance scorecards.
• Define and standardize experiment measurement KPIs and reporting frameworks.
• Develop executive-ready reports highlighting key findings, business impacts, and recommendations.
• Ensure consistency and governance of experiment reporting across teams.
• Support self-service analytics initiatives by creating reusable analytical assets and datasets.

6. Analytics Data Engineering Support

• Utilize BigQuery, Dataform, SQL, and Python to prepare and analyze experimentation datasets.
• Build lightweight data transformations supporting experimentation and customer analytics.
• Partner with Data Engineering teams to ensure required datasets are available and reliable.
• Validate data quality and consistency across experimentation and analytics platforms.
• Support integration of experimentation, clickstream, customer, and transaction datasets.

Technical Expertise Required

Area

Skills / Technologies

Experimentation Analytics

A/B Testing, Multivariate Testing, Experiment Design, Hypothesis Testing

Customer Analytics

Clickstream Analytics, Customer Journey Analytics, Behavioral Analytics, Customer Segmentation

Advanced Analytics

Root Cause Analysis, Funnel Analysis, Cohort Analysis, Incrementality Analysis, Business Impact Assessment

Statistical Analysis

Statistical Significance Testing, Confidence Intervals, Lift Analysis, Experiment Validation

Data Analysis

Advanced SQL, Exploratory Data Analysis (EDA), KPI Development

Visualization & Reporting (Basic)

Tableau, Power BI, Looker Studio, Executive Reporting

Cloud Analytics

GCP, BigQuery

Data Transformation

Dataform, SQL, Python

Data Modeling

Dimensional Modeling, Analytical Data Models

Data Integration

Clickstream Data, Transaction Data, Customer Data, API Integrations

Collaboration

Stakeholder Management, Business Communication, Requirements Gathering

Qualifications

• Bachelor's degree in Statistics, Mathematics, Data Science, Computer Science, Engineering, Analytics, Economics, or a related field.
• 4 – 6 years of experience in experimentation analytics, product analytics, customer analytics, digital analytics, or related analytical roles.
• Strong hands-on experience analyzing A/B testing and experimentation programs.
• Deep understanding of customer behavior analytics, clickstream analysis, and customer journey measurement.
• Advanced SQL expertise with the ability to independently investigate complex business questions.
• Experience working with BigQuery and large-scale analytical datasets.
• Strong understanding of statistical concepts and experimentation methodologies.
• Demonstrated ability to translate analytical findings into business recommendations.
• Excellent communication, presentation, and stakeholder management skills.
• Experience working in Agile and cross-functional environments.

Preferred Experience

• Retail, eCommerce, Digital Commerce, or Customer Experience Analytics domain expertise.
• Experience with Adobe Analytics, Google Analytics, or similar digital analytics platforms.
• Experience supporting experimentation and feature rollout programs.
• Experience creating executive-level dashboards and performance scorecards.

Location:

DGS India - Pune - Kharadi EON Free Zone

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent