Job Description:
Senior Data Engineer – Content Ops & Site Quality
Role Overview
We are looking for a Senior Data Engineer to support the Data Engineering ecosystem for Content Operations and Site Quality . The role will involve managing and enhancing large-scale data pipelines, data models, analytics infrastructure, and AI-driven solutions that support business and analytics teams.
The ideal candidate will have strong hands-on experience in SQL, PySpark, data engineering, cloud/data platforms, and a working understanding of Adobe Analytics and AI/LLM-based solutions.
Key Responsibilities
Data Engineering & Platform Management (Must have)
- Own and manage Data Engineering activities supporting Content Ops and Site Quality.
- Develop, maintain, and optimize data pipelines supporting approximately 150 MDP tables, 2 SSAS Cubes, and multiple Airflow workflows.
- Build and maintain scalable data processing solutions using SQL Server, Iceberg, PySpark, ECS, and Airflow.
- Troubleshoot data quality, pipeline, performance, and production issues and drive them through to resolution.
- Support data modeling and development of reliable datasets for downstream analytics and reporting.
AI & Analytics Solutions (Preferred)
- Develop and enhance AI/LLM-based solutions, including RAG and agent-based applications.
- Contribute to an AI agent/RAG solution that enables users to translate Adobe Analytics requirements into SQL queries.
- Maintain and enhance the Client’s chatbot assistant, including updates, new capabilities, and ongoing performance improvements.
- Identify opportunities to leverage AI and automation to simplify data and analytics workflows.
Stakeholder & Solution Development
- Partner with business and analytics stakeholders to understand requirements and translate them into scalable technical solutions.
- Contribute to solution design, technical discussions, and roadmap development.
- Clearly communicate complex technical concepts and solutions to non-technical stakeholders.
Required Skills & Experience
- Strong hands-on experience in Data Engineering with SQL and PySpark.
- Experience with SQL Server, SSAS, Airflow, and modern data platforms.
- Experience working with Iceberg and cloud/container-based environments such as ECS.
- Strong understanding of data modeling, ETL/ELT, data pipelines, and data quality.
- Experience with Adobe Analytics or similar digital analytics platforms.
- Exposure to AI/LLM solutions, RAG, AI agents, or Generative AI applications.
- Strong problem-solving and troubleshooting skills.
- Ability to work independently and manage multiple production-critical data assets.
Preferred Skills
- Experience building RAG/agentic AI applications using LLMs.
- Experience converting business/analytics requirements into SQL and data solutions.
- Experience with APIs, Python, and cloud technologies.
- Experience developing stakeholder-facing analytics or AI solutions.
- Strong communication and stakeholder management skills.
Location:
DGS India - Bengaluru - Manyata N1 BlockBrand:
MerkleTime Type:
Full timeContract Type:
PermanentSkills Required
- Strong hands-on data engineering experience with SQL and PySpark
- Experience with SQL Server, SSAS, Airflow, and modern data platforms
- Experience with Iceberg and cloud or container-based environments such as ECS
- Strong understanding of data modeling, ETL/ELT, data pipelines, and data quality
- Experience with Adobe Analytics or similar digital analytics platforms
- Exposure to AI/LLM solutions, RAG, AI agents, or generative AI applications
- Strong problem-solving and troubleshooting skills
- Ability to work independently and manage multiple production-critical data assets
- Experience building RAG or agentic AI applications using LLMs
- Experience translating business or analytics requirements into SQL and data solutions
- Experience with APIs, Python, and cloud technologies
- Experience developing stakeholder-facing analytics or AI solutions
- Strong communication and stakeholder management skills
What We Do
Dentsu Creative is a global creative agency network designed to unlock exponential growth for clients. We use Transformative Creativity as a differentiating, driving force to bring our capabilities together to positively impact people, business and society. Established in 2022, Dentsu Creative is integrated with dentsu’s Media and CXM businesses in over 145 countries and regions, to offer Integrated Growth Solutions.
