SQL/SSIS & Power BI Data Engineer

Boardroom Appointments

Johannesburg

On-site

ZAR 450,000 - 850,000

Full time

14 days+

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Boardroom Appointments is seeking a data professional with 3-5 years in SSIS and experience building and maintaining OLAP cubes (SSAS) to design complex reports and star schemas. The role requires strong SQL skills, data modeling, and dashboards in Power BI, aligned with SDLC best practices.

You will contribute to database design, performance tuning, and extensive reporting solutions in a SQL Server environment.

Qualifications

Minimum of 3-5 years SSIS experience.
Minimum of 3-5 years experience in building and maintaining OLAP cubes in analysis services 2005- 2019.
A demonstrated experience in complex reports,master reports and cube reporting.
3-5 years' experience in database design and the normalization of data structures - must have developed a star schema and facilitated a team effort.
2-4 years' experience in Database administration
Three years of experience in software development, preferably with SQL and/or SSIS.
Strong knowledge of object oriented programming and design patterns is a plus.
2+ years of experience in a SQL Server environment.

Responsibilities

Experience in application design, development and performance tuning.
Understanding of software development lifecycle (SDLC) methodologies.
Knowledge and Experience in SSIS,SSRS and SSAS and Power BI.
Ability to create advanced data models using computerized tools.
Ability to cull data and extrapolate data patterns.
Ability to design and implement meaningful reports and dashboards using computerised tools.