Job Description – Data AnalystPosition: Data Analyst

Location: Jalandhar, Punjab
Department: Business Analytics / MIS
Experience: 2–5 Years
Employment Type: Full-Time

Job Summary

We are looking for a highly analytical and detail-oriented Data Analyst with solid expertise in Advanced Microsoft Excel to support business decision-making through accurate reporting, data analysis, dashboards, and actionable insights.

The ideal candidate should be comfortable working with large datasets, preparing complex MIS reports, identifying business trends, and presenting data in a clear and meaningful manner to management.

Key Responsibilities
- Collect, organize, clean, validate, and analyze data from multiple sources.
- Prepare daily, weekly, and monthly MIS reports for management.
- Develop and maintain management dashboards and performance reports.
- Analyze sales, revenue, expenses, incentives, targets, achievements, and other business performance data.
- Identify trends, gaps, inconsistencies, and opportunities through data analysis.




- Generate actionable insights to support business and management decisions.
- Track and report departmental KPIs and performance metrics.
- Automate repetitive reports and reduce manual reporting processes.
- Perform data reconciliation and ensure accuracy of all reports.
- Handle large volumes of data and maintain proper data structures.
- Prepare ad-hoc reports and analysis as required by management.
- Work closely with Sales, Finance, HR, Operations, and other departments to understand reporting requirements.
- Ensure timely submission of accurate reports and dashboards.
- Maintain proper documentation of reports, formulas, data sources, and reporting processes.

Mandatory Skills – Advanced Microsoft Excel

The candidate must have strong hands-on expertise in Advanced Microsoft Excel, including:
- Pivot Tables & Pivot Charts
- XLOOKUP / VLOOKUP / HLOOKUP
- INDEX & MATCH
- SUMIFS / COUNTIFS / AVERAGEIFS
- IF, nested IF & logical function

📌 Data Analyst (Jalandhar)
🏢 Uni-Com India
📍 Jalandhar