Data Analyst

Work Timings: 10:15 AM – 7:15 PM Working Days: 5 Days a Week — The IIDE Way Work Mode: Work from Office Location: Mumbai – Lower Parel, with occasional visits to the Andheri campus 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 Data Analyst at IIDE, you will play a pivotal role in transforming raw data into reliable insights and scalable business solutions. Sitting at the intersection of data analysis and business operations, you will maintain accurate data across systems, build trusted reports and dashboards, and work with cross-functional teams to improve and automate inefficient processes. This role requires you to understand the “why” behind business requirements, not just the “what,” and translate those requirements into structured, automated, and scalable data solutions. You will work across data modelling, database architecture, ETL pipelines, reporting, CRM data, APIs, and automation while ensuring the organization's data remains accurate, accessible, and dependable. What You'll Do ● Data Management & Business Reporting: ○ Maintain accurate and structured data across platforms including LeadSquared, Zoho CRM, Google Sheets, Excel, and other business systems. ○ Manage recurring reports and ensure timely, consistent, and accurate delivery of information to stakeholders. ○ Build and maintain dashboards using Looker Studio, Zoho Analytics, Metabase, Power BI, or similar BI platforms. ○ Identify and resolve data discrepancies, anomalies, and root-cause issues instead of relying on temporary fixes. ○ Ensure reporting logic, calculations, definitions, and data sources are transparent and trusted by business teams. ○ Analyse operational data to identify patterns, trends, gaps, and actionable insights. ● Data Modelling & Database Architecture: ○ Design and maintain clean, scalable database schemas that support a reliable single source of truth. ○ Apply data modelling principles including normalisation, dimensional modelling, and entity-relationship design. ○ Make informed decisions around data structures, identifiers, schema evolution, and historical versus current data management. ○ Ensure referential integrity, consistency, and reliability across interconnected systems and databases. ○ Document data models, schema definitions, relationships, and architectural decisions for long-term maintainability. ○ Collaborate with Engineering, Operations, and other teams to ensure database architecture supports reporting, automation, and business requirements. ● ETL Pipelines & Data Orchestration: ○ Build, manage, and monitor ETL pipelines to extract, transform, and load data reliably across systems. ○ Work with orchestration and data integration tools such as Apache Airflow, Airbyte, Prefect, or similar platforms. ○ Use Python and SQL for data extraction, transformation, validation, processing, and loading. ○ Integrate systems and data sources using APIs, webhooks, and other integration mechanisms. ○ Optimise pipelines for reliability, performance, scalability, and cost efficiency. ○ Implement appropriate error handling, retries, monitoring, and alerts for production data workflows. ○ Proactively monitor pipeline health and resolve failures or data-quality issues before they impact downstream reporting. ● SQL, Analytics & Data Quality: ○ Write and optimise advanced SQL queries for operational, analytical, and reporting use cases. ○ Work with joins, CTEs, window functions, subqueries, aggregations, and other advanced SQL concepts. ○ Extract, clean, transform, and analyse data from relational databases such as PostgreSQL, MySQL, BigQuery, or similar platforms. ○ Perform data validation and reconciliation to ensure accurate downstream reporting and analysis. ○ Identify trends, patterns, exceptions, and actionable insights that can support business teams and management. ○ Ensure data quality issues are investigated systematically and resolved at their source wherever possible. ● Automation & Systems Improvement: ○ Identify repetitive, manual, or inefficient processes and recommend opportunities for automation. ○ Work with tools such as Make, n8n, Zapier, Google Apps Script, or similar platforms to automate workflows. ○ Support integrations between CRMs, databases, reporting platforms, and other business applications using APIs and webhooks. ○ Explore AI-assisted analytics, intelligent automation, and LLM-powered data workflows to improve efficiency and decision-making. ○ Build solutions that reduce manual dependencies while improving accuracy, reliability, and scalability. ● Additional Duties: ○ Collaborate with Business Operations, Engineering, Sales, Marketing, Admissions, and other teams to understand data and reporting requirements. ○ Translate business requirements into scalable data models, dashboards, reports, pipelines, and automated solutions. ○ Maintain clear documentation for data models, reports, processes, pipelines, and architectural decisions. ○ Continuously identify opportunities to improve data quality, reporting efficiency, system architecture, and automation. ○ Perform any other reasonable duties as requested by management, aligned with the broad scope of the position. Requirements Who You Are ● Must-Have: ○ 2–3 years of relevant experience in data analysis, analytics engineering, business analytics, or a related role. ○ Strong proficiency in SQL with the ability to write complex, optimised, production-grade queries using joins, window functions, CTEs, subqueries, and aggregations. ○ Strong understanding of data modelling principles including normalisation, dimensional modelling, and relational database design. ○ Hands-on experience with database architecture, including schema design, identifiers, relationships, and structures for operational and analytical use cases. ○ Experience with ETL tools or orchestration platforms such as Apache Airflow, Airbyte, Prefect, or similar technologies. ○ Hands-on experience with at least one BI or reporting platform such as Looker Studio, Power BI, Zoho Analytics, Tableau, Metabase, or similar. ○ Proficiency in Microsoft Excel and/or Google Sheets, including formulas, pivot tables, data validation, and data manipulation. ○ Demonstrated ability to understand business requirements and translate them into structured and scalable data solutions. ○ Exposure to AI-assisted analytics, intelligent automation, or LLM-powered data workflows. ○ Strong attention to detail, logical thinking, analytical ability, and focus on data accuracy. ○ Good communication and interpersonal skills for effective cross-functional coordination. ○ A degree in Statistics, Computer Science, Business Analytics, Commerce, or a related field. ● Should Have: ○ Experience working with CRM platforms such as LeadSquared, Zoho CRM, Salesforce, or similar systems. ○ Exposure to cloud data platforms, particularly Google BigQuery. ○ Familiarity with automation tools such as Make, n8n, Zapier, or Google Apps Script. ○ Working knowledge of Python for data processing, transformation, automation, and pipeline scripting. ○ Basic understanding of REST APIs, webhooks, and system integrations. ○ Experience documenting data models, processes, pipelines, schemas, and architectural decisions. ○ Experience building, maintaining, or monitoring data pipelines in a production environment. ● Nice to Have: ○ Experience with Apache Superset for self-service analytics and dashboard creation. ○ Experience developing Excel Macros or Google Apps Script solutions. ○ Exposure to AWS data technologies such as Redshift or S3, or Azure platforms such as Synapse. ○ Familiarity with DBT or similar data transformation frameworks. ○ Experience with multiple cloud data platforms or modern analytics engineering workflows. Benefits Why Join IIDE? ● Work with one of India's fastest-growing digital education brands. ● Gain exposure to end-to-end business data, analytics, systems, and automation initiatives. ● Build data solutions that directly influence operational and management decision-making. ● Gain hands-on experience across SQL, databases, ETL pipelines, BI tools, CRMs, APIs, and automation platforms. ● Work on building reliable and scalable data systems rather than only producing one-off reports. ● Collaborate closely with technical and business teams across the organization. ● Explore AI-assisted analytics, intelligent automation, and emerging data technologies in real business use cases. ● Work in a collaborative, high-growth environment with significant ownership and learning opportunities. Who You'll Thrive As You're someone who: ● Thinks in systems, relationships, and data models rather than viewing every query or report in isolation. ● Enjoys turning messy or fragmented data into clean, structured, and dependable information. ● Wants to understand why a business needs something before deciding how to build it. ● Naturally looks for patterns, inconsistencies, inefficiencies, and opportunities for improvement. ● Takes proactive ownership and improves processes without waiting to be told every next step. ● Has genuine curiosity about databases, analytics, automation, AI, and how different business systems work together. ● Enjoys getting to the root cause of data problems rather than applying surface-level fixes. ● Approaches challenges logically, methodically, and with strong attention to detail. ● Communicates comfortably with both technical and non-technical stakeholders. ● Is excited to explore AI-assisted analytics, intelligent automation, and LLM-powered data workflows. ● Learns quickly and adapts comfortably in a fast-paced, evolving environment.