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

Senior Power BI Developer | Gauteng
Location: Sandton, Gauteng
Salary: market related
Senior power bi Developer | Gauteng
Today

Payroll Administrator
Location: Johannesburg
Salary:
We're looking for a Payroll Administrator to join our dynamic team where your expertise will play a critical role in ensuring accurate, compliant and seamless payroll processing from start to finish.
Today

Practice Transition & Data Specialist
Location: Johannesburg
Salary: 25 000 Monthly
Sandhurst - Are you a tech-savvy data professional with a knack for systems integration and a passion for streamlining financial practice operations? Join a dynamic, forward-thinking financial services group based in Sandhurst where your technical expertise directly powers seamless business transitions.
Today

IT: Practice Transition and Data Support
Location: Sandton
Salary: Monthly
Our Client, a leader in the Financial Services space; is seeking to employ an IT: Practice Transition and data Support to their team based in Sandhurst, Gauteng.
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

Dealership Financial Manager, Gauteng, East Rand
Location: Johannesburg
Salary:
Dealership Financial Manager #DriveYourCareerForward and take the wheel of financial dealership performance.An established automotive dealership group is looking for an experienced Financial Manager to oversee the financial control and reporting functions of dealerships. This is an excellent opportunity for a commercially astute finance professional with strong automotive dealership exp...
1 day ago

IT: Practice Transition & Data Support
Location: Sandhurst
Salary:
Our client is looking for an experienced IT: Practice Transition & data Support professional to support the seamless transition of client data into internal systems when new advisory practices join the business.The successful candidate will be responsible for preparing and managing data, supporting digital onboarding processes, troubleshooting electronic processes and providing technical suppo...
1 day ago

Group FP&A & Commercial Finance Manager
Location: Johannesburg
Salary:
Shape Strategy, Influence Performance, and Drive Group-Wide Financial Excellence
1 day ago

Security Analyst
Location: Johannesburg
Salary: Monthly
Step into the frontline of cyber defense as our Security Analyst. You’ll monitor, detect, and respond to threats across Azure Sentinel, microsoft Defender, Azure, and Purview. From investigating incidents to strengthening our security posture, your expertise will keep our environment resilient. You’ll play a pivotal role in safeguarding compliance across cloud and onâprem systems. Th...
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