Data Analyst

Job Summary

We are looking for a detail-oriented and analytically driven Data Analyst to join our Business Operations team. In this role, you will be the bridge between raw data and meaningful business decisions - maintaining accurate data across platforms, building clear reports, and working closely with cross-functional teams to identify and automate repetitive or inefficient processes. This is a role that sits at the intersection of data analysis and business operations. You will be expected to understand the 'why' behind business requirements, not just the 'what,' and translate those requirements into structured, automated, and scalable solutions. A strong grasp of data modelling, database architecture, and ETL processes is essential to succeed in this role.

Job Details

Work Timings: 10:15 AM - 7:15 PM; Working Days: Monday to Saturday (2nd, 4th, 5th Saturdays off); Work Mode: Work From Office; Location: Mumbai.

Key Responsibilities

• Data Management Reporting: Maintain data accurately and efficiently across platforms including CRMs (LeadSquared, Zoho) and Google Sheets / Excel. Update and manage recurring reports, ensuring data integrity, consistency, and timely delivery to stakeholders. Build and maintain dashboards using tools such as Looker Studio, Zoho Analytics, Metabase or Power BI. Identify and resolve data discrepancies, anomalies, and root-cause issues - not just surface-level fixes. Ensure reporting logic is transparent, accurate, and trusted by business teams.
• Data Modelling: Database Architecture - Design and maintain clean, well-structured database schemas that serve as a reliable single source of truth. Apply strong data modelling principles - normalisation, dimensional modelling, and entity-relationship design - to support scalable data systems. Make informed architectural decisions around data structures, identifiers, historical vs. current data management, and schema evolution. Ensure data consistency, referential integrity, and reliability across all interconnected systems. Document data models, schema definitions, and architectural decisions to enable long-term maintainability. Collaborate with engineering and operations teams to align database design with business reporting and automation needs.
• ETL Pipelines Data Orchestration: Build, manage, and monitor ETL (Extract, Transform, Load) pipelines to move and transform data across systems reliably. Work with orchestration tools such as Apache Airflow, Airbyte, or similar platforms to schedule and manage data workflows. Use Python or SQL for data extraction, transformation, validation, and loading into target systems. Integrate data sources using APIs and webhooks to ensure seamless, automated data flow. Optimise pipelines for performance, reliability, and cost efficiency; implement error handling, retries, and alerting. Proactively monitor pipeline health and resolve failures or data quality issues before they impact downstream reporting.
• SQL Data Analysis: Write and optimise advanced SQL queries for operational and analytical use cases. Extract, clean, and analyse data from relational databases (PostgreSQL, MySQL, BigQuery, or similar). Perform data validation and transformation to support accurate downstream reporting. Analyse data to identify patterns, trends, and actionable insights for business teams.

Must-Have

• 2-3 years of relevant experience in data analysis, analytics engineering, or a related role
• Strong proficiency in SQL - ability to write complex, optimised production-grade queries including joins, window functions, CTEs, and subqueries
• Solid understanding of data modelling principles - normalisation, dimensional modelling, and relational database design
• Hands-on experience with database architecture - designing schemas, managing identifiers, and structuring data for both operational and analytical use
• Experience with ETL tools or orchestration platforms such as Apache Airflow, Airbyte, Prefect, or similar
• Hands-on experience with at least one reporting / BI tool: Looker Studio, Power BI, Zoho Analytics, Tableau, or similar
• Proficient in Microsoft Excel and/or Google Sheets, including formulas, pivot tables, and data validation
• Demonstrated ability to understand business requirements and convert them into structured, scalable data solutions
• Exposure to AI-assisted analytics, intelligent automation, or LLM-powered data workflows
• Strong attention to detail, data accuracy, and logical thinking
• Good communication and interpersonal skills for cross-functional coordination
• A degree in a relevant field (e.g. Statistics, Computer Science, Business Analytics, Commerce, or equivalent)

Should Have

• Experience working with CRM platforms such as LeadSquared, Zoho CRM, or Salesforce
• Exposure to cloud data platforms: GCP (BigQuery)
• Exposure to automation tools - Make (Integromat), n8n, Zapier, or Google Apps Script
• Familiarity with Python for data processing, transformation, and pipeline scripting
• Basic understanding of APIs, webhooks, and system integrations
• Ability to document data models, processes, and architectural decisions clearly
• Experience building or maintaining data pipelines in a production environment

Key Traits We Are Looking For

• Structured and process-oriented thinker who sees patterns in chaos
• Thinks in systems and data models - not just individual queries or tasks
• Proactive ownership - you improve systems without waiting to be asked
• Genuine curiosity about data, databases, automation, and how businesses operate
• Curiosity about AI-assisted analytics, intelligent automation, or LLM-powered data workflows
• Strong problem-solving ability with a logical, methodical approach to challenges
• Collaborative team player who communicates clearly with both technical and non-technical stakeholders
• Willingness to learn and adapt quickly in a fast-paced environment

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.