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:
42 days ago

Human Capital Information Analyst
Location: Johannesburg
Salary: Annually
Ready to turn data into strategic business decisions? Join a globally recognised organisation where Human Capital analytics is at the heart of shaping workforce strategy, enhancing employee experience, and driving organisational performance across international operations.This is an exciting opportunity for a commercially minded Human Capital Information Analyst who thrives on uncovering insights ...
Today

Lead BI Developer - EE (Centurion)
Location: Centurion
Salary: 60000 Monthly
Job Purpose:Developing and maintaining data strategies aligned to supporting overall business goals. Management & technical execution of strategic business data projects and reportingTranslate complex data findings for various stakeholders across relevant departments as a decision support service.Managing subordinates & ensuring they achieve KPIs and achieve business goals.Qualifications and or Ex...
Today

IT Manager
Location: Johannesburg
Salary: 1 200 000 Annually
Are you an experienced IT Infrastructure leader ready to take ownership of a large-scale technology environment supporting over 3,000 IT professionals? This is a unique opportunity to lead infrastructure, security, hardware, facilities management, and a high-performing support team within a dynamic and growing organisation.
1 day ago

Systems Manager
Location: Johannesburg
Salary: 800 000 Annually
Ready to take ownership of a complex IT infrastructure environment and lead high-performing technical teams? This is an exciting opportunity for an experienced IT Systems Manager to drive operational excellence, improve service delivery, and oversee critical server and end-user computing environments within a fast-paced, technology-driven business.
1 day ago

Senior Helpdesk Support L3
Location: Johannesburg
Salary: 450 000 Annually
Are you a senior IT support or cloud operations professional who thrives in highâpressure environments? This role is for someone who enjoys solving complex technical issues, building automation, and being the goâto escalation point across cloud, identity, endpoint, and network services.
1 day ago

IT Business Systems Administrator
Location: Johannesburg
Salary: 650 000 Annually
Are you a systems-driven IT professional with strong Oracle NetSuite and SQL expertise? This is an exciting opportunity to take ownership of critical business systems, drive process automation, support enterprise-wide ERP operations, and play a key role in digital transformation initiatives within a fast-paced operational environment.
1 day ago

Data Engineer | Microsoft Fabric | Azure | SQL | Python | Data Engineering | Your Next Career Move Starts Here
Location: Johannesburg
Salary:
Are you a skilled data engineer ready for your next career move?I specialize in connecting talented data engineers with exciting opportunities across software development houses, start-ups, consultancies and large corporates.I work with organisations that value data-driven decision-making, modern data platforms, cloud technologies and strong technical talent, both within South Afric...
1 day ago

Devops Engineer
Location: Johannesburg
Salary:
Are you an experienced DevOps engineer passionate about cloud platforms, automation, and modern infrastructure? This opportunity offers the chance to work with enterprise-scale microsoft Azure environments, drive cloud innovation, and play a key role in delivering secure, scalable, and high-performing technology solutions.
1 day ago

Security Defence and Operations Lead
Location: Johannesburg
Salary:
Are you an experienced cybersecurity professional with a passion for incident response, threat management, and operational security leadership? This opportunity offers the chance to lead cyber defence initiatives, strengthen security operations, and play a critical role in protecting enterprise systems, data, and business continuity.
1 day 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