SQL Warehouse Developer - Centurion

 

Recruiter:

ES Recruitment

Job Ref:

ES046

Date posted:

Friday, July 23, 2021

Location:

Pretoria, South Africa

Salary:

Market related


SUMMARY:
SQL Warehouse Developer

POSITION INFO:

 SQL Warehouse Developer

Position based in Centurion

6 month contract with possible extension

Our client in the finance industry is looking for a SQL Warehouse Developer

EXPERIENCE AND QUALIFICATIONS

  • IT Degree
  • 3-5 Years development experience within a SQL data lake and warehouse environment within the Financial Sector and
  • Must have knowledge of the Software Development Lifecycle

 

Development Software

  • Have practical knowledge of T-SQL (2-5 years),
  • Exposure and knowledge of Oracle, DB2, MySQL, MS Access, Mongo and PostgreSQL will be an advantage.
  • Have practical experience of SQL Server Database Engine (2-5 years).
  • Have practical experience of MS SSIS ETL software (2-5 years).
  • Knowledge of MS SSAS OLAP software would add an advantage.
  • Have practical experience of MS Visual Studio Data Tools (2-5 years).
  • Should have a good understanding of source control systems and the concepts of building and releasing software versions.
  • Microsoft TFS knowledge is preferred.
  • MS SSRS and/or PowerBI report development experience

 

SKILLS

Methodologies

  • Have a clear understanding of Agile methodologies.
  • Be familiar with Waterfall methodology.
  • Be able to demonstrate hybrid integration of both Agile and Waterfall when required.
  • Have solid understanding of Metadata, Master Data Management (MDM) and Data Architecture.

 

Principles

  • Be familiar with Software development principles such as SOLID, TDD, Separation of Concerns, Loose Coupling
  • Have a clear understanding of Data warehouse principles.
  • Be familiar with n-tier layered architecture (3-5 years).

 

Modelling

  • Should have data modelling skills and should be able to interpret conceptual, logical and physical data models. (3 – 5 years).
  • Should be able to translate business requirements into technical designs with appropriate data modelling.
  • Should have proven data modelling techniques including normalization skills.
  • Must be familiar with data warehousing principles, based on the Kimball and/or Inmon architectures.


 

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



 

 

 

Similar jobs you might be interested in:

IT Asset Management Coordinator (Tech Tracker)
Location: Johannesburg
Salary:
A dynamic opportunity is available for a detail-oriented and proactive IT Asset Management Coordinator to join an organisation that’s reshaping how businesses manage their tech infrastructure. This role is ideal for someone who thrives on structure, loves data accuracy, and enjoys collaborating with clients to drive continuous improvement.
7 days ago


Data Engineer (Oracle, Databricks & Insurance) – Johannesburg – up to R850k per annum
Location: Johannesburg
Salary: 850000
Data Engineer (Oracle, Databricks & Insurance) – Johannesburg – up to R850k per annum
56 days ago


Oracle Fusion Specialist / Oracle Engineer- Johannesburg – up to R900k per annum
Location: Johannesburg
Salary: 900000
Oracle Fusion Specialist / Oracle Engineer- Johannesburg – up to R900k per annum
56 days ago


Data Engineer (Oracle, Databricks) -Johannesburg- R650k to R850k per annum
Location: Johannesburg
Salary: 850000
Data Engineer (Oracle, Databricks) -Johannesburg- R650k to R850k per annum
63 days ago


Power BI Specialist – Johannesburg - R700k to R900k per annum
Location: Johannesburg
Salary: 700 000
Power BI Specialist – Johannesburg - R700k to R900k per annum
70 days ago


Data Engineer
Location: Johannesburg
Salary: 840000 Annually
Apply here to showcase your Data Engineer skills! Work with modern tech, big data, and a team that loves clean, scalable solutions.
7 days ago


SQL Data Engineer
Location: Centurion
Salary: market related Monthly
Role PurposeOur client offers a collaborative and dynamic work environment. By joining their team, you'll have the opportunity to contribute meaningfully to their data-driven strategies while growing in a culture that values innovation, excellence, and service. RequirementsTechnical Skills:Advanced proficiency in sql Transact, sql Server, SSIS, and SSRS, including performance tuning and query...
8 days ago


SQL Data Engineer (12 month contract)
Location: Centurion
Salary: 1000 Monthly
Our client offers a collaborative and dynamic work environment. By joining their team, you'll have the opportunity to contribute meaningfully to their data-driven strategies while growing in a culture that values innovation, excellence, and service.
9 days ago


Sage Specialist Developer (36 Months)
Location: Pretoria
Salary:
We are recruiting for a Sage Specialist developer role. The ideal candidate will be responsible for developing, customising, and integrating Sage ERP systems to support business process automation.
11 days ago


Data Engineer
Location: Centurion
Salary:
Our client is seeking a skilled Data Engineer to join their growing team. If you are passionate about the technical aspects of the data landscape and thrive on building optimized processes that deliver high-quality, reusable datasets, then this could be the perfect opportunity for you.
11 days ago


Create a free job alert for SQL Warehouse Developer - Centurion in Pretoria

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