Data Warehouse Developer

Momentum; Bellville; On-site; ZAR 360,000 - 480,000; Full time

Job summary

A leading financial services brand in South Africa seeks a Data Warehouse Developer to enhance their data infrastructure. The role involves designing and developing data models, ensuring efficient data storage and retrieval, and collaborating with teams to meet business intelligence needs.

Qualifications

• 5+ years of experience in Business Intelligence development.
• Proven experience in sourcing from multiple database technologies.
• Strong proficiency with BI tools.

Responsibilities

• Design and develop dimensional data models and data marts.
• Implement and maintain ETL processes for integration.
• Collaborate with teams to gather data requirements.

Skills

SQL

Business Intelligence development

ETL development

Data integration

Problem-solving

Communication

Education

Degree in Information Technology/Data Science/Computer Science

Matric

Tools

MS SQL Server

Power BI

SSRS

Job description

Metropolitan is one of the oldest financial services brands in South Africa. With a 125-year legacy of serving the communities in which it operates, Metropolitan represents true empowerment in serving Africa's people through affordable financial solutions that create financial growth and security. Metropolitan operates in South Africa, but the brand is also present in 7 African countries including, Namibia, Botswana, Kenya, Ghana and Lesotho. Metropolitan provides financial wellness solutions that meet the needs of low-income clients, including funeral insurance, health, savings, hospital cash-back cover, retirement solutions and life insurance. www.metropolitan.co.za

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

Role Purpose

Are you passionate about data architecture and analytics? We are seeking a Data Warehouse Developer to design and develop dimensional data models, data marts, and enterprise data models using MS SQL. You will play a key role in shaping our data infrastructure, ensuring efficient data storage, retrieval, and processing across different analytical data using a variety of tools.

Applicants might be invited to perform a technical skills assessment in person at the Parc du Cap offices in Bellville as part of the interview process.

Requirements

• Matric
• Degree in Information Technology/ Data Science/ Computer Science and or relevant equivalent qualification
• 5+ years of experience in Business Intelligence development, specifically with data warehouse environments (essential)
• Proven experience in sourcing from multiple database technologies and building data marts in MS-SQL (essential)
  
  

Knowledge:

• Understanding of SQL and Database technologies (MS SQL Server, DB2, Postgres, Mongo).
• Experience with dimensional modelling and Kimball methodology.
• Strong proficiency with BI tools such as SSRS, Microsoft Power BI, or similar platforms.
• Expertise in SQL, ETL development, data pipelines, and data integration.
• Experience with cloud-based data platforms (AWS, Azure, or Google Cloud) is a plus.
• Excellent problem-solving and troubleshooting skills.
• Strong communication skills, with the ability to work with both technical and business stakeholders.
  
  

Duties & Responsibilities

INTERNAL PROCESS

• Design, develop, and maintain efficient dimensional data models and data marts.
• Architect enterprise data models to support analytical and business intelligence needs.
• Implement and maintain ETL processes for seamless data integration.
• Collaborate with cross-functional teams to gather data requirements and ensure high-quality data solutions.
• Optimize query performance, ensuring high availability and responsiveness of the data warehouse platform.
• Ensure data integrity, security, and consistency across all systems and solutions.
• Provide mentorship and guidance to junior developers, ensuring best practices are followed.
• Continuously improve data warehouse architecture to support evolving business needs and emerging technologies.
  
  

CLIENT

• Provide authoritative expertise and advice to clients and stakeholders.
• Build and maintain relationships with clients, internal and external stakeholders.
• Deliver on service level agreements made with internal and external stakeholders and clients.
• Make recommendations to improve client service within area of responsibility.
• Participate and contribute to a culture which build rewarding relationships, facilitates feedback and provides exceptional client service.
  
  

PEOPLE

• Develop and maintain productive and collaborative working relationships with peers and stakeholders.
• Positively influence and participate in change initiatives within the team and across the business.
• Continuously develop own expertise in terms of professional, industry and legislation knowledge.
• Contribute to continuous innovation through the development, sharing and implementation of new ideas.
• Take ownership for driving career development through available channels.
  
  

FINANCE

• Identify opportunities to enhance cost effectiveness and increase operational efficiency.
• Provide input into the risk identification processes and communicate recommendations in the appropriate forum.
  
  

Competencies

• Examining Information
• Interpreting Data
• Developing Expertise
• Providing Insights
• Articulating Information
• Meeting Timescales
• Attention to detail
• Producing Output