Data Analytics Analyst

Ample Softech System; Nagpur District, Pune District, Mumbai; On-site; INR 500,000 - 900,000; Full time

Job summary

Ample Softech System in Nagpur is seeking a data analyst to collect, clean, and organize data from multiple sources and build interactive dashboards using Power BI or Tableau. You will write SQL to extract, validate, and manipulate data and prepare daily, weekly, and monthly reports for management to drive decisions.

The role emphasizes cross-functional collaboration, data quality checks, and presenting insights to stakeholders to support strategic business choices.

Qualifications

• Ability to clean and validate data from multiple sources.
• Experience creating dashboards in Power BI or Tableau.
• Proficiency in SQL data extraction and manipulation.

Responsibilities

• Collect, clean, validate, and organize data from multiple sources.
• Analyse large datasets to identify trends, patterns, and business insights.
• Create interactive dashboards and reports using Power BI or Tableau.
• Write SQL queries to extract data from databases.
• Prepare daily, weekly, and monthly reports for management.
• Identify data discrepancies and recommend solutions.
• Present analytical findings and insights to stakeholders.
• Support business decision-making through data-driven recommendations.

Skills

Data cleaning

Data transformation

Data validation

KPI monitoring

Cross-functional collaboration

Storytelling with data

Statistical concepts

Data management basics

Reporting & dashboards

Tools

Advanced MS Excel

SQL

Power BI

Tableau

Python

Job description

1. Roles & Responsibilities

1. Collect, clean, validate, and organize data from multiple sources.
2. Analyse large datasets to identify trends, patterns, and business insights.
3. Create interactive dashboards and reports using Power BI or Tableau.
4. Write SQL queries to extract, retrieve, and manipulate data from databases.
5. Perform data validation, data cleaning, and quality checks to ensure accuracy.
6. Prepare daily, weekly, and monthly reports for management and business teams.
7. Identify data discrepancies and recommend appropriate solutions.
8. Work with cross-functional teams to understand business requirements.
9. Monitor key performance indicators (KPIs) and prepare performance reports.
10. Automate repetitive reporting tasks using Excel, SQL, or BI tools.
11. Present analytical findings and insights to stakeholders.
12. Support business decision-making through data-driven recommendations.

2. Key Skills Required

Technical Skills

• Advanced MS Excel Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, formulas.
• SQL – Joins, Subqueries, Group By, Aggregate Functions.
• Power BI – Dashboard Creation, Data Modelling, DAX.
• Tableau – Data Visualization (added advantage).
• Python – Pandas, NumPy (preferred).
• Knowledge of data cleaning, data transformation, and data validation.
• Understanding of databases and data management.
• Basic knowledge of statistics and analytical concepts.