Microsoft BI Data Engineer (SSIS, SSAS, Power BI)



PBT Group

Job Ref:


Date posted:

Friday, August 5, 2022


Johannesburg, South Africa



PBT Group has a requirement for a Microsoft BI Developer who knows SSIS, SSAS and SSRS.


- Microsoft BI: Strong SQL, SSIS, SSAS, SSRS

- Strong modular system design skills.

- Conventional and data warehouse modelling skills are required, in order to understand the various data models and to define the mappings between them.

- System analysis and design skills are necessary to design and document the data extractions and transformations.

- Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.

- Good organisation, planning and basic management skills.

- Good interpersonal and communication skills.

- Decision making and problem solving skills.



- Relevant data warehouse and BI solution training is essential.

- B.Sc. or related degree is advantageous.

- 5+ years programming experience.



Duties: Back-end

- Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.

- Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.

- Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.

- Perform root cause analysis, performance monitoring and application related issues.

- Review IT work products from the team members for completeness and quality.

- Accurately translate business requirement to technical documentation and test case or results.

- Analyse and map data from source systems to target operational data stores and data marts.

- Maintain and provide application support in production.

- Code or folder migration from one environment to another as part of release management.

- Participation in all aspects of quality assurance.

- Active participation in systems integration and user acceptance testing.


Duties: Front-End

- Create and maintain the end user applications, typically using off-the-shelf data access software or conventional query- and reporting tools.

- Develop the semantic layer, metadata, reports and report definitions.

- Develop graphs and portal interfaces.

- Load and maintain the metadata for the data access tool.

- Troubleshoot BI tools, systems and software; performance-tune these applications as necessary.

- Produce complex, efficient, error-free reporting solutions and related documentation.

- BI front end development on data structures, cubes, reporting, dashboards, etc.


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




Similar jobs you might be interested in:

Microsoft BI Developer
Location: Johannesburg
Salary: market related
PBT Group has a requirement for a microsoft bi Developer who knows ssis, ssas and SSRS.
30 days ago

Senior BI Developer (Microsoft)
Location: Johannesburg
Salary: 50 000 Monthly
Our client - a business intelligence solutions, data warehousing, data integration and data management organisation is looking for a bi Consultant to be based onsite at their client, to develop, deploy, and maintain bi tools and interfaces. bi’s provide integral technical solutions to the needs of stakeholders by interpreting business requirements, defining technical tasks, engineers&rs...
16 days ago

SQL ETL Developer – Randburg up to R900k per annum cost to company
Location: Johannesburg
Salary: 900 000
SQL ETL Developer – Randburg up to R900k per annum cost to company

BI Developer
Location: Johannesburg
Salary: Annually
We are looking for a bi Developer. The candidate must be highly exceptional and bring fresh ideas to the team of Business Intelligence.
1 day ago

Business Systems Analyst – Roodepoort
Location: Roodepoort, Gauteng
Salary: Market Related
Business Systems Analyst – Roodepoort
1 day ago

BI Developer
Location: Johannesburg
Salary: 700000 Annually
Role: Senior Business Intelligence Developer Location: Johannesburg NorthCompany: Large well known ICT company offering an exciting fast paced work environment within the ever changing technology landscape.
1 day ago

BI Developer
Location: Johannesburg
Salary: Annually
My client is looking for a bi Developer to join their new division.
1 day ago

Business Analyst
Location: Pretoria
Business Analyst - FMCG
1 day ago

Senior Data Warehouse Developer - (CONTRACT)
Location: Johannesburg
1 day ago

Data Warehouse Developer
Location: Johannesburg
1 day ago

Create a free job alert for Microsoft BI Data Engineer (SSIS, SSAS, Power BI) 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