Job Purpose
The Data Analyst is responsible for transforming business data into meaningful insights that support strategic and operational decision-making. The role involves data collection, cleansing, analysis, dashboard development, KPI monitoring, and identifying trends and opportunities that enhance business performance.
Key Responsibilities
Data Management & Analysis
- Collect, validate, clean, and analyse data from multiple sources including ERP, SAP, CRM, Excel, and databases.
- Develop data models to support reporting and business analytics.
- Identify trends, patterns, anomalies, and business opportunities through data analysis.
- Perform root cause analysis for operational and business issues.
Dashboard & Reporting
- Design and maintain Power BI dashboards and management reports.
- Develop automated reports and KPI scorecards.
- Create visualisations that enable data-driven decision-making.
- Ensure report accuracy and data consistency across systems.
Business Insights
- Analyse sales, procurement, inventory, production, finance, and operational data.
- Monitor key business KPIs and recommend improvement actions.
- Support management reviews with analytical presentations and insights.
- Provide predictive and trend-based analysis to assist business planning.
Process Improvement
- Identify opportunities for automation and process optimisation.
- Support digital transformation initiatives through analytics.
- Improve data quality standards and governance practices.
- Collaborate with business users to define reporting requirements.
Stakeholder Engagement
- Work closely with department heads and business teams.
- Translate business requirements into analytical solutions.
- Present findings and recommendations to management.
Educational Qualification
- Bachelor's Degree in Computer Science, Information Technology, Statistics, Mathematics, Business Analytics, Engineering, or related field.
- Certification in Power BI, Data Analytics, SQL, or Business Intelligence is preferred.
Experience
Level Experience
Junior Data Analyst 0-2 years of experience
Data Analyst 2-5 years of experience
Senior Data Analyst 5+ years of experience with business intelligence and data modelling expertise
Technical Skills
Mandatory
- Advanced Microsoft Excel
- Power BI
- SQL
- Data Modelling
- Data Visualisation
- Statistical Analysis
Preferred
- Python (Pandas, NumPy, Matplotlib)
- SAP ERP / SAP S/4HANA
- Microsoft Fabric
- Azure Data Services
- Power Query
- DAX
Behavioural Competencies
- Strong analytical and logical thinking
- Excellent problem-solving capability
- Attention to detail
- Effective communication and presentation skills
- Business acumen
- Team collaboration and stakeholder management
- Self-driven and result-oriented approach
Key Performance Indicators (KPIs)
KPI Target Measure
- Dashboard Accuracy >98%
- Report Timeliness 100% adherence
- Data Quality Score >95%
- Automation Initiatives As per annual plan
- Business Insights Delivered Monthly
- User Satisfaction >90%
- Reduction in Manual Reporting Effort Year-on-Year Improvement
Preferred Industry Experience
- Manufacturing
- FMCG
- Edible Oils & Food Processing
- Supply Chain & Procurement Analytics
- Sales & Distribution Analytics