Alternate Job Titles
Data Modeler, Business Intelligence Analyst, Data Warehouse Analyst, Systems Analyst, Business Analyst, Computer Analyst
Job Level
Entrant
Specialist
Functional Group
Data Services
Job Family
Data
Job Description
The Data Analyst is responsible for:
- Assist in the data collection, processing, and warehousing tasks, which may also include collection, analysing and visualising large sets of data
- Perform basic data cleaning and transformation
- Generate reports, dashboards, clean and prepare the data and analytical solutions according to business rules and specifications utilising development tools
- Perform analysis to support business and product decisions
- Work with management team to identify opportunities for improvement
- Create reports for internal teams and external clients
- Use graphs, infographics and other methods to establish KPIs to measure the effectiveness of business decisions
- Structure large data sets to find usable information
- Work with a team of analysts and other associates to process information
- Create presentations and reports based on recommendations and findings
- Coordinate with internal teams to develop projections on outcomes of implementing business strategies that result in actionable insights
Critical Work Function
Business Needs Identification
- Identify the information needs of stakeholders needed for decision-making.
- Assist in translating business needs into analytical and reporting requirements.
- Recommend the types of data and data sources needed to obtain the information and insights required.
- Assist in identifying potential business intelligence services required by the company.
Data Preparation and Analysis
- Perform data entry tasks in data collection systems.
- Gather data from internal systems and external source.
- Clean and update databases to remove duplicated, outdated or irrelevant information.
- Perform data validation and quality control checks.
- Perform basic extract, transform and load related activities to prepare data for analysis or transfer.
- Analyse data to identify trends, patterns and correlations to support decision-making.
- Propose solutions and recommendations to address information need.
- Manage master data, including creation, updates, and deletion.
- Manage users and user roles.
- Provide quality assurance of imported data, working with quality assurance analysts if necessary.
- Commission and decommission data sets.
- Process confidential data and information according to guidelines.
- Conduct new technology research as requested.
Insight Presentation
- Manage and design the reporting environment, including data sources, security, and metadata.
- Support the data warehouse in identifying and revising reporting requirements.
- Support initiatives for data integrity and normalisation.
- Generate reports from single or multiple systems.
- Troubleshoot the reporting database environment and reports.
- Evaluate changes and updates to source production systems.
- Train end-users on new reports and dashboards.
- Provide technical expertise in data storage structures, data mining, and data cleansing.
- Carry out routine maintenance tasks to detect and/or prevent system malfunctions that disrupt system connectivity.
- Generate system reports.
- Develop automated and logical data model and data output methods.
- Translate analyses into a common business language to influence business decisions or actions.
- Design of data reports and visualisation tools to facilitate understanding of data through storytelling.
Entry Requirements
#1
Data Analyst
BDQF Level 6 in Information Systems, Computer Science, and any related field (or) BDQF level 5 with relevant industry experience (or) possess relevant portfolio/experience
Skills & Competencies
Technical Skills
Soft Skills
Recommended Technical Training Courses
Associate Certified Analytics Professional (aCAP)
Certification of Professional Achievement in Data Sciences
Certified Analytics Professional
Cloudera Data Platform Generalist
EMC Proven Professional Data Scientist Associate (EMCDSA)
IBM Data Science Professional Certificate
Microsoft Certified Azure Data Scientist Associate
Microsoft Certified Data Analyst Associate
Microsoft Technology Associate
Open Certified Data Scientist
SAS Certified Advanced Analytics Professional Using SAS 9
SAS Certified Data Scientist
Data Visualization with Tableau
Power BI