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:

Digital Solutions Developer - On-site Johannesburg (full stack .Net, Microsoft Power Apps, Power BI, Microsoft Copilot, APIs, Qlik Sense, ABP.IO)
Location: Johannesburg
Salary:
14 days ago

Microsoft Power BI Developer - Remote
Location: Johannesburg
Salary:
Our client is looking for a Remote microsoft power bi Developer to join their team.
27 days ago

INVENTORY PLANNING MANAGER
Location: Johannesburg
Salary: R650 000 - R900 000 (depending on experience)
Large, well established industrial company situated in Boksburg seeking an experienced Inventory Planning Manager preferably within an engineering, mining or petrochemical environment.
1 day ago

Executive Business Partner to the CEO | Cape Town | Permanent
Location: Cape Town
Salary:
2 days ago

Junior Network Support Engineer
Location: Centurion
Salary: 250 000 Annually
Are you passionate about networking, cyber security, and IT infrastructure? An exciting opportunity awaits a driven Junior Network Support engineer looking to gain hands-on experience across enterprise networking, firewall management, VPNs, Wi-Fi environments, and infrastructure support while building a long-term career within a professional and supportive team.
4 days ago

TMS Solutions Expert
Location: Johannesburg
Salary: 550 000 Annually
Are you a Transport Management Systems expert with extensive CarLo experience and a passion for solving complex logistics and systems challenges? This opportunity offers the chance to work with business-critical transport and logistics applications, supporting system performance, business users, and ongoing solution enhancements within a dynamic environment.
4 days ago

Logistics Controller
Location: Johannesburg
Salary:
Keep Logistics Moving. Solve Problems. Deliver Results.A well-established organisation within the logistics and transport industry is looking for driven and highly organised Logistics Controllers to join its operations. This is an excellent opportunity for logistics professionals who enjoy the fast pace of transport operations, thrive under pressure and have the ability to coordinate drivers,...
4 days ago

Product Business Solutions Specialist
Location: Johannesburg
Salary:
A leading organisation within the courier, logistics and supply chain industry is seeking an experienced Product Business Solutions Specialist to turn complex business and customer challenges into practical, data-driven solutions.This is an exciting opportunity for a commercially minded problem-solver who sits comfortably at the intersection of business analysis, operations, technology, data and c...
4 days ago

Senior Identity and Access Management Engineer
Location: Johannesburg
Salary:
Are you an experienced Identity and Access Management professional passionate about security, automation, and modern identity solutions? This is an outstanding opportunity to play a key role in shaping and enhancing enterprise-wide identity strategies while working with cutting-edge technologies in a highly secure and dynamic environment.
4 days ago

Solutions Specialist
Location: Johannesburg
Salary:
Are you a solutions-driven systems specialist with experience in transport and logistics technology? This is an exciting opportunity to become a key subject matter expert, working with business-critical applications, driving system improvements, and supporting operational excellence across a dynamic and fast-paced environment.
4 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