Data Analytics Analyst

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.