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:

Senior Data Warehouse Developer
Location: Johannesburg
Salary:
Are you a data-driven problem solver who thrives on turning complex datasets into meaningful business insights? A leading financial services group is seeking a Senior Data warehouse developer to design, develop, and optimise enterprise-level data warehouse solutions. This role is ideal for a technically strong professional who enjoys collaborating with stakeholders and delivering high-quality repo...
6 days ago


Senior Business Intelligence Developer
Location: Johannesburg
Salary:
88 days ago


Senior Data Warehouse Developer
Location: Centurion
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a Senior Data warehouse developer to join our financial services client based in centurion.
27 days ago


Senior BI Developer
Location: Johannesburg
Salary: 450000 Annually
Are you a data-driven problem solver who thrives on building robust BI solutions and turning complex data into meaningful insights? We’re looking for a Senior BI developer to join a dynamic and fast-paced environment where innovation, collaboration, and continuous improvement are key.
5 days ago


Microsoft Fabric Specialist (Data Engineering, Governance & DWH) (Onsite – JHB) (Contract)
Location: Johannesburg
Salary:
6 days ago


BI Specialist
Location: Johannesburg
Salary:
Our client is seeking a highly skilled and analytical BI Specialist who has a fundamental desire to transform complex financial data into actionable intelligence that drives business success. In this pivotal role, you will be the bridge between raw data and strategic decision-making, creating optimized BI solutions that empower our executive leadership and management. If you are an expert in the M...
20 days ago


Senior Director: Software Engineering
Location: Pretoria
Salary:
Our client, an award-winning MedTech, is looking for a Senior Director: Software Engineering to join their team.
26 days ago


Software Engineering Director
Location: Pretoria
Salary:
Our international client, based in Pretoria, is seeking a Software Engineering Director to lead multi-disciplinary development teams across Mobile, Web and Test Engineering. The role partners closely with Architecture, Platform and Data functions to shape product and project strategy, oversee capacity planning and define technical direction.As the subject matter expert for front-end development an...
15 days ago


Senior Data Engineer
Location: Johannesburg
Salary:
49 days ago


Actuarial Analyst
Location: Johannesburg
Salary: 70000 - 80000
Join a life insurer committed to financial responsibility and innovation. We’re seeking a Junior Actuarial Analyst to support our Actuarial Valuations team – a core function responsible for financial reporting, reserving, capital monitoring, and strategic insights.
42 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