Assistant Lead - Automation, Data & Intelligent Systems

IIDE; Mumbai; On-site; INR 180,000 - 270,000; Full time

Job summary

IIDE in Mumbai is seeking an Assistant Lead - Automation, Data & Intelligent Systems to build scalable data systems, automation workflows, and reporting pipelines while leading a small team.

This hands-on leadership role focuses on data integrity, operational efficiency, and long-term scalability, collaborating with business units to convert repetitive processes into reliable automated solutions and to deliver clear leadership dashboards.

Qualifications

• 4-6 years of relevant experience in automation, data systems, analytics engineering, or related domains.
• Strong understanding of database structures, relational data modeling, and data normalization.
• Advanced SQL expertise with production-grade query optimization.
• Proven experience building and managing production-grade automation systems.

Responsibilities

• Design and maintain scalable database structures serving as the single source of truth.
• Develop end-to-end automation workflows across departments.
• Build dashboards for leadership and cross-functional teams.
• Lead and mentor a small team of 2-3 members.
• Collaborate with business teams to automate repetitive processes and improve data integrity.

Skills

Automation

Data systems

SQL

Python

Airflow

Airbyte

GCP/AWS

Leadership

Team management

Tools

PostgreSQL

MySQL

BigQuery

n8n

Make.com

Google Apps Script

Apache Airflow

Airbyte

Python

APIs

Job description

Working Days: Monday to Saturday (2nd, 4th & 5th Saturdays off)

Work Mode: Work From Office

Location: Mumbai (Lower Parel; occasional Andheri campus visits)

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 Assistant Lead - Automation, Data & Intelligent Systems at Mumbai, you will play a pivotal role in building scalable data systems, automation workflows, and reporting pipelines while leading a small team of 2-3 members. This is a hands-on leadership role for someone who thinks in systems, data models, and leverage - not just tools or tasks.

You will work closely with business teams to identify inefficient or repetitive processes and convert them into reliable automated systems, with a strong emphasis on data integrity, operational efficiency, and long-term scalability. You will also collaborate cross-functional to ensure robust reporting, intelligent workflows, and seamless system orchestration.

What You’ll Do:

Database & Data Architecture (Core Focus):

• Design and maintain clean, scalable database structures that act as the single source of truth.
• Make architectural decisions around data normalization, identifiers, and historical vs. current data management.
• Ensure data consistency, integrity, and reliability across systems.
• Write and optimize advanced SQL queries for operational and analytical use cases.
• Work with databases such as PostgreSQL, MySQL, BigQuery, or similar platforms.
• Design, build, and own end-to-end automation workflows across departments.
• Identify repetitive, monotonous, or error-prone processes and eliminate them through automation.
• Use tools such as n8n, Make.com, Google Apps Script, or equivalent automation platforms.
• Implement error handling, retries, monitoring, and alert systems.
• Continuously refactor and improve automations as systems scale.
• Build and manage data pipelines using tools such as Apache Airflow, Airbyte, or similar orchestration tools.
• Use Python for data transformation, validation, and processing.
• Integrate systems using APIs and webhooks.
• Optimize pipelines for performance, reliability, and cost efficiency.
• Build clear, decision-ready dashboards for leadership and cross-functional teams.
• Translate ambiguous business requirements into clear metrics and KPIs.
• Ensure reporting logic is transparent, accurate, and trusted.
• Identify and resolve root-cause data issues instead of surface-level dashboard fixes.
• Identify opportunities where AI can enhance automation and decision-making (e.g., classification, summarization, prediction, routing).
• Understand AI limitations and implement proper guardrails supported by clean data.
• Experiment responsibly with AI-driven solutions to improve system effectiveness.
• Lead and mentor a team of 2-3 members through guidance, reviews, and prioritization.
• Set quality standards for automation, data systems, and documentation practices.
• Manage multiple requests while communicating progress clearly to stakeholders.
• Document systems, workflows, and architectural decisions for long-term continuity.

Additional Duties:

• Collaborate cross-functional with internal stakeholders to improve operational efficiency.
• Continuously evaluate and improve systems for scalability and long-term sustainability.
• Perform any other reasonable duties as requested by management, aligned with the broad scope of the position.

Who You Are:

• 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 in 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 with the ability to think beyond individual tasks and focus on scalable solutions.

Should Have:

• 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.

Nice to Have:

• Curiosity and practical exposure to AI-assisted workflows and intelligent automation systems.
• Experience experimenting with emerging automation and data tools while maintaining strong foundational practices.
• Strong documentation and process-improvement capabilities.

Why Join IIDE?

• Work with one of India's fastest-growing digital education brands.
• Gain ownership of high-impact automation and intelligent systems.
• Collaborate with cross-functional teams to drive scalable business transformation.
• Work in a collaborative, high-growth, and innovation-driven environment.
• Explore and implement emerging AI-powered operational systems.

Who You’ll Thrive As

You’re someone who:

• Sees repetitive work as an opportunity for automation.
• Thinks long-term and prioritizes scalable systems over quick fixes.
• Is curious about AI and emerging technologies while staying grounded in strong fundamentals.
• Takes ownership and proactively improves systems without waiting for instructions.
• Enjoys turning chaos into structured, efficient, and reliable workflows.