Job Description

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 xe2x80x9cwhat-ifsxe2x80x9d 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!

Minimum Qualification Required

Bachelor's degree in computer science or information technology

Minimum Experience

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

Responsibilities

• 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.

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.

Requirements and skills

• 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

Profile source data and determine all source data and metadata characteristics

Advanced analytics to address business requirements

Vendor Management

Statistical analysis and data

Business Processes and business requirements definition

Personal Attributes

Manages complexity - Contributing through others

Tech savvy - Contributing through others

Plans and aligns - Contributing through others

Optimises work processes - Contributing through others

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 four business clusters - Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office - the group provides many opportunities for growth and development.

Core Competencies

Being resilient - Contributing through others

Collaborates - Contributing through others

Cultivates innovation - Contributing through others

Customer focus - Contributing through others

Drives results - Contributing through others

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. Deadline to apply: 21 November 2023.

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.

Sanlam