Senior Microsoft BI Developer

 

Recruiter:

PBT Group

Job Ref:

4191766773

Date posted:

Wednesday, June 15, 2022

Location:

Cape Town, South Africa


JOB SUMMARY:
-

JOB DESCRIPTION:

PBT Group has a requirement for a Senior Microsoft BI Developer who knows SSIS, SSAS and SSRS. Must have strong ETL

 

REQUIRED SKILLS:

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

- Ab Initio experience would be an advantage. 

- 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.

 

REQUIRED QUALIFICATIONS / TRAINING:

- Relevant data warehouse and BI solution training is essential.

- B.Sc. or related degree is advantageous.

- 5+ years programming experience.

 

DUTIES:

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:

Revenue Manager
Location: Cape Town
Salary:
7 days ago


Junior Accountant CA(SA)
Location: Brackenfell
Salary:
9 days ago


Revenue Director
Location: Stellenbosch
Salary: Monthly
Wine Estate & Hotel in the Stellenbosch / Brackenfell area is looking for a Revenue Director responsible for driving revenue performance across the business through strategic pricing, inventory management, forecasting, and data-driven decision-making. This role oversees revenue optimization for accommodation, with an oversight of ancillary revenue streams. The position works cross-fu...
15 days ago


Cloud Trainee
Location: Capetown
Salary: R17,000 - R24,000.
This role exists to support the semi-senior and senior team members while developing an understanding of accounting principles
Today


Draughtsperson & Revit Modeller
Location: Cape Town
Salary:
1 day ago


Senior Quantity Surveyor
Location: Paarl
Salary:
1 day ago


Finance Manager
Location: Stellenbosch
Salary: 60,000 CTC Neg
This role involves managing staff, directing regional operations, facilitating management meetings, reviewing performance metrics, and driving improvements across critical operational areas such as billing, debtors, leasing, facilities, and cash flow management.The successful candidate will have a strong analytical mindset, with a keen ability to assess key performance indicators (KPIs), monitor f...
2 days ago


Leasing Consultant
Location: Cape Town
Salary: 280000
Junior Leasing Consultant Jobs Cape Town | Commercial & Industrial Property | PPRA | Property LeasingA leading property development company based in East London is seeking a Junior Leasing Consultant to support leasing activities across a commercial and industrial property portfolio in Cape Town, Western Cape, South Africa.This role is ideal for a driven property professional with experience i...
2 days ago


Senior .Net Software Engineer
Location: Cape Town
Salary:
2 days ago


Credit Collections Department Manager (CH1225)
Location: Kuils River
Salary:
2 days ago


Create a free job alert for Senior Microsoft BI Developer in Cape Town

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