Data Analyst at PEP

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.