Business Analyst

Hopscotch is the category creator offering Indian parents fashion for all occasions in a childs life. If you join the Hopscotch team, you will be partnering with top pedigree managers in a fast-paced and rapidly growing environment.

We are seeking a highly motivated and analytical Business Analyst to join our Data Analytics Team. In this role, you will play a critical part in turning raw data into actionable insights that support business decisions and strategic initiatives. You will work closely with cross-functional teams and directly engage with business stakeholders to understand data requirements, design robust data pipelines, and deliver impactful analyses.

Role & Responsibilities :

- Collaborate with stakeholders across departments to gather and translate business requirements into data models and analytical solutions.

- Act as a key point of contact for business teams, ensuring their analytical needs are clearly understood and addressed effectively.

- Design, develop, and maintain ETL pipelines to ensure seamless data flow across systems.

- Perform advanced SQL queries to extract, manipulate, and analyze large datasets from multiple sources.

- Utilize Python to automate data workflows, perform exploratory data analysis (EDA), and build data transformation scripts.

- Leverage AWS tools (such as S3, Redshift, Glue, Lambda) for data storage, processing, and pipeline orchestration.

- Develop dashboards and reports to visualize key metrics and insights for business leadership.

- Conduct deep-dive analyses on business performance, customer behavior, and operational efficiencies to identify growth opportunities.

- Ensure data accuracy, integrity, and security throughout all analytics processes.

Ideal Candidate :

- Bachelors degree in Computer Science, Data Science, Engineering, Business Analytics, or a related field.

- 1+ years of experience in data analytics, business intelligence, or a similar role.

- Proficient in Advanced SQL for complex data manipulation and performance optimization.

- Intermediate proficiency in Python for data processing and automation (Pandas, NumPy, etc.).

- Experience with building and maintaining ETL pipelines.

- Familiarity with AWS Data Services (e.g., S3, Glue, Lambda, Athena).

- Strong analytical skills with a solid understanding of statistical methods and business performance metrics.

- Experience with data visualization tools like Tableau, Metabase.

- Excellent communication and interpersonal skills with the ability to engage directly with business stakeholders and translate their needs into actionable data solutions.

- Strong problem-solving skills and ability to work in a fast-paced, collaborative environment.