SQL Report Developer

Momentum Corporate; Cape Town; On-site; ZAR 420,000 - 660,000; Full time

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

Skills

SQL scripting

Power BI

SSRS

XML/XSL

Analytical thinking

Education

BSc/IT Diploma

Tools

MS SQL Server

PostgreSQL

DB2

Oracle

SSRS

XML/XSL

Job description

Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms Momentum Group provides practical financial solutions for people, communities and businesses. Visit us at www.momentumgroupltd.co.za

Role Purpose

Examine and evaluate Operational reporting requirements for various stakeholders across the business unit.

Requirements

• 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

Duties & Responsibilities

The work you need to deliver

• 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

Key Skills & Attributes

• Strong analytical & problem solving skills
• Ability to work under pressure and manage a crisis effectively
• Methodical, logical, patient, careful, and accurate.
• Good communicator, who is able to work well with others, but also possess the self-discipline and stamina to work on their own initiative