Data Analyst

PEP; Parow; On-site; ZAR 540,000 - 900,000; Full time

Job summary

PEP is seeking a creative and data-driven analyst to transform diverse data sources into interpretable datasets and dashboards that support business decisions. You will acquire, transform and validate data, interpret results and provide ongoing insights that drive efficiencies and risk reduction.

The role requires 5–8 years in a similar analytics job, experience with test-driven development, strong SQL skills, and familiarity with GCP/BigQuery, Looker Studio, Business Objects or Qlik.

Qualifications

• 5-8 years experience in a similar analytics role.
• Experience with test-driven development.
• Knowledge of data warehousing and dimensional modeling is advantageous.

Responsibilities

• Acquire, transform and integrate data from multiple sources into usable datasets.
• Interpret data, analyze results and provide ongoing reports.
• Identify trends and patterns in complex data sets.
• Develop and maintain BI reports and dashboards.
• Test and validate solutions per specifications and user requirements.
• Ensure data governance, protection, retention and standards.
• Training and knowledge transfer to stakeholders.

Skills

Analytical skills

Data analysis

SCRUM/Agile

Communication

Team player

Attention to detail

Education

Business degree with analytical subjects

BSc in Computer Science/Math/Engineering or equivalent

Tools

SQL

GCP/BigQuery

Looker Studio

Business Objects

Qlik

Job description

The role requires a person who is creative and passionate, and willing to challenge the status quo by helping the organisation find efficient and effective solutions that support business processes and decision making. We are looking for an individual with experience using a variety of data visualisation tools and analysis methods used to turn data into actionable insights with demonstrated business impact.

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

• Acquire, combine and transform data from various sources into interpretable datasets.
• Interpret data, analyse results using statistical/analytical techniques and provide ongoing reports.
• Identify, analyse, and interpret trends or patterns in complex data sets.
• Develop and maintain BI reports and dashboards.
• Test and validate solutions in accordance with specification and user requirements.
• Data management and governance in terms of data protection, compliance, retention, archiving guidelines, data standards etc.
• Training /Knowledge acquisition and transfer.

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 segregation techniques
• Knowledge and experience of SCRUM/Agile
• Strong analytical skills with the ability to collect, organize, analyse, 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
• Good communication skills and a team player that can cope in a dynamic environment