Data Warehouse Anaylst

Momentum Insure Company Limited; Centurion; On-site; ZAR 500 000 - 700 000; Full time

Job summary

A leading insurance company in Centurion is seeking a Data Warehouse Analyst to translate business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to inform strategic decision-making. The ideal candidate has a bachelor's degree in a quantitative field and 5-8 years of experience in Data Warehouse analysis. Proficiency in SQL and experience with BI tools like Tableau or Power BI are essential for success in this role. Competitive compensation and opportunities for continuous learning are offered.

Qualifications

• 5-8 years of experience in Data Warehouse analysis.
• 5 years’ experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.

Responsibilities

• Collaborate with stakeholders to gather and translate business needs.
• Identify, collect, and clean data from various sources.
• Contribute to the design and maintenance of data models.

Skills

Data Analysis

Data Warehousing

ETL

SQL

Data Visualization

Reporting

Business Acumen

Communication (Written & Verbal)

Problem-Solving

Critical Thinking

Collaboration

Education

Bachelor's degree in a quantitative field

Tools

Tableau

Power BI

Looker

Snowflake

BigQuery

Redshift

Python

R

Job description

Introduction

Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings, protect what matters to them and invest for the future. We help companies and organisations care for and reward their employees and members. Through our own network of advisers or via independent brokers and utilising new platforms Momentum Metropolitan provides practical financial solutions for people, communities and businesses. Visit us at www.momentummetropolitan.co.za

Disclaimer

As an applicant, please verify the legitimacy of this job advert on our company career page

Role Purpose

The Data Warehouse Analyst plays a crucial role in translating business needs into actionable insights. This role involves gathering, analyzing, and interpreting data to provide recommendations that drive strategic decision-making. The Data Warehouse Analyst possesses a strong understanding of data warehousing, ETL processes, data visualization, and reporting techniques. They are comfortable working with various data sources and BI tools and can effectively communicate complex information to both technical and non-technical audiences

Requirements

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Business Analytics) or equivalent experience.
• 5-8 years of experience in Data Warehouse analysis.
• 5 years’ experience in data modelling in a Data Warehouse.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Proficiency in SQL and experience working with relational databases.
• Experience with at least one BI visualization tool (e.g., Tableau, Power BI, Looker).
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills, with the ability to explain complex technical concepts to non-technical audiences.
• Ability to work independently and as part of a team.
• Experience with cloud-based data warehousing solutions (e.g., Snowflake, BigQuery, Redshift) is a plus.
• Experience with scripting languages (e.g., Python, R) is a plus.
• Knowledge of statistical methods and techniques is a plus.

Duties & Responsibilities

• Requirements Gathering: Collaborate with stakeholders to understand business needs and translate them into specific data and reporting requirements.
• Data Collection & Preparation: Identify, collect, and clean data from various sources (e.g., databases, CRM systems, web analytics) ensuring data accuracy and integrity.
• Data Modeling & Warehousing: Contribute to the design and maintenance of data models and data warehouses, optimizing for performance and scalability.
• ETL Processes: Develop and maintain ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse.
• Data Analysis & Interpretation: Conduct in-depth data analysis to identify trends, patterns, and insights that can inform business decisions.
• Report & Dashboard Development: Design, develop, and maintain interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Performance Monitoring: Monitor the performance of BI solutions and identify areas for improvement.
• Documentation: Create and maintain documentation for data sources, ETL processes, reports, and dashboards.
• Collaboration & Communication: Effectively communicate findings and recommendations to stakeholders at all levels, including technical and non-technical audiences.
• Continuous Learning: Stay up-to-date with the latest BI trends, tools, and techniques.
• Mentorship: Mentor junior analysts and provide guidance on best practices.

Competencies

• Data Analysis
• Data Warehousing
• ETL
• SQL
• Data Visualization
• Reporting
• Business Acumen
• Communication (Written & Verbal)
• Problem-Solving
• Critical Thinking
• Collaboration