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 Analyst
Location: Johannesburg
Salary: 550000
data Analyst needed in JHB!
1 day ago

IT Specialist
Location: Johannesburg
Salary: 50000.00 Monthly
Our client is looking for a highly skilled and solutions-driven IT Specialist to take ownership of their business intelligence environment and core enterprise systems. This organisation operates within the energy and technology integration space, leveraging data, automation, and system optimisation to drive operational efficiency and strategic decision-making across the business.
1 day ago

IT Specialist
Location: Johannesburg
Salary:
If you enjoy creating smart digital solutions that simplify how teams work and improve business performance, this opportunity will suit you well. This role places you at the center of data driven decision making, system optimisation, and technology enablement across the organisation. You will play a key part in building tools, improving systems, and helping people access information they need to w...
2 days ago

Junior Business Analyst
Location: Johannesburg
Salary:
MTS's client in the Mining sector is looking for a Junior Business Analyst to support the analysis, design, and implementation of business solutions across multiple business units. To be considered for this role you, Mining industry experience would be highly beneficial and you would need at least 2-3 years experience in a similar role. This is hybrid contract role with 3 days a week in office (We...
2 days ago

Mid-Level Power Automate Specialist
Location: Randfontein, Gauteng
Salary: Market Related
Summary We are seeking a mid level power Automate Specialist who is passionate about efficiency, automation, and solving business problems. The successful candidate will design, build, and maintain microsoft power Automate flows that streamline administrative tasks, reduce operational bottlenecks, and improve productivity across the business.
3 days ago

Functional Consultant MS Dynamics 365 - 6month Contract
Location: Sandton
Salary: Negotiable
Functional Consultant MS Dynamics 365 - 6month Contract
8 days ago

Analyst: Human Capital Information Systems
Location: Pretoria
Salary:
We are recruiting for an Analyst: Human Capital Information Systems role.
9 days ago

Data Warehouse Developer
Location: Johannesburg
Salary: Hourly
Brief DescriptionAre you an experienced data Warehouse Developer with a passion for transforming data into meaningful business insights? I am currently engaging with skilled data Warehouse Developers for upcoming contract and permanent opportunities across South Africa. This is an excellent opportunity to be considered for roles where you will design, develop, and optimise enterprise-level data wa...
10 days ago

Data Scientist
Location: Johannesburg
Salary: Hourly
Brief Description:Are you a data Scientist with strong Business Intelligence expertise and a passion for turning complex data into meaningful insights?I am currently looking for experienced data Scientists (bi-focused) for long-term assignments and contract opportunities. If you enjoy working at the intersection of data science, analytics, and business intelligence, and thrive in data-driven envir...
10 days ago

Senior Full Stack Developer
Location: Centurion
Salary: 100 000 Monthly
Are you ready to take the lead in crafting advanced digital solutions? This opportunity is perfect for a seasoned developer who enjoys solving complex technical challenges while working with modern platforms and tools.
11 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