Data Analyst

Job Title: Data Analyst

Location: Marol, Mumbai (Work from Office)

Company: India On Track

Industry: Sports

Job Type: Full-time

Experience Level: 1-2 Years

Joining Date: Within a month

About India on Track:

India on Track (IOT) has been set up to inculcate a culture of sport amongst the youth and create a platform to learn and participate in various disciplines. Working in a sector that is driven by passion, we are unwavering in our commitment to help India recognize and celebrate the power of sports, be it recreational or professional.

IOT wants to equip India’s next generation with the tools to help build a healthier, stronger nation that would have its roots as much in sports as other disciplines. We make this simple idea come to life through our grassroot initiatives executed in a secure environment using world class training and conditioning techniques.

To ensure this, IOT partners with top international sporting entities (like NBA Basketball Schools & LaLiga Academy School, amongst others) to bring best-in-class sports thinking and philosophy to India. Each partnership focuses on the amalgamation of the technical expertise of these leaders in world sport and IOT's management experience and vision for India.

In India, IOT runs 85+ Centres across 14 Cities, has over 80 Coaches and trains over 20K kids. IOT also runs Residential International Development Programs in Portugal & Spain, and its fast expanding in other regions.

About The Role:

Data Analyst

Responsibilities

1. Data Collection & Querying (SQL)

·       Write efficient SQL queries to extract data from relational databases.

·       Create and optimize complex queries, including joins, subqueries, CTEs, and aggregations.

·       Ensure accurate data extraction and troubleshoot any issues in data queries.

·       Work with large datasets and manage database connections to maintain data integrity.

2. Data Cleaning & Transformation (Excel)

·       Use Excel for data preparation, including cleaning, transforming, and organizing data.

·       Apply advanced Excel functions (e.g., VLOOKUP, INDEX-MATCH, IF Statements) to manipulate and analyze data.

·       Build and maintain PivotTables and PivotCharts to summarize and visualize data trends.

·       Use Power Query and Power Pivot for more advanced data manipulation tasks in Excel.

3. Reporting & Visualization (Tableau & Power BI)

·       Develop interactive dashboards, reports, and visualizations using Tableau and Power BI.

·       Design reports that highlight key business metrics, trends, and insights.

·       Use advanced visualization features like calculated fields (Tableau), DAX measures (Power BI), and dynamic filters.

·       Automate report refresh cycles to ensure real-time data access in Tableau and Power BI.

4. Automation & Data Integration (Python - Optional but Valuable)

·       Utilize Python (primarily pandas and matplotlib) for data automation and visualization.

·       Write scripts to automate routine data processing tasks and data extraction from APIs.

·       Enhance data transformation processes that are not feasible directly in Excel or SQL.

·       Implement Python to clean and prepare data prior to creating reports and visualizations.

5. Collaboration & Communication

·       Partner with business teams to understand reporting needs and translate them into actionable data insights.

·       Present findings through clear visualizations and data-driven recommendations.

·       Provide ad-hoc data analysis and reporting to support business decisions.

Compensation

5-8 Lacs Per Annum.