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 Engineer (Centurion)
Location: Centurion
Salary: 30000 Monthly
Position available for a data engineer based in Centurion. The purpose of the position is to:Design, implement, and maintain the reporting database architectureBuild and optimize ETL pipelinesDevelop and maintain semantic modelsSupport business projects through reportingMINIMUM QUALIFICATIONS AND EXPERIENCE:Three years of experience in data engineering or related fieldMS SQL and SSMSNoSQLssis...
1 day ago


Power BI Developer_JHB
Location: Johannesburg
Salary:
3 days ago


Data Analyst and Business Intelligence Developer
Location: Johannesburg
Salary:
3 days ago


BI Analyst
Location: Benoni
Salary: Monthly
Purpose of the RoleWe are seeking a proactive and highly skilled bi Analyst to transform data into actionable insights that drive process improvements, enhance cash flow, and optimise stock management. This role requires a technically strong professional who can manipulate, analyse, and visualise data to support strategic decision-making across the business.
5 days ago


Group Financial Manager
Location: Johannesburg
Salary: 1200000 Annually
Are you a CA(SA) ready to take the next step in your career? Join an innovative international courier conglomerate, based in Johannesburg East, as their Group Financial Manager. Lead the charge in shaping financial strategy, driving innovation, and delivering top-tier financial solutions across the globe. If you're ready to manage complexity, make a global impact, and grow, then we want to hear fr...
6 days ago


Solution Developer
Location: Johannesburg
Salary: 700000
On the hunt for a Solution Developer in JHB!
10 days ago


IT Developer
Location: Randburg
Salary: 480000 Annually
Are you a talented developer with a passion for building innovative digital solutions? Our client is looking for a driven and skilled IT Developer to join their team. If you're fluent in Afrikaans and English with experience in modern development tools, this is your opportunity to thrive in a progressive environment.
11 days ago


AI and Analytics Engineer
Location: Centurion
Salary: 30000 Monthly
Our client is looking for a dynamic AI and Analytics engineer to join their team in Centurion. You should have a Bachelors degree with strong Mathematical Ability. With strong experience in a data Science role. Send your CV now!
11 days ago


Sales and Trade Marketing Analyst
Location: Irene
Salary:
Our client in the retail industry has a vacancy available for a "Sales and Trade Marketing Analyst". Salary: market related. Position is based in Irene.
11 days ago


Power BI Developer (12 Months Contract)
Location: Centurion
Salary:
We are recruiting for a power bi Developer role, for a period of 12 months. The ideal candidate will work closely with business stakeholders to understand their requirements, transform data into actionable insights, and support data-driven decision-making across the organisation.
12 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