Senior BI Developer

Let's Write Africa's Story Together!

Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this.

Job Description

na

The key objectives of the Senior BI Developer are to facilitate, develop and implement multi-disciplinary cross-functional BI data projects and to provide support to the business in respect of OMAI’s existing system/data capabilities. The role requires extensive involvement in all phases of the development lifecycle, from analysis and development through to testing and deployment

Key Result Ares:

Development

• Partner with the OMAI investment business units and professional partners to scope business requirements and identify where data can have the greatest impact from a BI perspective
• Facilitate the development & implementation of multi-disciplinary cross-functional BI projects
• Provide support to the business in respect of OMAI’s existing BI capabilities
• Effective planning and prioritising of multi-disciplinary cross-functional BI projects
• Lead development projects by assisting, coaching and mentoring junior team members
• Collaborate with data owners to increase BI reporting capabilities
• Develop against OMAI’s Data Architecture reference model, Data Spectrum and Taxonomy.
• Liaise with stakeholders to coordinate data sources, eliminate duplication, while focusing on data quality and reliability in BI models
• Additional tasks include project planning, validating data, and unit and system testing, and coordination of development activities.
• Provide support to and develop solutions for the business in respect of OMAI’s existing software and application capabilities

Testing

• Ensure unit testing is completed
• Implement corrections and changes as required by the business units
• Create automated testing processes

Application Support

• Ensure operational stability of applications by providing proactive and reactive first-line support.
• Provide first line support and root cause analysis of production issues for all applications

Collaboration, Interaction and Stakeholder Management

• Mentoring junior team members
• Ability to manage senior relationships across all the Business and Functional areas.
• Ability to develop cooperative and constructive working relationships.
• Ability to handle complaints, settle disputes and resolve conflicts and negotiate with others.
• Collaborate with fellow developers and teams via code reviews and knowledge sharing sessions.

Skills, Qualifications & Experience required :

• Tertiary qualification in Computer Science, Information Management or equivalent.
• At least 10 years’ relevant experience, in a BI developer role
• At least 5 years’ experience in asset management or financial services experience. Experience in the Alternative Investment industry would be an advantage
• Strong SQL experience, at least 8 years, including creating stored procedures, functions, automating jobs, performance tuning and optimization.
• At least 4 years SSIS experience, including creating complex ETL processes, error handling, loading data from various sources, and integrating new data into data warehouses.  
• Develop and maintain reports using SSRS and Power BI, etc.  
• Knowledge of data governance practices and emerging trends (preferable)
• Background in data warehouse design (e.g., dimensional modelling) and data mining
• eFront Invest knowledge would be an advantage
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

Competencies:

• Self-starter, quick learner, capable of setting priorities and ability to remain efficient while multi-tasking
• Collaborative team player orientation towards work relationships; strong culture awareness
• Good communication skills, both written and verbal. Dynamic, flexible and able to work in a fluid environment
• Able to work independently and as part of a team
• Advanced analytical, reasoning & numerical aptitude
• Independent critical thinker able to make balanced and sound recommendations and decisions
• Initiating demeanour taking prompt action to accomplish objectives by being proactive
• High stress tolerance
• Attention to detail
• Ability to take ownership, responsibility and accountability for the successful completion of tasks
• Ability to gain commitment using appropriate interpersonal styles and communication techniques to gain acceptance of ideas or plans

Skills

Microsoft Power Business Intelligence (BI), OLAP (Online Analytical Processing), SSIS Packages, Structured Query Language (SQL)

Competencies

Business Insight

Collaborates

Courage

Cultivates Innovation

Decision Quality

Drives Results

Ensures Accountability

Manages Complexity

Education

Closing Date

09 January 2025 , 23:59

The appointment will be made from the designated group in line with the Employment Equity Plan of Old Mutual South Africa and the specific business unit in question.

Old Mutual Limited is pro-vaccination and encourages its workforce to be fully vaccinated against Covid-19.

All prospective employees are required to disclose their vaccination status as part of the recruitment process.

Please refer to the Old Mutual’s Covid-19 vaccination policy for further detail. Kindly note that Old Mutual reserves the right to reinstate the requirement to vaccinate at any point if it is of the view that it is imperative to do so.

The Old Mutual Story!