Job Description

Closing Date 2023/09/25
Reference Number MMH230811-5
Job Title BI Developer
Position Type Permanent
Role Family Business Intelligence
Cluster Momentum Life
Remote Opportunity Some of the time
Location - Country South Africa
Location - Province Gauteng
Location - Town / City Centurion
Introduction

A new opportunity has opened in the Finance and Business Intelligence area within the Momentum Finance division. The position is based at our Centurion Head Office.
Role Purpose

The BI Developer role will be required to address business queries through the effective and meaningful translation, collection and analysis of raw company data and to communicate these results in order to enhance the decision-making process. The BI Developer will examine and evaluate reporting requirements for various stakeholders across Momentum.
Requirements

• Com / B.Sc degree, IT Diploma, or Qualified by Experience

• Microsoft Certification will be an advantage

• Microsoft BI skills. Particularly SSAS tabular model design and implementation, Reporting Services and Integration services

• Database design and Warehousing

• PowerBI

• Power Automate will be an advantage

• Kimball Methodology

• Minimum of 6 years relevant experience required

Duties & Responsibilities

• The developer will design and create end to end Business intelligence solutions from ETL, SSAS cubes to Powerbi or SSRS reports and dashboards.

• The individual will also be responsible for proactively generating and compiling reports based on his or her findings, complete with recommended improvements to- or new requirements for xe2x80x93 business processes, operational procedures, and their corresponding reporting structures. The developer should therefore be able to interpret the reports that he or she produces.

• The developer must work with other technology teams and business analysts where applicable to scope and prioritise development efforts necessary to deliver reporting for various business units

• The analysis of reporting requirements as defined by business and documenting the desired solution and/or recommendations. This includes, translation of reporting requirements between business and the technology and tools necessary to deliver on those 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, ETL processes or improving solution design.

• Interact with existing reporting resources and ensure a single reporting strategy is maintained

• Monitor SQL server jobs and 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

• Formalise communication to ensure reporting on deliverables

• Ensure signoff on all reporting deliverables according to business specifications

• Report and estimate development timelines

• Continually build and enhance knowledge of reporting technologies.

• Address current shortcomings and extract greater efficiencies.

• Managing own performance and development.

• Ensuring effective and consistent service delivery and support to both internal and external clients in line with the Company Values and Treating Customers Fairly Principles.

• Living the Momentum values namely: Accountability, Diversity, Excellence, Integrity, Innovation and Teamwork.

• Adopt and accept new technology as and when required

Competencies

Soft

• Presenting and Communicating Information

• Learning & Researching

• Writing & Reporting

• Applying Expertise & Technology

• Analysing

• Delivering Results & Meeting Customer Expectations

• Following Instructions & Procedures

• Working with People

• Persuading & Influencing

Technical

• Microsoft Reporting Services 2012 or higher

• Microsoft Analyses Services 2012 or higher

• Microsoft Integration services 2012 or higher

• Database design and implementation

• Basic SQL server administration

• Advance T-SQL language

• Microsoft office

Policy

We are committed to Employment Equity, diversity and inclusion when recruiting internally and externally. All appointments are made in alignment to our Employment Equity goals and we encourage people with disabilities to apply.

Momentum Metropolitan