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:

Senior BI Developer
Location: Johannesburg
Salary: Annually
bi Developer who will be responsible for data analysis, reporting and visualisation, with a focus on the microsoft Cloud bi Platform
2 days ago

Senior BI Developer
Location: Pretoria
Salary:
Turn data into decisions that shape the future—join our client as a bi Developer and make an impact with cutting-edge analytics.
3 days ago

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

Data & Analytics Engineer
Location: Johannesburg
Salary: R800000 Annually
Senior data & Analytics engineer – microsoft Fabric / Azure data Factory Expertð Johannesburg (Office Based)ð Permanent Positionð¡ Ideal Candidate ProfileAre you a data engineering specialist with a strong cloud-first mindset?You understand end-to-end data flow — from extraction to analytics — and know how to make it scalable, reliable, and intelligent?Are you passion...
6 days ago

Financial IT Systems Administrator
Location: Centurion
Salary:
Financial Systems AdministratorWe are seeking a skilled and detail-oriented Financial Systems Administrator to join our client’s IT Operations team in Highveld, Centurion. The successful candidate will be responsible for managing and supporting the firm’s Aderant financial management system, ensuring its reliability, accuracy, and alignment with business requirements. This role require...
6 days ago

Data Analyst
Location: Johannesburg
Salary: Market Related
Are you passionate about turning complex data into powerful business insights? Join an innovative organisation that’s leveraging data science and machine learning to drive smarter, faster, and more strategic decisions. Our client is a forward-thinking industry leader that believes in the power of data to transform business outcomes. They are seeking an Intermediate data Scientist to join the...
9 days ago

Senior BI Developer - Hybrid
Location: Sandton
Salary:
9 days ago

Business Development Manager
Location: Midrand
Salary:
Our client is seeking an experienced and dynamic Business Development Manager to join their Gauteng team. This is a pivotal role for a strategic thinker with a proven track record in driving revenue growth through innovative sales strategies.
10 days ago

Senior AI Developer - Insurance
Location: Johannesburg
Salary: 1100000 Annually
Are you a seasoned microsoft Developer with a passion for AI and automation? We're seeking a dynamic Senior AI Developer to lead the design and deployment of cutting-edge AI solutions that transform business operations and empower internal users through intelligent assistants.This is a high-impact role for a strategic thinker who thrives on innovation, technical leadership, and delivering measurab...
11 days ago

Data Scientist
Location: Pretoria
Salary: Market Related
Are you passionate about turning complex data into powerful business insights? Join an innovative organisation that’s leveraging data science and machine learning to drive smarter, faster, and more strategic decisions.
12 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