Description
Senior/Lead Data Engineer
Location: New Delhi, India; Delhi, India
Department: Business Analytics
Experience: 6+ years
We are looking for a Senior/Lead Data Engineer to design and build scalable, high-quality data products that power analytics, reporting, and AI use cases. You’ll play a key role in defining event modeling standards, building a trusted metrics layer, and developing modern transformation workflows using dbt. You’ll also contribute to emerging GenAI initiatives, leveraging Python and a foundational understanding of LLMs (Large Language Models).
Key Responsibilities:
Data Modeling & Analytics Enablement
- Strong experience building Analytics Data Warehouses (DWH) using dimensional modeling, including SCD (Slowly Changing Dimensions Type 1/2), incremental loading strategies, and star/snowflake schema design.
- Design and implement scalable event data models that support product analytics and behavioral insights.
- Develop and maintain a governed metrics layer (definitions, calculation logic, validation, and documentation).
- Build and optimize a semantic layer that enables consistent reporting across BI tools and downstream consumers.
- Partner with Sales, Marketing, Support, Product, and Engineering teams to define reliable, reusable datasets and business logic.
dbt & Transformation Development
- Build and maintain transformation pipelines using dbt, including:
o modular models, sources, and documentation
o data tests (generic + custom)
o incremental models and performance tuning
- Establish best practices around branching, deployment, and CI/CD for dbt projects.
Data Platform & Quality
- Ensure high data quality through proactive testing, observability, and monitoring.
- Improve dataset reliability and maintainability through naming conventions, contracts, and lineage management.
- Troubleshoot pipeline issues and resolve data inconsistencies quickly and effectively.
GenAI & LLM Support
- Support integration of data with LLM-based applications (e.g., data narrator, metadata generation, dataset summarization, etc.).
- Apply a basic understanding of LLM concepts such as embeddings, prompts, vector search, and token limits to guide data design.
Python Development
- Build utilities, automation scripts, and data workflows using Python.
- Use Python for validation frameworks, pipeline tooling, and integration across systems.
Required Qualifications:
- 6+ years of experience in Data Engineering or similar roles.
- Strong experience in data warehousing.
- Strong experience with event modeling (product events, behavioral data).
- Proven ability to build and manage a metrics layer and semantic layer for consistent analytics.
- Hands-on expertise with dbt for building production-grade transformation models.
- Strong Python skills for data engineering workflows and automation.
- Familiarity with GenAI concepts and modern AI/data workflows.
- Basic understanding of LLMs, including how data is used in LLM applications.
- Strong SQL skills and experience working with modern data warehouses (Snowflake/BigQuery/Redshift or similar).
- Excellent communication skills and ability to collaborate with cross-functional stakeholders.
Preferred Qualifications (Nice to Have)
- Experience building a semantic layer tool (e.g., dbt Semantic Layer, Cube, MetricFlow, etc.).
- Experience with data orchestration tools (Airflow, Dagster, Prefect).
- Familiarity with data observability tools (OpenMetaData, Monte Carlo, Datadog, etc.).
- Experience supporting ML features, embeddings pipelines, or vector databases.
- Experience working in product analytics ecosystems (Segment, Mixpanel, etc.).
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say