Position: Data Analyst
Experience: 1–3 Years (Candidates with 2–5 years of prior Sales experience will be preferred)
CTC: ₹6 LPA – ₹10 LPA
Location: Kharadi/Undri( Hybrid)
About the Role
We are looking for a detail-oriented and analytical Data Analyst who is highly proficient in Microsoft Excel and passionate about transforming raw data into meaningful business insights. The ideal candidate should have experience in data analysis, reporting, and dashboard creation. Candidates with prior sales exposure will have an added advantage, as the role involves analyzing sales data and supporting business decision-making.
Job Description – Data Analyst
Position: Data Analyst
Experience: 1–3 Years (Candidates with 2–5 years of prior Sales experience will be preferred)
CTC: ₹6 LPA – ₹10 LPA
Location: Kharadi/Undri( Hybrid)
About the Role
We are looking for a detail-oriented and analytical Data Analyst who is highly proficient in Microsoft Excel and passionate about transforming raw data into meaningful business insights. The ideal candidate should have experience in data analysis, reporting, and dashboard creation. Candidates with prior sales exposure will have an added advantage, as the role involves analyzing sales data and supporting business decision-making.
Key Responsibilities
- Analyze large datasets using Microsoft Excel to identify trends, patterns, and business opportunities.
- Prepare daily, weekly, and monthly MIS reports and dashboards.
- Perform data cleaning, validation, and reconciliation to ensure data accuracy.
- Generate actionable insights from sales and business data to support management decisions.
- Create Pivot Tables, Pivot Charts, Lookup functions (VLOOKUP/XLOOKUP), Index-Match, Conditional Formatting, Power Query, and advanced Excel formulas.
- Track and analyze sales performance, customer behavior, and business KPIs.
- Collaborate with Sales, Operations, and Management teams to understand reporting requirements.
- Automate repetitive reports and improve reporting efficiency wherever possible.
- Present findings through reports, charts, and visual dashboards.
- Ensure timely submission of reports with high accuracy.
Required Skills
- Strong proficiency in Microsoft Excel (Advanced Level).
- Excellent knowledge of:
- Pivot Tables & Pivot Charts
- VLOOKUP/XLOOKUP
- INDEX-MATCH
- IF, SUMIFS, COUNTIFS and other advanced formulas
- Conditional Formatting
- Power Query
- Data Cleaning & Validation
- Strong analytical and problem-solving skills.
- Excellent attention to detail and accuracy.
- Good communication and presentation skills.
- Ability to work independently and meet deadlines.
Preferred Qualifications
- Bachelor's degree in Commerce, Business Administration, Statistics, Mathematics, Computer Science, Engineering, or a related field.
- 1–3 years of experience as a Data Analyst, MIS Executive, Business Analyst, or similar analytical role.
- Prior experience in Sales (2–5 years) will be an added advantage, especially in analyzing sales performance and business metrics.
- Basic knowledge of SQL, Power BI, or Tableau is a plus.
What We're Looking For
- Strong analytical mindset with the ability to interpret complex datasets.
- High level of ownership and accountability.
- Ability to convert data into meaningful business insights.
- Proactive approach to improving reporting processes.
- Team player with excellent organizational skills.
Compensation & Benefits
- Salary: ₹6 LPA – ₹10 LPA (Based on experience and skills)
- Opportunity to work on business-critical data and decision-making.
- Learning and career growth opportunities.
- Collaborative and performance-driven work environment.
Pay: ₹600,000.00 - ₹1,000,000.00 per year
Benefits:
- Flexible schedule
- Paid time off
Experience:
- Data Analyst: 2 years (Required)
Location:
- Pune, Maharashtra (Pune, Pune District) (Required)
Work Location: In person