Tech Lead – Data Lake Platform at NeoGenCode Technologies Pvt Ltd · Gurugram · 5 - 12 years · ₹8L - ₹16L / yr · Raised funding · Posted 28 Oct 2026

Tech Lead – Data Lake Platform
Recruitment & Payroll Company: Neogencode Technologies
Job Location: Sector 43, Gurugram, Haryana
Work Mode: On-site (Work from Office)
Working Days: 5 days a week
Experience Required: 5+ years
Employment Type: Full-time
About the Opportunity
We are hiring a Tech Lead – Data Lake Platform. This opportunity involves working on an enterprise-grade AWS data lake platform supporting data engineering, analytics, reporting, and business applications.
The candidate will be employed on the payroll of Neogencode Technologies and will work at the client location in Sector 43, Gurugram.
Key Responsibilities
- Own and design end-to-end data lake architecture, including data ingestion, staging, curated layers, and data consumption.
- Lead data engineering pipelines using AWS services, Apache Airflow, Spark/PySpark, and dbt.
- Manage AWS data services such as S3, EMR, Glue, Athena, Redshift, Lambda, RDS, IAM, and DMS.
- Design and support API/data-serving solutions using PostgreSQL, Hasura GraphQL, or similar technologies.
- Improve pipeline performance, platform reliability, monitoring, and service-level agreements (SLAs).
- Ensure data security, access control, personally identifiable information (PII) protection, and governance.
- Mentor data engineers, conduct code reviews, and handle production incidents and root-cause analysis.
- Collaborate with business and application teams to deliver data and reporting solutions.
Required Skills
- 5+ years of experience in data engineering or platform engineering, including technical leadership.
- Strong hands-on experience with AWS data services and enterprise data lake architecture.
- Production experience with Apache Airflow, Spark/PySpark, and SQL.
- Strong understanding of data modeling and layered data architecture.
- Experience with PostgreSQL and Hasura GraphQL or a similar API/data-serving layer.
- Proven experience in technical leadership, production support, and troubleshooting.
Good to Have
- Experience with dbt and lakehouse table formats.
- Knowledge of Kafka or streaming data ingestion.
- Experience with Redshift optimization and workload design.

