Role Purpose:
The main purpose of this job is to source and transform a wide range of data across the business into formats that can be used by end-users to develop and improve the business and assist with making smarter decisions and delivering better products.
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, Information Systems or a related field from an accredited university or college.
- 3-to-5-year work experience as a data analyst.
- Knowledge of programming languages like SQL, Oracle, R, MATLAB, and Python.
- Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
- Experience in handling reporting packages like Business Objects, programming (Javascript, XML, or ETL frameworks), databases.
- Proficiency in statistics and statistical packages like Excel, VI to be used for data set analysing.
- In depth knowledge of data visualization software like Tableau, Qlikview, Power BI.
- Experience in working with AWS (S3) would be an added advantage.
- Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions.
- Experience in working with stakeholders to assess potential risks.
- Experience in analysing existing tools and databases and providing software solution recommendations.
- Ability to translate business requirements into non-technical, lay terms.
- High-level experience in methodologies and processes for managing large-scale databases.
- Demonstrated experience in handling large data sets and relational databases with proven SQL skills.
- Understanding of addressing and metadata standards.
- Adept at queries, writing reports, and making presentations.
- Ability to work with data profiling, data quality and reference data toolsets.
- Understanding of predictive modelling, machine-learning, clustering and classification techniques, and algorithms.
Responsibilities:
Data Management
- Managing master data, including creation, updates, and deletion and data integrity.
- Managing users and user roles.
- Provide quality assurance of imported data, working with quality assurance analysts if necessary.
- Commissioning and decommissioning of data sets.
- Processing confidential data and information according to guidelines.
- Managing and designing the reporting environment, including data sources, security, and metadata.
- Supporting initiatives for data integrity and normalization.
- Evaluating changes and updates to source production systems.
- Providing technical expertise in data storage structures, data mining, and data cleansing.
- Adhere to internal documentation, processes, protocols, and standards.
Data Analysis
- Extract and combine data from various sources and analyse information retrieved.
- Interpret data, analyse results, and provide ongoing reports.
- Leverage data to find new ways of analysing key metrics.
- Identify, analyse and interpret trends or patterns in complex data sets.
- Understand the business data flows and consumption of data in order to create new analysis that will highlight areas of improvement.
Development
- Develop & generate reports, analyses, and visualisation.
- Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
- Stakeholder Engagement – engage with stakeholders to define the requirements that would meet the specific needs of a business problem.
- Actioning and delivering on areas identified through stakeholder engagements and own insights.
- Data Integration – writing code.
- Build analytical products that promote access to data and accelerate the time to insight.
- Establish automated data processes and track key performance indicators (KPI).
- Participate in post-implementation reviews of development.
REPORTING
- Prepare, publish, and provide commentary for standing reports and dashboards on time against daily, weekly, monthly, and annual deadlines.
- Supporting the data warehouse in identifying and revising reporting requirements.
- Generating reports from single or multiple systems.
- Troubleshooting the reporting database environment and reports.
- Training end-users on new reports and dashboards.
Skills and Attributes
- Proficient in English, proficiency in Afrikaans an advantage.
- Strong mathematical skills to help collect, measure, organize and analyse data.
- Strong analytical skills.
- Strong problem-solving skills.
- High level of accuracy and attention to detail.
- Drive to automate repetitive tasks (i.e., low tolerance for repetitive activities and desire to automate).
- Strong collaboration skills.
- The ability to extract valuable insights from highly complex data sets.
- Excellent project management skills.
- Flexible and able to learn and adapt to new environments.
- Diplomatic and assertive and able to manage conflict and difficult discussions.
- Ability to maintain the confidentiality of sensitive information.
- High-level written and verbal communication skills.
Role Purpose:
The main purpose of this job is to source and transform a wide range of data across the business into formats that can be used by end-users to develop and improve the business and assist with making smarter decisions and delivering better products.
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, Information Systems or a related field from an accredited university or college.
- 3-to-5-year work experience as a data analyst.
- Knowledge of programming languages like SQL, Oracle, R, MATLAB, and Python.
- Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
- Experience in handling reporting packages like Business Objects, programming (Javascript, XML, or ETL frameworks), databases.
- Proficiency in statistics and statistical packages like Excel, VI to be used for data set analysing.
- In depth knowledge of data visualization software like Tableau, Qlikview, Power BI.
- Experience in working with AWS (S3) would be an added advantage.
- Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions.
- Experience in working with stakeholders to assess potential risks.
- Experience in analysing existing tools and databases and providing software solution recommendations.
- Ability to translate business requirements into non-technical, lay terms.
- High-level experience in methodologies and processes for managing large-scale databases.
- Demonstrated experience in handling large data sets and relational databases with proven SQL skills.
- Understanding of addressing and metadata standards.
- Adept at queries, writing reports, and making presentations.
- Ability to work with data profiling, data quality and reference data toolsets.
- Understanding of predictive modelling, machine-learning, clustering and classification techniques, and algorithms.
Responsibilities:
Data Management
- Managing master data, including creation, updates, and deletion and data integrity.
- Managing users and user roles.
- Provide quality assurance of imported data, working with quality assurance analysts if necessary.
- Commissioning and decommissioning of data sets.
- Processing confidential data and information according to guidelines.
- Managing and designing the reporting environment, including data sources, security, and metadata.
- Supporting initiatives for data integrity and normalization.
- Evaluating changes and updates to source production systems.
- Providing technical expertise in data storage structures, data mining, and data cleansing.
- Adhere to internal documentation, processes, protocols, and standards.
Data Analysis
- Extract and combine data from various sources and analyse information retrieved.
- Interpret data, analyse results, and provide ongoing reports.
- Leverage data to find new ways of analysing key metrics.
- Identify, analyse and interpret trends or patterns in complex data sets.
- Understand the business data flows and consumption of data in order to create new analysis that will highlight areas of improvement.
Development
- Develop & generate reports, analyses, and visualisation.
- Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
- Stakeholder Engagement – engage with stakeholders to define the requirements that would meet the specific needs of a business problem.
- Actioning and delivering on areas identified through stakeholder engagements and own insights.
- Data Integration – writing code.
- Build analytical products that promote access to data and accelerate the time to insight.
- Establish automated data processes and track key performance indicators (KPI).
- Participate in post-implementation reviews of development.
REPORTING
- Prepare, publish, and provide commentary for standing reports and dashboards on time against daily, weekly, monthly, and annual deadlines.
- Supporting the data warehouse in identifying and revising reporting requirements.
- Generating reports from single or multiple systems.
- Troubleshooting the reporting database environment and reports.
- Training end-users on new reports and dashboards.
Skills and Attributes
- Proficient in English, proficiency in Afrikaans an advantage.
- Strong mathematical skills to help collect, measure, organize and analyse data.
- Strong analytical skills.
- Strong problem-solving skills.
- High level of accuracy and attention to detail.
- Drive to automate repetitive tasks (i.e., low tolerance for repetitive activities and desire to automate).
- Strong collaboration skills.
- The ability to extract valuable insights from highly complex data sets.
- Excellent project management skills.
- Flexible and able to learn and adapt to new environments.
- Diplomatic and assertive and able to manage conflict and difficult discussions.
- Ability to maintain the confidentiality of sensitive information.
- High-level written and verbal communication skills.
Desired Skills:
- SQL
- Oracle
- R
- MATLAB
- Python