EMPLOYMENT TYPE :
Contract until June 2021 with high possibility to be extended thereafter.
LOCATION : Cape Town
JOB OVERVIEW :
The successful candidates will be part of a highly dynamic and analytical team working in an agile environment.
Guided by the Lead Analyst, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights.
They will assist in specifying complex business rules using the specified toolsets to enable the Data Modelers to create complex analytical models.
Hence, they need to understand and continuously seek to build knowledge of data and information. In addition, they should be able to use the technology and seek to make use of the features therein to deliver value to the business.
The Data Analysts will not only analyse data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice.
A high competency in problem solving capabilities is thus essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to the team.
An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance.
It is essential that the candidates exhibit and maintain a positive attitude in a highly agile technical and business environment where information forms the foundation to gain a competitive edge in the market.
DESCRIPTION OF THE POSITION :
Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.
Identify and define the business rules associated with the data; these should include all data integrity / constraint requirements.
Identify and perform detailed analysis of all data sources for each application and subject area.
Perform data profiling of data contained in source systems.
Provide the data mapping and associated transformation rules for each data items.
Ensure that the development activities are supported by accurate information.
Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-level, integrated, etc.).
Assist Data Modelers to draw up detailed data models.
Present data quality anomalies and problem areas to business users and source system owners.
Validate data models against the business- and data requirements.
Ensure the quality, accuracy, integrity and conformity to standards of all models.
Provide accurate metadata, which allows full understanding of the project data components.
Identify data and data model inconsistencies and conflicts and assist the users in their resolution.
Transition information and assist developers with the data mapping and transformation and provide additional data analysis as required during the development phase.
Communicate project data-related information to Architects, DBA’s, Developers and Users.
KNOWLEDGE AND SKILLS :
A solid background in SQL is required.
Experience working on SAP Hana is preferred and highly advantageous.
Data warehousing principles based on Kimball and Vault patterns
Analysis experience in BI
Knowledge of data profiling and data profiling tools.
Experience with data quality management strategies and life cycles.
Meticulous attention to detail
Highly organised person
Structured investigation and troubleshooting skills
Never give up attitude
Team worker to lead by example
Documenting of process detail
Focus on the detail but understand the high-level deadlines to enable delivery on time with limited time
Functionally and operationally inclined.
Proactive and a fast learner with a thirst for continuous knowledge enhancement.
Love collaborating towards a common goal.
Committed and solution orientated.
Ability to articulate thoughts and problem statements well.
Ability to remain motivated despite curveballs and pressure.
Can motivate people and great at cultivating a culture of teamwork.
EXPERIENCE REQUIRED :
4+ years' experience as a data analyst in a BI environment.
Solid SQL skills
Ability to work with data profiling, data quality and reference data toolsets.
Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field / National Diploma in an Information Technology related discipline.
Please note : If you have not heard from us within 2 weeks, please consider your application unsuccessful.