# Data Analytics Analyst at Ample Softech System
Source: https://true-hire-ten.vercel.app/jobs/data-analytics-analyst-ample-softech-system-4puixlil · Company profile: https://true-hire-ten.vercel.app/companies/ample-softech-system · Apply on the employer's site: https://www.naukri.com/job-listings-data-analytics-analyst-ample-softech-system-nagpur-pune-mumbai-all-areas-0-to-3-years-031126024994?utm_source=freehire.me
**In short:** Junior (0-3 yrs) data analytics role in Nagpur, Pune, or Mumbai: cleaning and validating data from multiple sources, writing SQL queries, and building dashboards and reports for management. Core stack is SQL, advanced Excel, and Power BI, with Tableau and Python (Pandas/NumPy) as pluses.

## Job details
- Location: Nagpur; Pune; Mumbai (All Areas)
- Work mode: On-site
- Employment type: Full-time
- Category: Data Analytics
- Advertised pay: ₹50,000 – ₹300,000 per year
- Countries: India
- Posted: 2026-11-03 (16 days ago, stale)
- Skills named: data-modeling, data-visualization, numpy, pandas, powerbi, python, sql, statistics, tableau
## Requirements

- 0-3 years of experience
- Advanced MS Excel (Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, formulas)
- SQL (Joins, Subqueries, Group By, Aggregate Functions)
- Power BI (Dashboard Creation, Data Modelling, DAX)
- Knowledge of data cleaning, data transformation, and data validation
- Understanding of databases and data management
- Basic knowledge of statistics and analytical concepts

## Nice to have

- Tableau (Data Visualization)
- Python (Pandas, NumPy)

## About the role
1. Roles & 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, retrieve, and manipulate data from databases.
- Perform data validation, data cleaning, and quality checks to ensure accuracy.
- Prepare daily, weekly, and monthly reports for management and business teams.
- Identify data discrepancies and recommend appropriate solutions.
- Work with cross-functional teams to understand business requirements.
- Monitor key performance indicators (KPIs) and prepare performance reports.
- Automate repetitive reporting tasks using Excel, SQL, or BI tools.
- Present analytical findings and insights to stakeholders.
- 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.
© TrueHire. Listing data from freehire; applications go to the employer's own page.