Jobs at PEP

Description

A unique opportunity for a BI Analyst  exists at South Africa’s friendliest retail brand.

We are looking for a passionate expert that has a creative flair, and is not afraid to challenge the status quo

to find efficient and effective solutions that support business processes and decision making. The role is responsible for the design and delivery of robust reporting and data visualisation solutions that support operational and analytical needs.

Key responsibilities

• Conduct impact assessments to understand and mitigate risks to systems and business processes. 
• Obtain, manipulate and analyse business data to derive insights.
• Develop dashboards and reports to provide insights for decision making and help highlight trends and patterns in data sets.
• Provide technical support for simple support requests and resolve timeously.
• Write SQL queries where applicable or utilise data solutions tool sets.  
• Test and validate solutions in accordance with specification and user requirements.
• Visualize data using appropriate tools.

Requirements

Required Knowledge, Skills and Competencies 

• Business degree with Analytical/Commercial subjects, Bachelor degree in Computer Science, Mathematics, Engineering or equivalent NQF level 8 qualification
• Minimum 5+ years’ Business Intelligence experience
• Experience with test-driven development
• BI Analysis, data design or analysis experience in a data and analytics environment
• Advanced working knowledge of SQL
• Retail knowledge and experience will be an advantage
• Proficient in Google Workspace, MS Office Suite, Qlik/BO, Data/looker Studio and GCP will be advantageous
• A curious self-starter who takes initiative, investigates problems, see possibilities and takes action

go to method of application »

Purpose of the job

To create a central governance competency to reduce risks, create efficiencies, maximise the return on data management efforts within the business and to ensure Data solution applications incorporate industry standards and best practices that will enable the business to do self-service data analytics. 

Key responsibilities

• Conduct impact assessments to understand and mitigate risks to systems and business processes. 
• Obtain, manipulate and analyse business data to derive insights.
• Develop dashboards and reports to provide insights for decision making and help highlight trends and patterns in data sets.
• Provide technical support for simple support requests and resolve timeously.
• Write SQL queries where applicable or utilise data solutions tool sets.  
• Test and validate solutions in accordance with specification and user requirements.
• Visualize data using appropriate tools.

Requirements

Required Knowledge, Skills and Competencies  

• Business degree with Analytical/Commercial subjects, Bachelor degree in Computer Science, Mathematics, Engineering or equivalent NQF level 8 qualification
• 5-8 years experience within a similar role
• Experience with test-driven development
• Knowledge and experience with relevant software packages will be advantageous (GCP/BigQuery, Data/Looker Studio, Business Objects, Qlik, SQL)
• Technical expertise regarding data models, database design development, data mining and segmentation techniques
• Knowledge and experience of SCRUM/Agile
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Knowledge of and exposure to Data Warehousing (Kimball/ Data Vault patterns), Dimensional/Relational data Modeling (OLAP/OLTP) advantageous
• Knowledge and understanding of columnar databases advantageous
• Presentation skills
• Good communication skills and a team player that can cope in a dynamic environment
• Competencies Required: Analytical, Decisive, Assertive, Cooperative, Persuasive, Creative, Persuasive,  Innovative, Business Acumen, Integrity, Drive.