Data Analyst
Heitha Staffing Group
Pretoria, South Africa
2d ago
source : Job Placements

Main Objective :

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

Duties :

  • 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 :

  • 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.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form