Business Analyst

Job Description

1. Min of 1.5 years of exp in the data domain AND strong affinity for data wrangling. 2. Ability to look and understand data patterns, conclusions and the ability to present and translate this data into understandable documents. 3. Ability to understand business problems and translate the solutions to SQL and Python. 4. Ability to understand large and complex data structures in depth for data modeling. 5. Ability to write, optimize, and explain SQL queries that wrangle ~150M rows of data with ease. 6. Strong business case understanding and marrying marketing knowledge with data insights to drive projects. 7. Ability to use Python for scripting, ETL, and API requests. 8. Basic understanding of modern data architecture: data lake, data warehouse, serverless compute, Redshift / BigQuery / Athena / Snowflake etc. 9. Ability to visualize insights with the help of a BI tool (example: Tableau / QuickSight / Metabase). Responsibilities: 1. Data Analysis and Insights: - Analyze, and interpret large datasets to identify trends, patterns, and insights relevant to the business. - Utilize statistical techniques and data visualization tools to present findings in a clear and concise manner. - Generate actionable recommendations based on data-driven insights to improve operational efficiency, customer experience, and overall business performance . 2. Marketing - Reporting and Dashboards: - Develop and maintain reports and dashboards to track key performance indicators (KPIs) and monitor business metrics. - Provide regular updates to stakeholders on business trends, performance, and areas for improvement. - Automate reporting processes wherever possible to streamline data analysis and reporting workflows. - Deep dive into data segmentations, cohortizations, and RCAs. Participate in solutioning discussions with relevant teams with data insights built. 3. SQL & Use of Other Platforms - Extract, transform from various sources using SQL queries. - Develop and optimize SQL queries to perform data analysis and generate reports. - Ensure data accuracy, integrity, and security by maintaining and managing databases. - Utilize Python programming skills to automate repetitive tasks, data cleansing, and data processing. - Develop scripts and programs to enhance data analysis capabilities and streamline workflows. - Collaborate with the technical team to integrate data sources and implement data-driven solutions. Proficiency in these tools - Mixpanel, Metabase, Singular/Appsflyer, Google Analytics 4. Driving Business use cases (Cross functional Teams) - Collaborate with stakeholders to understand business needs and translate them into clear and concise requirements. - Create & Document business processes, workflows, and system requirements for new projects and enhancements. Discuss and ideate these requirements with other dependent functions & see end to end implementation of said tasks. - Work closely with cross-functional teams, including marketing, operations, and product development, to gather insights and align business strategies. - Collaborate with stakeholders to identify business problems, opportunities, and areas for process improvement. - Act as a liaison between marketing & technical teams, ensuring effective communication and understanding of requirements. What do we offer - 1. A seat at one of Indias fastest growing D2C startup and be part of our 0-1 journey. 2. Supportive team with experience in building and running top companies. 3. Open environment to learn & grow other functions, understand the business firsthand.