Posted on: 03 August 2023
ID 876935

Data Science / BI

Main Purpose of Role

Responsible for the back-end development of scripts to transform data for reporting. Maintaining queries, adding new data sources, automating of data manipulation, and investigating discrepancies.

Data governance to ensure back-end development across different systems delivers accurate data to business.

Required Minimum Education / Training
  • Matric
  • 7 years development experience
  • 2 years experience in report building
  • Advanced excel knowledge
  • Good understanding of linking data and setting up connections to database
  • 6 years experience with SQL
  • 7 years in a development / data role
Key Performance Areas
  • Creating queries/scripts/tasks to automate the data manipulation needed to setup a data warehouse for the BI environment
  • Adjusting queries to run optimally and to all use the same source of information.
  • Importing and storing new data sources within the BI environment
  • Developing reporting tables by summarizing and linking data, automating queries in SQL.
  • Creating business rules aligned with POPPI act to delete / archive older information
  • Creating checks to ensure back ups run, jobs for data manipulations run and environment is updated correctly
  • Maintenance of the BI databases, clear out tables no longer needed and creating indexes to increase efficiencies
Desired Skills
  • Data science
  • Scientist
  • data
  • BI
  • Business Intelligence
  • SQL
  • Development
  • develop
  • script
Desired Work Experience
  • 5 to 10 years
Desired Qualification Level
  • Degree
Occupation:
Management, human resources jobs


This job offer is not active at the moment.
Apply for a job
You have already applied to this job position
Save ad
General Workers apply now

General Workers apply now

Hulamin Company
Durban City
Jobin.co.za
Drivers And Van Assistant

Drivers And Van Assistant

Transnet Port Terminal
Durban City
Jobin.co.za
New Staff Needed Urgently At DSV Distribution Nelspruit

New Staff Needed Urgently At DSV Distribution Nelspruit

DSV Distribution Nelspruit
Mbombela / Nelspruit
Jobin.co.za
South32 Wolvekrans Colliery Is Now Hiring
Jobin.co.za
Machine Operators

Machine Operators

South32 Wolvekrans Colliery
Middelburg
Jobin.co.za
South32 Wolvekrans Colliery Is Now Hiring
Jobin.co.za
South32 Wolvekrans Colliery Is Now Hiring
Jobin.co.za
South32 Wolvekrans Colliery Is Now Hiring
Jobin.co.za