Magicpin - Senior Analyst (1-4 yrs)

About Magicpin :

magicpin brings alive the joy of shopping from local stores which are the lifeblood of the economy. Our vision is to bring all big and small merchants in our local neighbourhoods online and connect them with customers to create value for everyone in the hyperlocal retail ecosystem. We are active in more than 50 cities in India with more than 6M+ active users and have more than 200,000+ brands, partners, retailers on our platform which currently drives $2B+ in annual GMV.

Backed by marquee investors like Zomato, Lightspeed India Partners, WaterBridge Ventures and many more, magicpin is well positioned to be the number one hyperlocal discovery and savings platform of India. magicpin holds a prominent position as a key network participant in the ONDC initiative, reshaping the way commerce operates in India.

What will you be doing?

1. Understand the business, define problems and design structured approaches to solve them.

2. Perform exploratory analysis on large volumes of data to validate/disregard hypotheses.

3. Identify opportunities using insights for product/process improvement.

4. Create dashboards and automated reports to track KPIs.

5. Manage the reporting of KPIs, present analysis & findings to steer the team's strategic vision.

6. Partner with cross-functional stakeholders (engineering, design, sales and operations teams) on a regular basis to drive product/process changes and improve business intelligence.

7. Analyze rich user and transaction data to surface patterns and trends.

8. Perform analytical deep-dives to identify problems, opportunities and actions required.

9. Process data from disparate sources using SQL, R, Python, or other scripting and statistical tools

10. Perform ad hoc data analysis to remove roadblocks and ensure operations are running smoothly

What you will need to apply:

1. Flair for numbers, strong analytical skills and structured process thinking, attention to detail

2. Basic business sense and an understanding of common statistics/analytics techniques

3. Advanced Excel Proficiency and SQL (experience of working in Python is Mandatory)

4. Strong ownership, drive and the experience of working independently in unstructured environments

5. Ability to work closely with cross-functional teams within tight timelines to execute on decisions

6. An appreciation for the connection between your work and the outcome (the impact it has on the organization and the experience it delivers to the customers)

7. Interview Focus: Puzzles, Guesstimates, Problem Solving, Analytical tool proficiency, Data Interpretation