Data Warehouse Developer

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.

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