Job Description

Who are we?At MiWay, our purpose is to enable people to live their way. We understand that life is not just about "things" but the meaning that those things bring to your life. We believe that technology and innovation have infinite possibilities when it's inspired by humans by you.
Therefore, we focus on our clients' needs; finding new ways to simplify their lives and how they do things.
We give them products, services, and solutions that enable them to live and enjoy life on their own terms - in their own way.
Agile values and principles are strongly embedded in our culture, and they are at the core of how we make decisions and how we approach adding value within the company.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 decisionNmaking 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 SkillsMIS reportsData trends and analysisMIS DatabaseService deliveryIT governance and compliancePersonal AttributesOrganisational savvy - Contributing independentlyManages complexity - Contributing independentlyPlans and aligns - Contributing independentlyOptimises work processes - Contributing independentlyCore CompetenciesBeing resilient - Contributing independentlyCollaborates - Contributing independentlyCultivates innovation - Contributing independentlyCustomer focus - Contributing independentlyDrives results - Contributing independentlyBuild a successful career with usWe'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.Turnaround timeThe 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 transformationAt 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