Senior Data Warehouse Developer

Placements24; Kimberley; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

Benefits package

Professional development opportunities

Hybrid work environment

Job summary

Placements24 seeks an experienced Senior Data Warehouse Developer to design, develop, and maintain data warehouse solutions supporting reporting and analytics. You will work with business stakeholders and data analysts to translate requirements into scalable designs.

This hybrid role offers flexibility for remote work while based in Kimberley with office access. The ideal candidate has 5+ years of data warehousing and BI experience, strong SQL, and hands-on ETL tool expertise (SSIS, Informatica,

Qualifications

• Bachelor's degree in CS/IT or related field.
• 5+ years in data warehousing, ETL, and BI.
• Experience designing dimensional models (star/snowflake).
• Strong SQL and ETL tool experience (SSIS, Informatica, Talend).

Responsibilities

• Design, develop, and implement scalable data warehouse solutions.
• Develop and optimize ETL/ELT processes to load data into the warehouse.
• Create and maintain data models, schemas, and dimensional structures.
• Write efficient SQL queries for data manipulation, analysis, and reporting.
• Collaborate with analysts and end-users to gather data requirements and deliver reporting solutions.
• Ensure data quality, integrity, and consistency in the warehouse.
• Troubleshoot data loading, performance, and accuracy issues.
• Monitor warehouse performance and implement optimizations.
• Document data warehouse designs, ETL processes, and data definitions.
• Stay updated with emerging data warehousing technologies and best practices.

Skills

SQL proficiency

ETL development

Data warehousing

Analytical thinking

Education

Bachelor's degree in CS/IT

Tools

SSIS

Informatica

Talend

SQL Server

Oracle

Snowflake

Redshift

Job description

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.