Team Lead – Data Engineering & Analytics

Posted 2 Months Ago
Be an Early Applicant
Mumbai, Maharashtra, IND
In-Office
Mid level
Edtech
The Role
Lead a team responsible for the organization’s centralized data architecture, databases, integrations, automation workflows, data pipelines, reporting, and AI-assisted systems. Design scalable data models, optimize SQL, build reliable pipelines using Python and orchestration tools, integrate platforms through APIs, and create trusted dashboards and KPIs. Own system reliability, documentation, monitoring, and continuous improvement while translating business needs into scalable technical solutions and mentoring team members.
Summary Generated by Built In


Work Timings: 10:15 AM – 7:15 PM
Working Days: 5 Days a Week - We Chose Balance Over the Industry Norm
Work Mode: Work from Office
Location: Marol, Mumbai

Job description

About IIDE


IIDE is India's leading digital business school, offering industry-relevant programs in digital marketing, AI, and business. With a strong focus on experiential learning, we equip students, graduates, and working professionals with the skills required to thrive in today's digital-first world.

Backed by a community of 500,000+ learners and 250+ industry experts, IIDE delivers hands-on training, real-world projects, and robust placement support. With campuses in Mumbai and Delhi, we continue to expand our presence across India and globally.


About the Role


As the Team Lead Data Engineering & Analytics at IIDE, Mumbai, you will play a pivotal role in designing, building, and managing the organisation's data infrastructure, application databases, and business intelligence ecosystem.


This is a hands-on technical leadership role that involves leading a team of data engineers and analysts while actively contributing to database architecture, ETL/ELT pipelines, business system integrations, and reporting solutions.


You will be responsible for establishing a reliable, centralised source of truth across the organisation, ensuring data accuracy, scalability, and accessibility. Working closely with cross-functional teams, you will translate business requirements into robust technical solutions that enable data-driven decision-making and operational efficiency.

You will also explore opportunities to leverage AI, machine learning, and predictive analytics to enhance business intelligence and automation.


What You'll Do

  • Database Architecture & Application Development:

Design and develop scalable relational database architectures and schemas from scratch for business applications, including LMS, CRM, ERP, and student management systems.

Define database entities, relationships, constraints, indexing strategies, and data models using PostgreSQL.

Ensure transactional integrity, data consistency, security, and optimal performance across application databases.

Collaborate with backend development teams to align database structures with application logic, APIs, and evolving business requirements.

Plan and execute database migrations, schema versioning, performance optimisation, and scalability improvements.


  • Data Engineering & System Integration:

Design, develop, and maintain robust ETL/ELT pipelines to integrate data from CRM, websites, LMS, marketing platforms, and other business systems.

Build automated data ingestion, transformation, and processing workflows using SQL, APIs, Python, and relevant integration tools.

Implement incremental data loading, data validation, deduplication, error handling, retry mechanisms, and pipeline monitoring.

Establish a centralised analytical data architecture with standardised data definitions and reliable historical records.

Optimise data pipeline performance, processing efficiency, system reliability, and infrastructure costs.


  • Reporting & Business Intelligence:

Consolidate existing reporting systems and establish standardised business metrics across departments.

Develop reliable reporting datasets, analytical data models, and dashboards using BI platforms such as Looker Studio, Power BI, or Tableau.

Collaborate with stakeholders to translate business requirements into accurate, actionable, and scalable reporting solutions.

Identify and resolve reporting discrepancies, eliminate manual reporting processes, and improve data accessibility.

Enable leadership and business teams to make informed decisions using consistent, trustworthy, and timely data.


  • Team Leadership & Stakeholder Management:

Lead, mentor, and guide data engineers and analysts while ensuring clear ownership, accountability, and timely project delivery.

Conduct technical reviews of SQL queries, database designs, data pipelines, and engineering implementations.

Establish development standards, documentation practices, quality assurance processes, and technical best practices.

Collaborate with technology, marketing, sales, finance, and academic teams to understand requirements and prioritise data initiatives.

Remain actively involved in complex technical implementations, troubleshooting, and solution design while managing team responsibilities.


  • AI & Advanced Analytics:

Identify opportunities to apply artificial intelligence, machine learning, and advanced analytics to improve business operations.

Contribute to AI-enabled data solutions, automated insights, and intelligent reporting systems.

Support predictive analytics initiatives, including lead conversion prediction, forecasting, customer segmentation, and trend analysis.

Evaluate and implement relevant AI-driven solutions that improve operational efficiency and business decision-making.


  • Additional Duties:

Establish and maintain a reliable, centralised data platform that supports seamless integration across business applications.

Continuously improve data accuracy, database performance, reporting efficiency, and overall system reliability.

Drive automation initiatives to reduce manual dependencies and enhance data engineering productivity.

Ensure the team delivers maintainable, scalable, well-documented technical solutions aligned with organisational objectives.

Perform any other reasonable duties as requested by management, aligned with the broad scope of the position.



Requirements

Who You Are

  • Must-Have:

4 - 8 years of relevant experience in data engineering, database development, analytics engineering, or related technical roles.

Strong hands-on expertise in SQL and PostgreSQL, including query optimisation and database performance management.

Proven experience designing relational database architectures for production applications, including ER modelling, normalisation, constraints, indexing, and transaction management.

Strong understanding of OLTP databases, data integrity, transactional consistency, and backend application integration.

