Responsibilities :
A Data Analyst would be responsible for supporting the Business Teams for 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 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 enhancing the existing one, business users to be communicated and explained the details if 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 quality of all the numbers delivered through dashboards or otherwise
What are we looking for ?
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