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:

Data Architect (Insurance)
Location: Johannesburg
Salary:
Today


Specialist Dealer: Commissions
Location: Midrand
Salary: 200 Hourly
Our client, a leading organization within the telecommunications Industry, is seeking a highly experienced Specialist: Dealer Commissions .The successful candidate will be responsible for the accurate administration and execution of all trade partner commission payments, ensuring compliance with company policies and contractual agreements. This role will oversee acquisition and retention accountin...
1 day ago


Junior Data Administrator
Location: Centurion
Salary: 300 000 Annually
An exciting opportunity for a detail-driven data professional to join a dynamic environment where data drives decision-making. If you enjoy transforming raw data into meaningful insights and working across systems, this role is for you.
1 day ago


Finance Systems Analyst
Location: Johannesburg
Salary: 740000 Annually
An exciting opportunity exists for a highly analytical and systems-driven Finance Systems Analyst to join a leading financial services environment.
5 days ago


Senior Data Modelling – Enterprise Data Warehouse (EDW)
Location: Johannesburg
Salary:
We are seeking an experienced Senior data Modelling – Enterprise data Warehouse (EDW) professional to lead the design, development, and governance of enterprise-scale data models that support strategic reporting, analytics, business intelligence, and data-driven decision-making.
5 days ago


Technical Information Analyst
Location: Johannesburg
Salary:
We are seeking a detail-oriented and analytical Technical Information Analyst to join our growing team. In this role, you will be responsible for collecting, analyzing, organizing, and maintaining technical information to support business operations, decision-making, compliance, and knowledge management initiatives.
5 days ago


Divisional Finance Manager – Health & Hospitality
Location: Johannesburg
Salary:
5 days ago


Senior Business Application Analyst
Location: Johannesburg
Salary:
Are you a data-driven problem solver with a passion for finance and technology? Step into a senior role where you’ll bridge the gap between business, data, and systems to drive impactful digital transformation and business intelligence solutions.
5 days ago


Senior BI Developer
Location: Johannesburg
Salary: 60000 Monthly
We are looking for a Senior Business Intelligence Developer to design, build, and maintain bi solutions that provide actionable insights.
5 days ago


Senior Business Analyst and Reporting Specialist
Location: Johannesburg
Salary: 60000 Monthly
We are seeking a Senior Business Analyst & Reporting Specialist to act as the key link between Finance, Operations, and IT. This role is responsible for driving business intelligence and reporting initiatives that support strategic and operational decision-making. The successful candidate will work closely with stakeholders to identify business needs, deliver data-driven solutions, and lead a ...
5 days 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