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:

LEAD BI Develolper
Location: Centurion
Salary:
MAIN PURPOSELead the design, development, and optimisation of business intelligence solutions, ensuring data-driven decision-making aligned to business strategy and performance goals.We are seeking a strategic and technically strong Lead bi Developer to drive data intelligence, reporting excellence, and business decision-making within a dynamic, high-performance environment.This role is ideal for ...
3 days ago

Lead BI Developer - EE (Centurion)
Location: Centurion
Salary: 45000 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 a...
4 days ago

Junior Power BI Developer
Location: Johannesburg
Salary: 25000 Monthly
Now find new jobs best matched to your skills!Job Title: Junior power bi Developer - Sandton.Salary: R25,000 to R40,000 + negotiable depending on experience.The OpportunityThis position requires you to turn data into insights for the business. You will support the company vision of business excellence and data growth. The developer helps business clients make decisions using data analytics tools. ...
5 days ago

Data Analyst
Location: Johannesburg
Salary: 240000 Annually
Exciting data Analyst Opportunity
8 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Are you detail-driven, curious, and eager to grow your career in Business Intelligence?Our client, a leading direct selling company, is seeking a Junior bi Developer to join their development team and help design, deliver, and maintain bi solutions that power smarter decision-making across the organisation.This is the perfect role for someone with foundational microsoft data skills who is ready to...
9 days ago

Power Platform Developer
Location: Johannesburg
Salary:
MTS's client based in Kempton in the Freight and Logistics sector is looking for a skilled power Platform Developer to design, build, and support scalable digital solutions that improve business processes and efficiency. This role focuses on hands-on development across power Apps, power Automate, power bi, and dataverse, translating business requirements into practical, high-quality solutions.
11 days ago

Business Intelligence Developer
Location: Johannesburg
Salary: 400000 Annually
New Opportunity: bi Developer - Gauteng
12 days ago

IT Audit Supervisor
Location: Johannesburg
Salary: 900000 Annually
Exciting IT Audit Supervisor opportunity in Gauteng
12 days ago

C# Developers / Architects
Location: Johannesburg
Salary:
Our client is looking for high-calibre C# Developers and Architects to join their consulting delivery teams. This is an opportunity to work on complex, large-scale software solutions across a variety of industries, using modern engineering practices and robust microsoft technology stacks.
12 days ago

Cloud Engineer
Location: Johannesburg
Salary:
We are seeking a specialised Cloud engineer to design, build, secure, and maintain the infrastructure powering our modern data platforms. Unlike a traditional Cloud engineer focused on general application hosting, this role is dedicated to the unique demands of large-scale data workload, spanning high-volume storage, high-throughput networking, and compute-optimised environments for Spark and SQL-...
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