Senior Data Warehouse Developer

About the Role

Our client, a reputable analytics firm, is seeking an experienced Senior Data Warehouse Developer to join their growing business intelligence team in Kimberley. This role is critical in designing, developing, and maintaining the organization's data warehouse solutions, ensuring data accuracy, accessibility, and optimal performance for reporting and analytical needs. You will work closely with business stakeholders and data analysts to understand requirements and translate them into efficient and scalable data warehouse designs. This hybrid position offers the opportunity to work from our client's offices in Kimberley, Northern Cape, while also providing flexibility for remote work.

Key Responsibilities

• Design, develop, and implement scalable data warehouse solutions using industry-standard methodologies (e.g., Kimball, Inmon).
• Develop and optimize ETL/ELT processes to extract, transform, and load data from various source systems into the data warehouse.
• Create and maintain data models, schemas, and dimensional structures for reporting and analytics.
• Write efficient and complex SQL queries for data manipulation, analysis, and reporting.
• Collaborate with business analysts and end-users to gather data requirements and deliver relevant reporting solutions.
• Ensure data quality, integrity, and consistency within the data warehouse.
• Troubleshoot and resolve issues related to data loading, performance, and data accuracy.
• Monitor data warehouse performance and implement optimizations.
• Document data warehouse designs, ETL processes, and data definitions.
• Stay updated with emerging data warehousing technologies and best practices.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related quantitative field.
• 5+ years of experience in data warehousing, ETL development, and business intelligence.
• Proven experience designing and implementing dimensional data models (star schemas, snowflake schemas).
• Strong proficiency in SQL and extensive experience with ETL tools (e.g., SSIS, Informatica, Talend) and data warehousing platforms (e.g., SQL Server, Oracle, Snowflake, Redshift).
• Experience with cloud data warehousing solutions is a plus.
• Familiarity with data governance principles and data quality best practices.
• Excellent analytical, problem-solving, and debugging skills.
• Strong communication and interpersonal skills, with the ability to work effectively with both technical and business teams.
• Experience in a hybrid work environment is preferred.
• Ability to work independently and manage multiple tasks effectively.

Benefits

Our client offers a competitive salary, comprehensive benefits package, professional development opportunities, and a supportive team environment. This hybrid role in Kimberley provides a great opportunity to contribute to critical business intelligence initiatives with a balance of office-based collaboration and remote flexibility. Join our client and play a key role in shaping their data strategy.