SQL BI Developer

 

Recruiter:

PBT Group

Job Ref:

3951591681

Date posted:

Thursday, June 2, 2022

Location:

Cape Town, South Africa


JOB SUMMARY:
-

JOB DESCRIPTION:

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

REQUIRED SKILLS:

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

 

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:

BI Developer
Location: Cape Town
Salary:
3 days ago


Data Engineer
Location: Cape Town
Salary:
3 days ago


Business Analyst / BI Manager
Location: Somerset West
Salary:
An established fruit marketing concern based in Somerset West is seeking to employ a Business Analyst / bi Manager to join their team. The main purpose of the position is to gather and channel information from their various systems throughout primary agriculture, production, cooling and marketing divisions into a centralised information system with reports that allow management to effectively...
9 days ago


Data Analyst
Location: Stellenbosch
Salary:
In a universe of raw data, absolute truth is often hidden. A pioneering collective seeks a Relativistic Observer—a thinker who understands that insight depends entirely on one’s frame of reference. Your role is not to simply report numbers, but to bend the fabric of data, to observe it from new dimensions, and to reveal the elegant, hidden equations that define reality.
11 days ago


Manager: Collections Strategy
Location: Cape Town
Salary:
Manager: Collections StrategyAre you a strategic thinker with a passion for transforming collections performance through data, modelling, and optimisation?We’re looking for a Manager: Collections Strategy to lead the development, implementation, and enhancement of strategies that improve collections efficiency, increase book performance, and drive meaningful business impact.This is an opport...
Today


Data Analyst - Risk & Fraud
Location: Cape Town
Salary: Annually
Data Analyst - Risk & Fraud
4 days ago


Senior Automation Tester
Location: Cape Town
Salary: R100 000 Monthly
Are you passionate about automation and quality assurance? Join a leading financial technology company and play a key role in shaping cutting-edge solutions that impact millions of users!
4 days ago


Manager: Collections Strategy
Location: Cape Town
Salary:
Ready to Own a National Collections Strategy?
4 days ago


Fraud / Risk Specialist - Montague Gardens (Cape town) EE/AA
Location: Capetown
Salary: Market Related
Calling all Fraud, Risk and Forensics experts!
4 days ago


SQL Data Engineer
Location: Cape Town
Salary:
7 days ago


Create a free job alert for SQL 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