About NeoGenCode Technologies Pvt Ltd
About
Welcome to Neogencode Technologies, an IT services and consulting firm that provides innovative solutions to help businesses achieve their goals. Our team of experienced professionals is committed to providing tailored services to meet the specific needs of each client. Our comprehensive range of services includes software development, web design and development, mobile app development, cloud computing, cybersecurity, digital marketing, and skilled resource acquisition. We specialize in helping our clients find the right skilled resources to meet their unique business needs. At Neogencode Technologies, we prioritize communication and collaboration with our clients, striving to understand their unique challenges and provide customized solutions that exceed their expectations. We value long-term partnerships with our clients and are committed to delivering exceptional service at every stage of the engagement. Whether you are a small business looking to improve your processes or a large enterprise seeking to stay ahead of the competition, Neogencode Technologies has the expertise and experience to help you succeed. Contact us today to learn more about how we can support your business growth and provide skilled resources to meet your business needs.
Candid answers by the company
IT & Engineering Talent Staffing
- Provides full-time and contract-based hiring, delivering handpicked, pre‑screened developers across tech stacks—ranging from web, mobile, AI/ML, Web3/blockchain.
- Maintains a bench o vetted candidates, offering fast delivery of interview-ready profiles—often within 24 hours.
- Offers payroll management, handling compliance, tax, attendance, and documentation for both contractors and full-time employees.
2. End-to-End Project Delivery
- Delivers full-stack development solutions: web, mobile, cloud, AI/ML, Blockchain/Web3.
- Manages entire project lifecycle—requirements gathering, design (UI/UX), development, deployment, and ongoing support .
3. Additional Offerings
- Expands into cybersecurity consulting, digital marketing, and cloud platform services (like AWS, GCP, Azure) .
- Provides strategic IT consulting to align technology solutions with business objectives
Similar jobs (10)
Job Title : Tech Lead – Data Lake Platform
Number of Positions : 2
Experience : 7+ Years
Role Type : Technical Lead / Data Platform Lead
Domain : Data Engineering / Data Platform / AWS
About the Role :
We are looking for an experienced Tech Lead – Data Lake Platform to lead the design, development, and operations of an enterprise-scale AWS-based Data Lake Platform.
The platform will ingest data from multiple business systems, process it through structured data layers, and serve data for analytics, reporting, APIs, and operational applications.
As a Tech Lead, you will be responsible for setting the technical direction, leading data engineering teams, driving platform reliability and performance, and owning the platform's delivery, governance, and production support end to end.
Core Tech Stack :
AWS | S3 | EMR | Glue | Athena | Redshift | DMS | Lambda | RDS | IAM | Airflow | Spark/PySpark | SQL | Data Modeling | Hasura | GraphQL | DBT | PostgreSQL/Aurora | Kafka
Key Responsibilities :
- Own the overall Data Lake Platform architecture, covering data ingestion, staging, curated layers, consumption, analytics, and API/data serving.
- Lead the design and development of production-grade data pipelines using AWS Glue, EMR/Spark, Airflow, DBT, Athena, and Redshift.
- Design scalable batch and analytics pipelines with a focus on reliability, performance, data quality, and maintainability.
- Own the API/data-serving architecture from consumption data → RDS/PostgreSQL → Hasura GraphQL → Lambda/API Gateway.
- Drive improvements in platform stability, including orchestration failures, cluster sizing, pipeline SLAs, query performance, and production reliability.
- Design and implement appropriate AWS security, access control, IAM, PII handling, and data governance practices.
- Lead technical discussions, architecture decisions, code reviews, and engineering best practices.
- Mentor and guide data engineers while ensuring high-quality and scalable engineering delivery.
- Own production support, incident management, troubleshooting, and root-cause analysis (RCA) for critical data platform issues.
- Develop and maintain runbooks, operational procedures, monitoring, and incident response practices.
- Collaborate with business, product, application, and analytics teams to onboard new datasets and support reporting, API, and data consumption requirements.
- Ensure the platform meets defined availability, performance, security, data quality, and compliance requirements.
Must-Have Skills :
- 7+ years of experience in Data Engineering, Data Platform Engineering, or related areas, including experience in technical leadership or architecture.
- Strong hands-on experience with AWS Data Services, including:
- Amazon S3
- AWS EMR
- AWS Glue
- Amazon Athena
- Amazon Redshift
- AWS DMS
- AWS Lambda
- Amazon RDS
- AWS IAM
- Strong production experience with Apache Airflow.
- Strong hands-on experience with Apache Spark / PySpark.
- Strong SQL skills and experience with data modeling, including layered data architecture, data marts, and enterprise data models.
- Experience with Hasura or a similar GraphQL layer for PostgreSQL-based data/API serving.
- Strong understanding of data lake architecture and enterprise data platforms.
- Proven experience leading engineers and driving technical decisions.
- Hands-on experience with production support, troubleshooting, incident management, and RCA.
- Strong understanding of data platform performance, scalability, reliability, and SLA management.
Good-to-Have Skills :
- Experience with DBT and modern data transformation practices.
- Experience with lakehouse table formats on Amazon S3, such as Apache Iceberg or similar technologies.
- Strong knowledge of Amazon Redshift workload optimization, including :
- Distribution keys
- Sort keys
- Spectrum
- External tables
- Experience with Kafka or other streaming/data ingestion technologies.
- Experience with PostgreSQL / Amazon Aurora as a data-serving layer.
- Experience with Lambda and API Gateway for API-based data serving.
- Experience with enterprise data governance, data quality, security, and compliance.
- Experience in BFSI / Banking / Financial Services / Insurance domain.
Ideal Candidate :
The ideal candidate is a hands-on Data Platform / Data Engineering Lead who can operate at both the architecture and implementation level. You should be comfortable designing an AWS Data Lake from end to end, leading engineers, troubleshooting production issues, and working closely with business and application teams to deliver reliable data products.
🚀 Job Title : Data Engineer – AWS, PySpark & Airflow
Experience : 5+ Years
Industry : Health Insurance / BFSI
Location : Sector 43, Gurugram, Haryana
Work Mode : Work From Office (5 Days a Week)
Employment Type : Full-Time
Role Overview :
We are looking for an experienced Data Engineer with strong hands-on expertise in AWS Data Engineering, Data Lake Architecture, Python, SQL, PySpark, and Apache Airflow.
The candidate will be responsible for designing, developing, and maintaining scalable, reliable, and high-performance data pipelines using AWS cloud technologies. The role involves building end-to-end ETL / ELT workflows, implementing data transformation and processing solutions, optimizing pipeline performance, and ensuring the reliability of production data systems.
Mandatory Skills :
AWS Data Engineering | Data Lake Architecture | Amazon S3 | AWS Glue | Amazon EMR | Athena | Redshift | Python | SQL | PySpark | Apache Spark | Apache Airflow | ETL/ELT | PostgreSQL | Data Modelling | Pipeline Optimization | Production Support | Root Cause Analysis
Key Responsibilities :
- Design, develop, and maintain end-to-end data pipelines for data ingestion, staging, transformation, curation, and consumption.
- Build and manage AWS-based data lake solutions using Amazon S3, AWS Glue, Amazon EMR, Athena, and Redshift.
- Develop, maintain, and optimize ETL / ELT pipelines using Python, SQL, Apache Spark, and PySpark.
- Implement and manage workflow orchestration using Apache Airflow, including scheduling, dependency management, retries, monitoring, and failure handling.
- Integrate data from multiple structured and semi-structured sources.
- Design and maintain data models, dimensional models, and analytical data marts.
- Work with relational databases, including PostgreSQL and Amazon RDS.
- Optimize Spark jobs, SQL queries, data transformations, and cloud resource utilization.
- Implement data quality checks, validation rules, and error-handling mechanisms.
- Monitor production data pipelines, troubleshoot failures, and perform root cause analysis (RCA).
- Ensure pipeline reliability, scalability, performance, and compliance with service-level agreements (SLAs).
- Follow data security, access management, governance, and sensitive-data protection best practices.
- Collaborate with business, analytics, and application teams to deliver effective data solutions.
- Maintain technical documentation and follow established data engineering standards.
Required Technical Skills :
- AWS Data Engineering : Strong hands-on experience with AWS-based data engineering and data lake architecture.
- AWS Services : Amazon S3, AWS Glue, Glue Data Catalog, Amazon EMR, Athena, Redshift, AWS Lambda, and IAM.
- Programming : Strong proficiency in Python and SQL.
- Big Data Processing : Hands-on experience with Apache Spark and PySpark.
- Workflow Orchestration : Experience developing and managing workflows using Apache Airflow.
- ETL/ELT Development : Experience building scalable data ingestion, transformation, and processing pipelines.
- Database Technologies : Good understanding of relational databases and PostgreSQL concepts.
- Data Modelling : Experience with data modelling, data transformation, and analytical data structures.
- Production Support : Ability to monitor pipelines, troubleshoot failures, perform RCA, and resolve production issues.
- Performance Optimization : Experience optimizing SQL queries, Spark jobs, and data processing workflows.
Good-to-Have Skills :
- Experience with AWS Database Migration Service (DMS) and Amazon RDS.
- Familiarity with dbt for data transformation and modelling.
- Knowledge of Delta Lake, Apache Iceberg, or Apache Hudi.
- Exposure to Apache Kafka and real-time data streaming.
- Familiarity with GraphQL, Hasura, or similar data-serving technologies.
- Understanding of data governance and data quality frameworks.
- Experience in the BFSI, healthcare, or health insurance domain.
Candidate Requirements :
- 5+ years of relevant experience in Data Engineering.
- Proven hands-on experience building and maintaining production-grade data pipelines on AWS.
- Strong understanding of data lake architecture and large-scale data processing.
- Practical experience with Apache Airflow and Spark / PySpark-based transformations.
- Strong programming, analytical, debugging, and problem-solving skills.
- Experience handling production incidents, pipeline failures, and performance bottlenecks.
- Ability to take ownership of deliverables and work effectively with cross-functional teams.
- Good communication, collaboration, and technical documentation skills.
- Willingness to work from the Gurugram office five days a week.
Ideal Candidate :
The ideal candidate is a hands-on Data Engineer who can independently build, optimize, and maintain AWS-based data pipelines, work with large datasets using PySpark, orchestrate workflows through Airflow, and resolve production issues in a business-critical environment.
Job Title : Senior AWS Data Engineer – Data Lake Platform
Experience : 5+ Years
Location: Gurugram Sector 43, Haryana
Work Mode : Work From Office (5 Days a Week – Monday to Friday)
Open Positions : 8+
About the Role :
We are looking for a skilled Senior AWS Data Engineer with strong hands-on experience in building, managing, and optimizing enterprise-scale data lake platforms on AWS.
The ideal candidate will have expertise in AWS data services, PySpark, Apache Airflow, and large-scale data pipeline development. The role involves designing end-to-end data ingestion and processing workflows, maintaining data quality, optimizing platform performance, and supporting analytics and downstream data consumption requirements.
Mandatory skills :
AWS Data Lake, Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, IAM, PySpark, Apache Spark, Apache Airflow, Python, Advanced SQL, Data Modeling, Production Data Pipelines, Hasura/GraphQL, PostgreSQL, and Production Support.
Key Responsibilities :
- Design, develop, and maintain scalable AWS-based data lake platforms and end-to-end data pipelines.
- Build data ingestion, staging, transformation, curated, and consumption layers using AWS services.
- Develop and optimize data processing pipelines using PySpark, Apache Spark, and AWS EMR.
- Implement workflow orchestration and scheduling using Apache Airflow.
- Work with Amazon S3, AWS Glue, Glue Data Catalog, Amazon Athena, and Amazon Redshift for data storage, cataloging, processing, and analytics.
- Develop efficient SQL queries and implement data modeling strategies for enterprise reporting and analytics.
- Build and support data-serving solutions using Amazon RDS, AWS Lambda, API Gateway, and PostgreSQL-based platforms.
- Monitor pipeline performance, troubleshoot production issues, perform root-cause analysis, and ensure data pipeline SLAs.
- Implement data security, access controls, PII protection, and governance best practices across the platform.
- Optimize data processing performance, query execution, storage utilization, and AWS infrastructure costs.
- Collaborate with application, analytics, and business teams to deliver reliable and scalable data solutions.
Mandatory Skills :
- AWS Data Services : Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, and IAM.
- Data Engineering : Strong hands-on experience building and maintaining enterprise data lake platforms.
- Programming : Python, PySpark, and Apache Spark.
- Orchestration : Production experience with Apache Airflow.
- Database & SQL : Advanced SQL, data modeling, and query optimization.
- Data Architecture : Experience with data ingestion, staging, transformation, curated layers, and consumption architecture.
- Production Support : Pipeline monitoring, troubleshooting, root-cause analysis, and SLA management.
- API / Data Serving : Experience with Hasura or a similar GraphQL-based data-serving layer integrated with PostgreSQL.
- Platform Ownership : Ability to independently manage data pipelines, improve platform reliability, and collaborate with cross-functional teams.
Good-to-Have Skills :
- Experience with dbt for data transformation and modeling.
- Knowledge of data lakehouse architectures and table formats such as Apache Iceberg, Delta Lake, or Apache Hudi.
- Experience with Amazon Redshift workload optimization, distribution keys, sort keys, and Spectrum.
- Knowledge of Kafka and real-time or streaming data ingestion.
- Experience with PostgreSQL or Amazon Aurora as a data-serving layer.
- Familiarity with data governance, compliance, and sensitive-data management.
- Experience in the BFSI or health insurance domain.
Ideal Candidate Profile :
- 5+ years of hands-on experience in AWS Data Engineering.
- Strong experience building and supporting production-grade AWS data lake platforms.
- Practical expertise in PySpark, Apache Airflow, SQL, and AWS data services.
- Ability to troubleshoot complex data pipeline issues and optimize performance.
- Strong understanding of data architecture, data modeling, and production support practices.
- Candidates with experience in enterprise data platforms and insurance or BFSI environments will be preferred.
About the Role
We are looking for a Senior Data Engineer with strong hands-on expertise in Databricks, Python, PySpark, and SQL to build scalable, high-performance data engineering solutions. You’ll architect and develop large scale, high-performance data pipelines capable of handling massive real-time and batch data volumes across multiple business systems. Databricks is the core enterprise data and processing platform for this role. You will also use Apache Airflow for workflow orchestration and dbt for ELT transformations, and will contribute to designing reliable, secure, and governed data platforms that enable analytics, reporting, and AI-driven use cases.
Key Responsibilities
- Design and implement large-scale data pipelines using Python/PySpark, Databricks, and Microsoft Fabric.
- Develop and optimize data processing workloads in Databricks using PySpark and Spark SQL, with a strong focus on scalability, reliability, performance, and maintainability.
- Develop and maintain dbt models including layered architecture, incremental models, snapshots, macros, testing, and documentation.
- Design, develop, and maintain Apache Airflow DAGs for orchestrating reliable, scalable, and observable data pipelines.
- Design and implement data quality, observability, and governance frameworks, including automated testing, monitoring, lineage, access control, and data privacy standards.
- Partner with analytics, product, and business stakeholders to turn requirements into trustworthy datasets, and raise the engineering bar through design discussions, code reviews, and mentoring junior engineers.
Required Skills
- Strong expertise in Python for developing scalable, modular, and production-ready data engineering applications.
- Strong expertise in PySpark, including DataFrame API, Spark SQL, Structured Streaming, partitioning strategies, joins, caching, handling data skew, and Spark performance optimization.
- Strong hands-on experience with Databricks for data ingestion, transformation, processing, and optimization, including Delta Lake, Unity Catalog, Databricks Workflows, notebooks, jobs, and Databricks-native data engineering capabilities.
- Strong experience in Databricks/Spark performance tuning, including query and job optimization, partitioning, file sizing, caching, join optimization, handling data skew, and efficient use of compute resources.
- Hands-on experience with Delta Lake, including transactional data processing, schema management, incremental data processing, and reliable batch and streaming data pipelines.
- Hands-on experience in developing dbt projects using layered architecture, incremental models, snapshots, macros/Jinja, testing, documentation, and deployment best practices.
- Expertise in advanced SQL and data modelling — dimensional modeling, slowly changing dimensions, schema evolution, and query optimization.
- Hands-on experience in developing and managing Apache Airflow DAGs, scheduling workflows, dependency management, retries, backfills, and operational monitoring.
- Hands-on experience with at least one major cloud platform (AWS, Azure or GCP).
- Strong problem-solving skills and the ability to work independently with business and analytics stakeholders.
Nice to Have
- Hands-on exposure to Microsoft Fabric for data integration and analytics.
- Experience using AI coding assistants (e.g. Claude Code, GitHub Copilot) as part of a development workflow.
- Familiarity with modern DevOps practices, including CI/CD pipelines, Infrastructure as Code (IaC), and containerization (Docker/Kubernetes).
- Domain expertise in financial services.
Description
We are looking for Senior Data Engineers to join our Data Platform team and build scalable, high-performance data platforms that power data processing, analytics, and downstream applications.
The ideal candidate will have strong experience in distributed data processing, ETL pipelines, and Big Data technologies, with hands-on expertise in Apache Spark and Python Scala.
You will be responsible for designing, developing, and optimizing large-scale data pipelines while collaborating closely with cross-functional engineering teams to build reliable, production-grade data solutions.
Key Responsibilities
- Design, develop, and maintain scalable ETL and data processing pipelines for large-scale datasets.
- Build and optimize distributed data applications using Apache Spark and Python Scala.
- Develop reliable, high-performance data pipelines for batch and streaming workloads.
- Design and manage data workflows using Apache Airflow.
- Build and operate data workloads on AWS, with strong usage of Amazon S3 for large-scale data storage.
- Work with large datasets to ensure data quality, consistency, reliability, and performance.
- Collaborate with engineering, product, analytics, and other platform teams to deliver robust data solutions.
- Optimize data workflows for scalability, reliability, performance, and cost efficiency.
- Troubleshoot production issues, identify bottlenecks, and continuously improve platform performance.
Requirements
Candidates who demonstrate:
- 5+ years of experience in Data Engineering, Big Data Engineering, or a similar role.
- Strong hands-on experience with Apache Spark and Scala.
- Experience designing, building, and maintaining large-scale ETL pipelines.
- Strong hands-on experience with AWS, particularly Amazon S3.
- Hands-on experience with Apache Airflow for workflow orchestration and scheduling.
- Strong SQL skills and a solid understanding of distributed data processing concepts.
- Experience working with batch and/or streaming data pipelines.
- Excellent debugging, problem-solving, and performance optimization skills.
- Strong communication and collaboration skills.
Good to Have
- Experience with Databricks and the broader Databricks data platform.
- Familiarity with streaming technologies such as Apache Kafka.
- Experience working on large-scale data platforms handling high-volume data workloads.
- Exposure to additional AWS data services and cloud-native data architectures.
Job Title : AWS Data Engineer
Experience : 4+ Years
Location : Bengaluru (HSR – Hybrid, 3 Days WFO)
Notice Period : Immediate Joiner
💡 Role Overview :
We are looking for a skilled AWS Data Engineer to design, build, and scale modern data platforms. The role involves working with AWS-native services, Python, Spark, and DBT to deliver secure, scalable, and high-performance data solutions in an Agile environment.
🔥 Mandatory Skills :
Python, SQL, Spark, AWS (S3, Glue, EMR, Redshift, Athena, Lambda), DBT, ETL/ELT pipeline development, Airflow/Step Functions, Data Lake (Parquet/ORC/Iceberg), Terraform & CI/CD, Data Governance & Security
🚀 Key Responsibilities :
- Design, build, and optimize ETL/ELT pipelines using Python, DBT, and AWS services
- Develop and manage scalable data lakes on S3 using formats like Parquet, ORC, and Iceberg
- Build end-to-end data solutions using Glue, EMR, Lambda, Redshift, and Athena
- Implement data governance, security, and metadata management using Glue Data Catalog, Lake Formation, IAM, and KMS
- Orchestrate workflows using Airflow, Step Functions, or AWS-native tools
- Ensure reliability and automation via CloudWatch, CloudTrail, CodePipeline, and Terraform
- Collaborate with data analysts and data scientists to deliver actionable insights
- Work in an Agile environment to deliver high-quality data solutions
✅ Mandatory Skills :
- Strong Python (including AWS SDKs), SQL, Spark
- Hands-on experience with AWS data stack (S3, Glue, EMR, Redshift, Athena, Lambda)
- Experience with DBT and ETL/ELT pipeline development
- Workflow orchestration using Airflow / Step Functions
- Knowledge of data lake formats (Parquet, ORC, Iceberg)
- Exposure to DevOps practices (Terraform, CI/CD)
- Strong understanding of data governance and security best practices
- Minimum 4–7 years in Data Engineering (3+ years on AWS)
➕ Good to Have :
- Understanding of Data Mesh architecture
- Experience with platforms like Data.World
- Exposure to Hadoop / HDFS ecosystems
🤝 What We’re Looking For :
- Strong problem-solving and analytical skills
- Ability to work in a collaborative, cross-functional environment
- Good communication and stakeholder management skills
- Self-driven and adaptable to fast-paced environments
📝 Interview Process :
- Online Assessment
- Technical Interview
- Fitment Round
- Client Round
Job Summary
We are looking for an experienced Data Engineer to build and optimize scalable data pipelines and AWS-based data platforms.
Key Responsibilities
- Develop and maintain data pipelines using Python and PySpark.
- Design and implement data lakehouse solutions on AWS.
- Build and manage data workflows using AWS Glue, EMR, ECS, and Step Functions.
- Work with DynamoDB and other data storage technologies.
- Monitor data pipelines and ensure data quality, performance, and reliability.
- Collaborate with stakeholders and engineering teams to deliver data solutions.
Mandatory Skills
- 5+ years of overall professional experience.
- 3+ years of experience in data platforms and big data technologies.
- Strong proficiency in Python and PySpark.
- Hands-on experience with AWS EMR, ECS, Glue, Step Functions, and DynamoDB.
- Experience designing and implementing AWS data lakehouse architectures.
Good to Have
- Apache Spark and Apache Iceberg.
- AWS Lambda, EventBridge, Kinesis, and Redshift.
- Experience with real-time data pipelines and event-driven architectures.
Data Architect – Databricks & AWS
- Strong experience in Data Architecture, Data Engineering, Databricks, Apache Spark/PySpark, Python, and Advanced SQL.
- Design and implement scalable ETL/ELT pipelines, data platforms, and Lakehouse architectures using Medallion Architecture.
- Experience with Databricks, Databricks Workflows, Unity Catalog OR Databricks Jobs
- Strong knowledge of Delta Lake, Databricks Workflows, Delta Live Tables (DLT), and dimensional data modeling.
- Hands-on experience with AWS services such as S3, Glue, IAM, Lambda, and CloudWatch.
- Experience with Apache Airflow, Data Warehouse concepts, Git/CI-CD, performance optimization, and data quality.
- Good to have exposure to Kafka/Structured Streaming, Unity Catalog, and modern data governance.
Sr. Data Engineer
Location: Pune
Responsibilities
· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices.
· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources.
· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling.
· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights.
· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues.
· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards.
· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components.
· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement.
· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability.
· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience.
· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency.
· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders.
· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward.
Qualifications
· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms.
· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development.
· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development.
· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion.
· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets.
· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition.
· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent.
· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git).
· Familiarity with dbt or similar transformation tools and best practices for modular transformation development.
· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus.
· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders.
Education
Bachelor’s or Master’s degree in Computer Science/Information technology or related field.
Equivalent academic and work experience can be considered.
1. Company Description:
Tatvic, is a marketing analytics company focusing on generating insights from data using long association with Google & its infrastructure. We breed,recognize and reward performance. As a company we are growing very fast & we are under transformation. To enable this transformation we need future leaders with eyesight which balances execution & strategic understanding.
Website: www.tatvic.com
2. Role Details
- Role: Lead Data Engineer
- Band: L4
- Department: Data Engineering
- Reporting to: L5 / Head of Delivery
- Location: Ahmedabad
- Job Type: Full Time
- Experience: 6-8 years of relevant experience
- Education: Bachelor’s or Master’s degree in Computer Science, Data Science, or a related technical field.
3. Mission & Role Overview
- Mission: To create high-level organizational impact by leading a team to design and deliver scalable, high-performance cloud-native data solutions. The Lead Data Engineer (L4) is responsible for ensuring technical excellence—specifically in BigQuery optimization and secure GCP/AWS architectures—while driving the transition to Agentic AI workflows and creating value through the development of L1-L3 engineers.
- Role Overview: This is a pivotal leadership role on the Management Track, responsible for end-to-end data outcomes for the function. The Lead Engineer ensures the quality of engineering execution, manages team utilization and resource allocation, and serves as the primary technical representative in cross-functional forums with Marketing, Strategy, and Product teams.
4. Key Responsibilities
- Lead the design, development, and deployment of scalable and efficient cloud-based data pipelines and architectures.
- Build reusable data solutions and software components that serve multiple customers and use cases.
- Architect cloud environments using GCP, ensuring best practices in IAM, Security, and Networking.
- Conduct Exploratory Data Analysis (EDA) on clickstream and behavioral datasets to derive insights.
- Manage end-to-end ETL processes, including data extraction, transformation, and loading using Python, SQL, and Airflow.
- Design and build production-grade software (APIs, services, internal tools) with sound engineering practices — version control, testing, CI/CD, and code review.
- Extend data platforms with AI capabilities — integrating LLMs, RAG pipelines, and agentic workflows where they add clear business value.
- Perform Root Cause Analysis (RCA) and resolve data quality, pipeline, or application issues.
- Collaborate cross-functionally with Marketing, Insights, Product, and Engineering teams to align data initiatives with business goals.
- Document architectures, design decisions, and operations clearly and consistently.
- Coach and mentor team members, ensuring technical excellence and continuous learning.
- Participate in recruitment and knowledge-sharing through interviews, blogs, and webinars.
5. Must-Have & Good-to-Have Skills
Must-Have Skills:
- Strong understanding of clickstream data and data pipeline architecture
- Hands-on experience with cloud platforms (GCP)
- Expertise in SQL, Python, and Airflow
- Solid software engineering foundation — API design, testing, version control, and deployment practices
- Proven ability to perform exploratory data analysis and data validation
- Knowledge of cloud security, IAM, and networking best practices
- Working knowledge of building or integrating AI/LLM-based components into existing systems
- Excellent problem-solving, stakeholder management, and communication skills
Good-to-Have Skills:
- Certifications such as: Google Cloud Professional Data Engineer / Cloud Architect
- AWS Certified Data Analytics or Azure Data Engineer Associate
- Google Analytics 4 (GAIQ)
- Experience in marketing attribution, commerce data, or analytics ecosystems
- Exposure to cost optimization and cloud resource management
- Experience with agent frameworks (LangChain, ADK, MCP) or LLM APIs
- Experience building automation frameworks or internal data tools
6. Not-a-Fit Criteria
- Individual Contributor Focus: Operates as the team's best individual contributor instead of building team capability or empowering L3s.
- Information Hoarding: Keeps architectural patterns or tribal knowledge trapped in their head rather than creating reusable playbooks and documentation.
- Avoidance of Conflict: Avoids difficult performance conversations with underperforming team members, allowing capability gaps to persist.
- Activity Over Outcomes: Measures success by "tasks completed" rather than pipeline stability, data accuracy, or business impact.
- Functional Siloing: Fails to build partnerships with Marketing or Product teams, leading to misaligned data delivery.
Our Culture & Perks - Where Passion Meets Purpose:
- Competitive CTC: Based on experience and skillset
- Medical Insurance for you and your family
- Return-to-Work Program for New Moms — because career breaks shouldn’t break momentum
- 1 Work From Home Day/Month — flexibility when life calls
- 2 Birthday Leaves/Year — one for you, one for someone you love
- Monthly Engagement Activities — from game nights to learning sessions
- Inclusive Culture & Equal Opportunity Employer — diversity drives our innovation
- We Think Like Engineers & Athletes: we build, we iterate, we scale, we win — together
- 5-day workweek — because balance drives brilliance










