Akalp Techno Media Solutions LLP is looking for a Data Analyst who can collect, analyze, interpret, and present data to support business and operational decision-making.
The candidate will be responsible for working with data from different departments and projects, preparing accurate reports and dashboards, identifying trends and performance gaps, and providing actionable insights to management.
The ideal candidate should have strong analytical thinking, attention to detail, and hands-on experience with Excel, SQL, Power BI/Tableau, and data visualization.
Key Responsibilities
1. Data Collection & Management
- Collect data from multiple internal and external sources.
- Organize and maintain structured datasets for analysis.
- Clean and validate data to ensure accuracy and consistency.
- Identify missing, duplicate, or incorrect data and resolve discrepancies.
- Maintain proper documentation of datasets and reporting processes.
2. Data Analysis
- Analyze business, operational, marketing, sales, HR, and project-related data.
- Identify trends, patterns, opportunities, and performance gaps.
- Conduct comparative and performance analysis.
- Generate meaningful insights from large datasets.
- Support management with data-driven recommendations.
3. Reporting & Dashboards
- Prepare daily, weekly, and monthly MIS reports.
- Develop interactive dashboards for management and department heads.
- Track key business and departmental KPIs.
- Automate recurring reports wherever possible.
- Present complex data in a simple and understandable format.
4. Excel & Data Tools
- Work extensively with Microsoft Excel/Google Sheets.
- Use advanced Excel functions such as:
- VLOOKUP/XLOOKUP
- INDEX-MATCH
- Pivot Tables
- Conditional Formatting
- IF/IFS
- SUMIFS/COUNTIFS
- Charts and dashboards
- Use Power BI, Tableau, or similar business intelligence tools for visualization and reporting.
5. SQL & Database Analysis
- Write SQL queries to extract and analyze data from databases.
- Perform filtering, aggregation, joins, and data transformation.
- Work with database teams to retrieve required information.
- Ensure data accuracy and consistency across reporting systems.
6. Performance & Business Analysis
- Monitor departmental and project-level performance.
- Identify deviations from targets and expected performance.
- Analyze productivity, revenue, costs, leads, conversions, attendance, and other relevant business metrics.
- Identify areas for improvement based on data.
- Provide management with actionable recommendations.
7. Data Visualization
- Create clear and effective charts, graphs, dashboards, and reports.
- Convert complex datasets into easy-to-understand visual insights.
- Design management dashboards according to business requirements.
- Ensure reports highlight important trends and exceptions.
8. Cross-Department Coordination
- Work with HR, Marketing, Sales, Operations, Finance, and other teams to understand their data requirements.
- Coordinate with department heads to define KPIs and reporting requirements.
- Ensure timely availability of accurate reports.
- Assist teams in understanding and interpreting their data.
Required Skills
- Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Business Analytics, Economics, or a related field.
- 2–5 years of experience as a Data Analyst, MIS Analyst, Business Analyst, or similar role.
- Strong knowledge of Microsoft Excel/Google Sheets.
- Hands-on experience with SQL.
- Experience with Power BI, Tableau, or similar BI tools.
- Strong knowledge of data cleaning, analysis, and visualization.
- Excellent analytical and problem-solving skills.
- Strong attention to detail and data accuracy.
- Ability to handle large datasets.
- Good understanding of KPIs and performance metrics.
- Strong communication and reporting skills.
Preferred Skills
- Experience with data automation and reporting automation.
- Knowledge of Python/R for data analysis will be an advantage.
- Experience working with APIs or integrating data from multiple systems.
- Knowledge of Google Analytics or digital marketing analytics will be an advantage.
- Experience working with HR, sales, marketing, or operational datasets.
Key Performance Indicators (KPIs)
- Accuracy of reports and dashboards
- Timely delivery of MIS and management reports
- Data quality and validation
- Reporting automation
- Dashboard efficiency and usability
- Accuracy of insights and analysis
- Identification of performance gaps
- Reduction in manual reporting work
- Support provided for data-driven decision-making
Ideal Candidate
The ideal candidate should be analytical, detail-oriented, technically proficient, and business-focused. They should be capable of independently handling data from multiple departments, converting raw data into meaningful insights, and presenting findings clearly to management.
The candidate should have a strong ability to identify problems through data, explain what the numbers mean, and recommend practical actions based on the analysis.
Pay: Up to ₹30,000.00 per month
Work Location: In person
