Senior SSIS ETL Developer

Recruiter:

PBT Group

Job Ref:

PBT3288194237

Date posted:

Friday, September 17, 2021

Location:

Johannesburg, South Africa

Salary:

Market Related

SUMMARY:
PBT Group has an opportunity for a Senior SSIS ETL Developer. Responsible for the construction of complex BI Solutions based on specifications produced by the BI Architects and Systems Analysts (BI Solutions imply ETL / Analytics / Presentation).

POSITION INFO:

PBT Group has an opportunity for a Senior SSIS ETL Developer. Responsible for the construction of complex BI Solutions based on specifications produced by the BI Architects and Systems Analysts (BI Solutions imply ETL / Analytics / Presentation).

Driving Engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and QA Manager.

Duties:

- Develop and maintain SSIS packages

- Create required database structures

- Develop and maintain T-SQL code

- Analyse SQL execution plan to optimise performance

- Version control of developed solutions

- Develop and maintain SSAS models

- Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications

- Contribute to the development of architectural guidelines and standards

- Prototyping, Research and Development of new techniques and solutions

- Peer review of code and solutions developed

- Team engagement champion

- Improving robustness and stability of ETL batches

- Scheduling business processes via ETL tools

- Create Metadata repositories

- Dynamic SQL

Experience:

- 4+ years SQL Server (SSIS) BI Development in Finance/Risk environment

- Advanced experience in: T-SQL, SQL, SQL Server BI Stack (SSIS, SSAS, SSRS, SSMS), MS Excel

- Advanced knowledge of: SDLC, Data Warehouse principles and practices, Kimball Methodology

- Intermediate experience in: Dimensional Modelling

- Intermediate knowledge of: Data Security and Protection Policies, Health Insurance industry knowledge

- Experience in MDX & DAX would be highly advantageous

- A basic understanding on Data Mining required

Qualifications/ Certification:

- National Diploma in Information Technology or a Bachelor’s degree (Essential)

- Kimball related courses (dimensional modelling) (Advantageous)

- Certification on Microsoft or other ETL Tools (Advantageous)

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 Engineer
Location: Johannesburg
Salary:
69 days ago

Senior Business Intelligence Developer
Location: Johannesburg
Salary:
88 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

Business Intelligence Developer
Location: Johannesburg
Salary: 400000 Annually
New Opportunity: BI developer - Gauteng
6 days ago

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

BI Specialist
Location: Johannesburg
Salary:
Where Data Becomes Direction. If you believe data should do more than sit in tables, this role speaks your language. Step into a space where insights move leaders, automation improves processes, and analytics shape the future of financial services. This is your opportunity to design BI solutions that don’t just report the story… They change it.
18 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

BI Data Engineer
Location: Johannesburg
Salary:
As a senior Data Engineer in Business Intelligence, you’ll be the architect behind scalable, secure data systems that power real-time insights across the logistics value chain. From building high-performance ELT pipelines and integrating complex platforms to delivering clean, trusted datasets, you’ll enable automation, cost optimisation, and smarter decision-making. This role is all ab...
22 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 SSIS ETL Developer

Similar jobs you might be interested in:

Create a free job alert for Senior SSIS ETL Developer in Johannesburg