Magicpin - Associate Analyst (0-2 yrs)

Associate Analyst

About Magicpin:

Magicpin is a hyperlocal commerce technology company that offers digital convenience to local merchants and real-world experiences for customers. It connects offline commerce where 95% of transactions happen in India to online. Magicpin's proprietary tech stack provides an end-to end app-based retail marketing platform that allow:

- Local Retailers to increase traffic and transactions through promotions.

- Customers to explore hyperlocal retail and earn rewards and savings.

- Brands to connect with consumers and retailers directly and optimize supply chain performance for greater impact.

Magicpin brings alive the joy of shopping from local stores, which are the lifeblood of the economy. By connecting retailers big and small with customers, Magicpin creates value for all in the hyperlocal retail ecosystem and allows them to leverage the fast-growing digital world.

Magicpin drives more than $2B+ in annual GMV. The app currently has more than 10M+ active users, is available in more than 50 cities in India and has more than 200,000+ brands, partners and retailers.

What will you be doing?

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

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

- Identify opportunities using insights for product/process improvement.

- Create dashboards and automated reports to track KPIs.

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

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

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

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

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

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

What you will need to apply:

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

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

- Advanced Excel Proficiency and SQL (experience of working in Python/R is Mandatory).

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

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

- 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).

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