Data Warehouse Administrator

 

Recruiter:

Network Recruitment International

Job Ref:

NCM000274/TS

Date posted:

Tuesday, August 16, 2022

Location:

Johannesburg, South Africa

Salary:

400 Hourly


JOB SUMMARY:
Market leading company offers an opportunity for a dynamic, skilled Data Warehouse Administrator that brings with them the expertise to integrate more than one system & to deliver outputs in line with a focus on outcomes with great communication and attention to detail.

JOB DESCRIPTION:

Important aspects of the role includes;
  • Oracle
  • ETL
  • SSIS
  • Integration of more than one system
  • Ralph Kimball Star schema

    Data Warehouse Administrator position
Position: Fixed Term Contractor for 6 months. Contract to be reviewed again after 6 months. Possible permanent position in the future.

Requirements
  • At least Three years or more experience performing data warehouse architectural development and management;
    1. being the responsible person (not just an assistant) for the Data Warehouse of
    2. a medium to large size organization with a Data Warehouse where there were
  • integration with at least five other source systems
  1. built on Ralph Kimball Star-schema best practice methodology.
  2. High proficiency in dimensional modelling techniques and their applications is a definite requirement.
  • Strong SQL skills
  • Excellent problem solver (ability to think logical and systematically).
  • Honest!
  • Excellent communication skills Ability to focus on the required outcomes and to translate that into task lists, whilst keeping sight of the result.
  • High EQ Excellent time management skills and be able to prioritize on the fly Attention to detail and a focus on quality.
    • Able to reconcile sets of data (in order to find issues) and not to settle for approximate accuracy.
    • Not to let pressure from clients to finish allow for compromise on quality. If something takes longer than expected because of unexpected data issues that surfaced, then the client’s expectation needs to be managed, not the quality compromised. The issue can be escalated to a senior to assist with managing the client’s expectation so we as a Team will still succeed.
  • Able to work well in a A self-starter Ability to focus well.
  • Excellent experience with technologies including
    • Oracle database and
    • SQL Server (including SSIS),
    • as well as some exposure to newer ones like Mongo DB and stored procedures
  • Working experience with reporting and analytical tools (i.e. Cognos, Tableau, SportFire, TIBCO, QlikView, MicroStrategy, Information Builders) advantageous.
  • Working knowledge of SAS and R code used in data processing and modelling tasks advantageous
  • Experience with DataManager/ DataStage, SSIS advantageous

Other Requirements
  • Able to work on site in Randfontein
  • Need to be able to pass a medical fitness examination
  • Preferred Meyers Briggs type : ISTJ/INTJ
  • Woman
  • Not white
  • To live the company’s values
  • Must be trustworthy and responsible working with sensitive Company data (high sense of responsibility).
Job Description
  • Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
  • Carry out monitoring, tuning, and database performance analysis
  • Provide technical support as and when required and where user support needs overlaps with front-end models/reports, to co-ordination with Team members during warehouse design, testing and moving to Prod
  • Daily monitoring of schedules and required updates and to pro-actively address any issues/concerns
  • Change Advisory Board documentation logging for new changes and following Company policies and procedures as it applies, including POPI Act requirements.
  • Attend and or arrange relevant meetings in order to achieve desired business and/technical outcomes.
  • Pro-active approach in data management (sanity checking of data and address/alert the Team of any potential new issues).
  • Escalate performance issues to the relevant parties pro-actively and arrange for the necessary communication to users if for some reason a report becomes problematic on a specific day.

Thank you,
Theresa Steenkamp
Key Account Manager - Network Contracting Solutions

 

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



 

 

 

Similar jobs you might be interested in:

Data Warehouse Developer
Location: Johannesburg
Salary:
This is an exceptional opportunity to dive in and contribute to building the company's data warehouse from the ground up! Our client seeks a data warehouse Developer who will spearhead the design, development and upkeep of the enterprise data warehouse. You will join a technical team responsible for overseeing data warehousing, data analytics , reporting and data sciences initiatives across t...
13 days ago


Data Warehouse Manager - IT
Location: Centurion
Salary: R900k - 1.2m per year
data warehouse Manager - IT
20 days ago


Data Warehouse Manager - IT
Location: Centurion
Salary: R900k - 1.2m per year
data warehouse Manager - IT
20 days ago


Sales Administrator
Location: Kempton Park
Salary:
2 days ago


Analyst Developer
Location: Johannesburg
Salary:
1 day ago


Business Intelligence Developer
Location: Johannesburg
Salary:
JOB PURPOSE:This role requires an experienced and highly skilled senior business intelligence specialist with expertise in Microsoft Stack, specifically with strong experience in data warehousing, data lake technologies, and Power BI. The incumbent will serve as the technical expert responsible for designing, developing, and maintaining robust and scalable business intelligence solutions using Mic...
2 days ago


Oil Storage Warehouse Supervisor (Centurion)
Location: Centurion
Salary: 10000 Monthly
Job Purpose:Leading a team primarily responsible for the handling and storage of Oil products. Responsible for the day-to-day management of staff within the Oil warehouse function, to ensure that the company’s targets and objectives are met and to meet the customer requirements.  Ensure that the staff comply with health, safety, and standard operating procedures.Qualifications and Exper...
2 days ago


PAM 415456 - Storeroom/Inventory Controller – Manufacturing – Randburg
Location: Johannesburg
Salary: R150K - R200K
Storeroom/Inventory Controller – Manufacturing – Randburg
2 days ago


SSAS Cubes Developer
Location: Johannesburg
Salary:
2 days ago


Senior Oracle Developer
Location: Johannesburg
Salary:
Key deliverables:Participate in the interpretation of business requirements and functional specifications as provided by the business analyst into Integration solution designs to implement all Integration flows (technical specifications, detail designs etc).  Development of the integration flow function using appropriate technology toolsets to pass data through integration according to approv...
3 days ago


Create a free job alert for Data Warehouse Administrator in Johannesburg

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions