Business Intelligence Developer

Date: 21 Jan 2025

Location:

Midrand, Gauteng, ZA

Company: Sanlam Group

Who are we?

MiWay is a direct financial services company. We are passionate about service excellence, convenience and offering our clients superior value products. Our Vision is to be a world-class direct financial services business that offers a complete array of services under one convenient umbrella – all managed online. Category winners of the Mail & Guardian Top Companies Reputation Awards in 2014, as well as the Deloitte Best Company to Work For Survey 2011 and 2012 – were are passionate about our people. We are positive that with the right people on board, we will continue to grow and give our clients the freedom to do things their way – free from worry and most importantly at peace with all the “what-ifs” of the world. Company values that every employee subscribes to are: Energy, Freedom, Accountability and Attitude. The ideal candidate is one who has the courage to be bold and subscribes to MiWay’s core values! Do you have a positive attitude, love a challenge, treat your colleagues with respect and look for solutions, not problems? If yes, then MiWay is the place for you!

What will you do?

We are looking for an enthusiastic business intelligence (BI) developer to help shape the MiWay Sales reporting landscape. Focus will be on designing various analytical reports on company data and delivering them to top management and other interested parties. As a BI developer, you will be working with business users, collecting their requests, and then updating the set of existing BI reports to accommodate business needs. BI developers will be expected to establish company standards and common reporting terminology, and to help align existing and future reporting requests to such standards. You will also be interacting with data warehouse architects whenever data schemas need redesigning to accommodate new reporting requirements.

Minimum Qualification Required

Bachelor’s degree in computer science or information technology

Minimum Experience

Minimum of 3 years’ experience working within a Microsoft environment using SQL, SSIS and SSRS is needed.

Deliverables include, but will not be limited to

Analysing and understanding data from multiple sources including sales, customer, accounting data sets and create integrated views that can be used to drive decision making within the Sales environment.
Working with several large and complex SQL databases
Be fully capable of developing OLAP or Tabular Model Cubes within a SQL environment
{SQL Server 2010 or higher}
Working with our clients, creating a relationship and deliver to their requirements.
Collect and maintain the set of business reporting requirements.
Implement BI reports based on the above requirements.
Analyse existing reports and optimize them for standardization across the company.
Set up and maintain BI tools, infrastructure, and integration with company data sources.
Work with data warehouse architects. Propose data schema and data flow optimization for reporting performance and enhancement as needed.

Competencies Required

Proven experience as a BI Developer/ BI Analyst
Insurance Industry experience is preferred (with an understanding of sales being advantageous)
Background in data warehouse design (e.g., dimensional modelling)
In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
Familiarity with BI technologies (e.g., Microsoft Power BI, PowerApps)
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server
Integration Services (SSIS)
Proven abilities to take initiative and be innovative
Analytical mind with a problem-solving aptitude
Adept at the use of BI reporting tools such as Power BI
Willing to learn on the job

Knowledge and Skills

Problem Solving
Issues management
Attention to detail and accuracy
Personal Attributes
Self-development - Contributing independently
Interpersonal savvy - Contributing independently
Nimble learning - Contributing independently
Tech savvy - Contributing independently

Core Competencies

Cultivates innovation - Contributing independently
Customer focus - Contributing independently
Drives results - Contributing independently
Collaborates - Contributing independently
Being resilient - Contributing independently

Knowledge and Skills

MIS Database

MIS reports

Data trends and analysis

Data Governance

Service delivery

Personal Attributes

Interpersonal savvy - Contributing independently

Plans and aligns - Contributing independently

Decision quality - Contributing independently

Optimises work processes - Contributing independently

Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.

Core Competencies

Being resilient - Contributing independently

Collaborates - Contributing independently

Customer focus - Contributing independently

Drives results - Contributing independently

Cultivates innovation - Contributing independently

Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.

Our commitment to transformation

At MiWay we believe in cultivating a positive and dynamic working environment that gives you freedom and opportunity to succeed. MiWay is committed to transformation and embracing diversity. This is what drives us to achieve a multicultural workplace with employment equity as a key goal to create an inclusive workforce, reflective of the demographics of our society.