Demonstrated experience designing, developing, and maintaining ETL/ELT pipelines and integrating multiple data sources.

Proficiency in data modelling, data warehousing concepts, data transformation, and data quality management.

Experience developing reporting datasets, consolidating business information, and standardising organisational metrics.

Previous experience leading or mentoring data engineers, analysts, or other technical team members.

Strong analytical thinking, problem-solving abilities, and the capability to independently own complex technical implementations.

Ability to collaborate effectively with technical and non-technical stakeholders while translating business requirements into scalable data solutions.


  • Should Have:

Proficiency in Python for data processing, automation, scripting, and pipeline development.

Experience working with cloud-based data warehouse platforms such as BigQuery, Snowflake, or Amazon Redshift.

Familiarity with data orchestration and transformation tools such as Apache Airflow, dbt, or Dagster.

Experience developing dashboards and business intelligence solutions using Looker Studio, Power BI, or Tableau.

Working knowledge of REST APIs, cloud infrastructure, database deployments, and system integration practices.

Experience implementing automated data validation, monitoring, and performance optimisation processes.


  • Nice to Have:

Exposure to AI/ML initiatives, LLM integrations, predictive modelling, or business forecasting solutions.

Familiarity with Spring Boot, Java, or other backend application development frameworks.

Experience supporting predictive analytics use cases such as lead scoring, customer segmentation, or conversion forecasting.

Relevant certifications or professional training in cloud platforms, database engineering, data analytics, or AI/ML technologies.

Prior experience working with education technology platforms, LMS, CRM, ERP, or student management systems.



Benefits

Why Join IIDE?

  • Work with one of India's fastest-growing digital education brands.
  • Gain exposure to end-to-end data engineering, database architecture, and business intelligence initiatives.
  • Take ownership of building and scaling the organisation's data infrastructure and centralised analytics ecosystem.
  • Lead a technically driven team while remaining hands-on with architecture, engineering, and implementation.
  • Collaborate with cross-functional teams and contribute directly to business-critical decisions and technology initiatives.
  • Explore opportunities to implement AI-enabled solutions, predictive analytics, and intelligent automation.
  • Work in a collaborative, high-growth environment that encourages innovation, ownership, and continuous learning.
  • Enjoy a five-day workweek that supports work-life balance and sustainable professional growth.

Who You'll Thrive As

You're someone who:

  • Is a hands-on technical leader who enjoys designing and building scalable data solutions as much as guiding a team.
  • Has a strong foundation in SQL, PostgreSQL, database architecture, and data engineering, with a passion for solving complex technical challenges.
  • Thinks beyond individual reports and pipelines, focusing on building reliable, integrated, and future-ready data ecosystems.
  • Takes complete ownership of technical initiatives, from understanding business requirements to architecture, implementation, and ongoing optimisation.
  • Is passionate about data accuracy, consistency, automation, and establishing a single source of truth across the organisation.
  • Can translate complex business problems into practical, scalable technical solutions that create measurable impact.
  • Enjoys mentoring team members, establishing engineering best practices, and fostering a culture of accountability and continuous improvement.
  • Communicates effectively with cross-functional stakeholders and understands how technology supports broader business objectives.
  • Is curious about emerging technologies, AI, machine learning, and predictive analytics, and actively explores opportunities to apply them.
  • Thrives in a dynamic, fast-paced environment where independent thinking, collaboration, and hands-on execution are equally valued.


Skills Required

  • 4-6 years of relevant experience in automation, data systems, analytics engineering, or related domains
  • Strong understanding of database structures, relational database fundamentals, and data modeling
  • Advanced SQL expertise with experience writing optimized production-grade queries
  • Proven experience building and managing production-grade automation systems
  • Ability to debug, refactor, and own systems end-to-end
  • Strong systems-thinking mindset focused on scalable solutions
  • Experience with Python for data processing, transformation, and validation
  • Hands-on experience with Apache Airflow, Airbyte, or similar orchestration tools
  • Exposure to cloud platforms such as GCP or AWS
  • Experience working with CRMs such as LeadSquared, Zoho, or similar platforms
  • Ability to translate business problems into structured systems and workflows
  • Practical exposure to AI-assisted workflows and intelligent automation systems
  • Experience experimenting with emerging automation and data tools
  • Strong documentation and process-improvement capabilities
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Mumbai
106 Employees
Year Founded: 2016

What We Do

IIDE is a digital-first business school focused on preparing India’s next generation of digital and business leaders. It offers digital marketing programs, undergraduate business education, and AI-focused certifications for students, graduates, working professionals, career switchers, and entrepreneurs. Through online learning and campus experiences in Mumbai, Delhi, and Nepal, IIDE combines practical, industry-led education with career and entrepreneurship outcomes.

Similar Jobs

Mastercard Logo Mastercard

Software Engineer

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Pune, Maharashtra, IND
38800 Employees
Hybrid
Mumbai, Maharashtra, IND
289097 Employees
Hybrid
Mumbai, Maharashtra, IND
289097 Employees
Hybrid
Mumbai, Maharashtra, IND
289097 Employees

Similar Companies Hiring

ReUp Education Thumbnail
Social Impact • Edtech
Austin, TX
180 Employees
Learneo Thumbnail
Software • Machine Learning • Edtech • Artificial Intelligence
NL
397 Employees
CodePath.org Thumbnail
Edtech • Social Impact
San Francisco, CA
55 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account