Sr. Data Warehouse Developer -Africa MMH251117-4

Job Description

Role Purpose The position is accountable for designing and developing dimensional data models, data marts, and enterprise data models utilising MS SQL. This role contributes to the organisation?s data infrastructure by ensuring effective data storage, retrieval, and processing across various analytical datasets through multiple tools Requirements Total Experience 10 years Relevant Experience 7 years of experience into a similar role Experience of SQL and Databases (MS SQL Server, DB2, Postgres, Mongo). Experience with dimensional modelling and Kimball methodology. Strong proficiency with BI tools such as SSRS, Microsoft Power BI, etc. Expertise in SQL, ETL development, data pipelines, and data integration. Experience with cloud-based platforms (AWS, Azure, Google Cloud) is a plus. Duties and Responsibilities KEY ACCOUNTABILITIES/KRAS/KPIS: 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. Generate and produce descriptive and diagnostic analytics for the business. 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. Delivery of service level agreements made with internal and external stakeholders and clients. Make recommendations to improve client service within area of responsibility. Participating in 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. As an applicant, please verify the legitimacy of this job advert on our company career page. 346021306