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

Recruiter:

PBT Group

Job Ref:

1483144838

Date posted:

Friday, August 5, 2022

Location:

Johannesburg, 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:

Management Accountant !!!
Location: Johannesburg
Salary:
Calling All Management Accountants: Look to the Future, Not Just the PastAs the midyear point approaches, many finance professionals are quietly evaluating whether their current role offers true commercial influence or merely repetitive transactional processing. If you are a forward-looking Accountant who thrives on planning, budgeting, and guiding executive decision-making. This is not a gen...
1 day ago

Enterprise Architect
Location: Johannesburg
Salary:
Step into a strategic role where you’ll help shape and guide enterprise-wide technology transformation initiatives. This opportunity is perfect for an experienced professional who enjoys bridging business needs with robust IT architecture while driving innovation across complex environments.
2 days ago

IT Manager
Location: Johannesburg
Salary: 70 000 Monthly
A dynamic, growth-focused organisation is seeking an experienced IT Manager to join its team. The successful candidate will take ownership of the full IT function, providing both hands-on technical support and strategic leadership across all IT systems, infrastructure, and service delivery.This role requires a proactive, solutions-driven professional who is comfortable operating in a fast-paced en...
4 days ago

IT Manager
Location: Johannesburg
Salary: 70000.00 Monthly
A dynamic, growth-focused organisation is seeking an experienced IT Manager to join its team. The successful candidate will take ownership of the full IT function, providing both hands-on technical support and strategic leadership across all IT systems, infrastructure, and service delivery.This role requires a proactive, solutions-driven professional who is comfortable operating in a fast-paced en...
4 days ago

Technology Architect
Location: Johannesburg
Salary:
Key Purpose:The company operates in a data-intensive environment where vast volumes of information must be sourced, switched, structured, validated, stored, secured, and made readily available to the business. Technology is not just an enabler—it is a strategic imperativeThe purpose of this role is to architect and govern enterprise-grade data platforms that leverage the microsoft Azure ecos...
5 days ago

Senior Stock Controller
Location: Johannesburg
Salary:
When inventory is managed well, nobody notices.When it isn't, everyone feels it.From profitability and cash flow to customer service and operational efficiency, stock management sits at the centre of business performance.We are looking for a Senior Stock Controller who understands exactly that.This opening is for a professional who sees beyond stock counts and understands inventory as a strategic ...
5 days ago

FIELD SERVICES TEAM LEADER (OPERATIONS MANAGER) - EE
Location: Johannesburg
Salary: R1.2 – R1.4 MILLION PKG (+ COMPANY CREDIT CARD & VEHICLE WHEN TRAVELLING)
OEM EQUIPMENT & SERVICES (MINING SECTOR)
6 days ago

CUSTOMER (TECHNICAL) SUPPORT SPECIALIST - EE
Location: Johannesburg
Salary: UPTO R800 000 to R850 000 PKG, COMPANY BONUS, PERFORMANCE BONUS
OEM EQUIPMENT & SERVICES (MINING SECTOR)
6 days ago

Data Platform Engineer (36 Months FTC - Wits Health Consortium)
Location: Parktown
Salary: Monthly
Background:Wits Health Consortium (Pty) Limited ("WHC") is a wholly-owned Company of the University of the Witwatersrand, Johannesburg (South Africa) under its Faculty of Health SciencesWHC provides Faculty with a legal framework within which to operate the research and other activities necessary to support its academic objectivesIn addition, WHC offers a range of products and services to Academic...
6 days ago

Dynamics 365 CE & Power Platform Technical Lead
Location: Gauteng
Salary: Market related
Develop and customize Dynamics 365 CE solutions using C#, .NET, JavaScript, and power Platform
6 days ago

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

Similar jobs you might be interested in:

Create a free job alert for Microsoft BI Data Engineer (SSIS, SSAS, Power BI) in Johannesburg