Data Analyst

SUMMARY:
Data Analyst (12 months Fixed-Term Contract)

POSITION INFO:

Job purpose

The purpose of this role is to develop, validate data scripts and ensure that data and Extract, Transform and Load (ETL) solutions meets the organisation’s business requirements.

Key performance Areas

• Perform detailed analysis of ERDs from different data sources
• Perform detailed review of data requirements from functional system specification document
• Design and develop scripts for testing the completeness and correctness of the data solutions
• Design and develop scripts for testing the standardisation of data between the different data sources
• Design and develop scripts to testing the normalisation of data between different data sources
• Review the indexing of data in the new database and assess the performance
• Create Reports that verifies the results of all development
• Perform data analysis and data driven testing in SQL
• Report and manage bugs/defects
• Develop test progress reports
• Identify and report risks and issues
• Verify the completeness / correctness of the mapping of data between the different data sources

Minimum Requirements

• Relevant University Degree in IT or equivalent
• Minimum 3-year experience working on ETL and database development using SSIS and SSRS
• Minimum 3-year experience working with PowerBi and SharePoint online
• Experience working with large data sets and data warehousing, including BI testing
• Solid understanding of software and data quality frameworks
• Extensive MSSQL 2016 and above skills and experience required
• Certification in database development would be an advantage

NB! This job is now closed. You can apply for other jobs by uploading your CV.