Data Analyst
Summary
Data Analyst at a client company in Port Elizabeth: builds SQL queries and Power BI dashboards, reconciles data across systems like ERP/POS/WMS, investigates discrepancies, and delivers reports and ad-hoc analysis to support business decisions.
- Analyse operational, financial, and retail data to identify trends, patterns, exceptions, and opportunities.
- Build and maintain SQL queries, reporting views, and structured data models used for business reporting.
- Create, enhance, and manage interactive Power BI dashboards and reports.
- Conduct ad-hoc analysis in response to business and management requirements.
- Compare and reconcile information from multiple systems to ensure reporting is accurate and consistent.
- Investigate data irregularities and work with relevant stakeholders to resolve discrepancies.
- Develop and maintain recurring reports using SQL, Power BI, and Microsoft Excel.
- Translate business requirements into clear, practical reporting solutions.
- Work closely with stakeholders across different departments to understand their information and reporting needs.
- Assist in strengthening data quality, reporting standards, documentation, and governance practices.
- Continuously identify opportunities to improve reporting processes, efficiency, and accessibility of business information.
Requirements
- Diploma or Degree in Data Analytics, Information Systems or related.
- 3+ years experience in Data Analysis.
- Strong SQL experience.
- Understanding of Developing dashboards and reports with Power BI.
- Strong MS Excel skills.
- Prior experience working with ERP, WMS, POS or similar systems.
- Valid Drivers License.
