Data Analyst null

Job Description

Pharmeasy wants to enable data-driven decision-making for achieving the core business objective of the company to make healthcare accessible & affordable to everyone. This would essentially require rigorous efforts being put into all domains of analytics from data collection to data extraction to data cleaning to data wrangling to descriptive analytics and eventually drawing business insights and communicating the same to the relevant business teams. We want to make analytics an integral part of every decision making at Pharmeasy because in today’s world subjectivity is something that is limited to academia and data can answer most of the questions.

Responsibilities

• A Data Analyst would be responsible for supporting the Business Teams with any kind of Data Reporting and Adhoc Data Analysis. The role would include extraction, cleaning, reporting, analysis and visualization of data. 
• Creating Dashboards/Reports and communicating the same to the business team 
• Identification, Reporting & Tracking of Key Business Metrics at hourly, daily, weekly, monthly frequency 
• Coordination with Business Teams to identify new reporting requests and enhance the existing ones, business users to be communicated and explained the details if the need arises 
• Testing all new reports/deliverables and periodically reviewing them for maintaining data quality 
• Data validation and attention to detail is required as the individual will be accountable for the quality of all the numbers delivered through dashboards or otherwise 

Requirements

• 1 to 3 years of work experience in the relevant field, preferably in a consumer-facing company
•  Well versed in MS Excel (vlookup, hlookup, if-else, index, match, countif, sumifs, string operations, Pivot Table & Pivot Table Chart etc.) 
• Proficient in writing SQL queries and the candidate should be able to handle complex queries 
• Structured thought process and problem-solving skills are a must-have 
• Prioritization of tasks, organised work ethics, high work efficiency are expected 
• VBA, Macros are an advantage and good-to-have