SQL Report & BI Developer (Power BI, SSRS)

Momentum Corporate

Cape Town

On-site

ZAR 420,000 - 660,000

Full time

11 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Momentum Corporate is seeking a professional BI/reporting specialist to examine and refine operational reporting requirements across the business unit. You will translate business needs into technical specifications and develop reports and scripts using MS SQL Server, Power BI, and SSRS.

You will work with diverse database platforms (MS SQL Server, PostgreSQL, Oracle, DB2), optimise performance, and ensure reporting continuity.

Qualifications

Com / B.Sc. degree, IT Diploma, or equivalent qualification.
IT and report writing experience.
Microsoft SQL Server certification preferred.
Strong Microsoft SQL Server programming skills: 4 - 6 year experience.
Microsoft Power BI experience preferred: 2 - 3 year experience.
Microsoft Reporting Services experience preferred: 2 - 3 year experience.
Work with databases from a wide variety of vendors and database platforms (MS SQL Server, PostgreSQL, DB2 and Oracle).
XML/XSL Experience preferred.

Responsibilities

The analysis of reporting requirements as defined by business, and documenting the desired solution and/or recommendations.
Translation of reporting requirements between business and the technology and tools necessary to deliver on those requirements.
The development of reports, and underlying scripts and procedures, according to business requirements.
Ensure a high level of quality is achieved by performing constant testing and reviews of reports implemented. This includes doing performance optimisation of existing SQL code in order to make it execute faster whilst proving the integrity of the report is still intact.
Interact with existing reporting resources and ensure a single reporting strategy is maintained.
Interact with other technology teams and database administrators to ensure that reporting continuity is maintained.
Participate in the change process to improve efficiency of testing.
Formalize communication to ensure accurate reporting on deliverables.
Ensure signoff on all reporting deliverables according to business specifications.
Work in partnership with the business analysts, product owners, and other IT and business personnel to maximize project delivery success.
Report and estimate on the development timelines.
Continually build and enhance knowledge of reporting technologies.
Continually improve the reporting writing process by investigating and implementing new and innovative reporting writing methods