Senior Data Warehouse Developer

Sand Technologies; Cape Town; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A leading AI solutions company is seeking a Senior Data Warehouse Developer in Cape Town. This role involves implementing scalable data pipelines and advanced analytics solutions. Candidates should have 5+ years in data warehousing and proficiency in SQL, along with strong analytical skills. Join a team dedicated to solving real-world challenges using cutting-edge technology. The position offers a collaborative environment and a focus on operational excellence.

Qualifications

• 5+ years of experience in data warehousing development.
• Proficiency in SQL programming with relational databases.
• Experience managing complex data integration projects.
• Expertise in Data Warehouse and ETL design.
• Extensive experience with reporting tools.

Responsibilities

• Design, implement and maintain Data Warehouse and Data Lake.
• Develop end-to-end BI solutions including data modeling.
• Maintain data security and quality.
• Review code and design for improvement opportunities.
• Mentor junior team members in BI development.

Skills

Data warehousing development

ETL design and implementation

SQL programming

Report development tools (SSRS, Power BI, Tableau)

Data storytelling

Analytical skills

Education

BS / MS in Computer Science or equivalent

Tools

AWS Redshift

SQL Server

PostgreSQL

Job description

About Sand

Sand Technologies is a fast-growing enterprise AI company that solves real-world problems for large blue-chip companies and governments worldwide.

We're pioneers of meaningful AI : our solutions go far beyond chatbots.

We are using data and AI to solve the world's biggest issues in telecommunications, sustainable water management, energy, healthcare, climate change, smart cities, and other areas that have a real impact on the world.

For example, our AI systems help to manage the water supply for the entire city of London.

We created the AI algorithms that enabled the 7th largest telecommunications company in the world to plan its network in cities in record time.

And we built a digital healthcare system that enables 30m people in a country to get world-class healthcare despite a shortage of doctors.

We've grown our revenues by over % in the last 12 months while winning prestigious scientific and industry awards for our cutting‑edge technology.

We're underpinned by over engineers and scientists working across Africa, Europe, the UK and the US.

About the role

As a Senior Data Warehouse Developer, you will implement scalable data pipelines, analytics solutions, and BI platforms using modern cloud technologies.

Your work will ensure high-quality, secure, and reliable data systems that support a wide range of impactful projects.

Specific Responsibilities

Design, implement and maintain our Data Warehouse

Design, implement and maintain our Data Lake

Design, implement and maintain of end-to-end business intelligence solutions, including data visualization, data modeling, ETL processes, and data warehousing

Design, implement and maintain ETL processes for data extraction, transformation, and loading from various source systems into the data warehouse

Maintain data security and quality

Maintain and improve our standards of coding and deliveries

Participate and contribute to the architecture design process

Participate in reports design and review proposed solutions to ensure they meet accuracy, performance, usability and business requirements

Review other people's code and design

Identify opportunities for improving data quality, reliability, and efficiency within the data warehouse environment

Collaborate with cross-functional teams to gather and analyze data warehouse requirements

Support and advise the Product and Project Manager team

Provide technical mentorship to junior team members, guiding them in best practices for BI development and data engineering

Keep up-to-date with the latest technologies and lead adoption initiatives

Requirements - Essential

You have 5+ years of experience in data warehousing development, including ETL design, development, and implementation

Proficiency in SQL programming and experience with relational database systems (e.g. SQL Server, PostgreSQL, AWS Redshift)

Experience working with large-scale data warehouses and managing complex data integration projects

Experience in development of near real‑time DWH / data lake solutions

You have expertise in Data Warehouse, ETL, and Report design and development

You have strong analytical and troubleshooting skills

You have extensive experience with report development using various tools (SSRS, Power BI, Tableau, QuickSight, Excel, etc.)

You are fluent in modelling, managing, scaling and performance tuning of high volume data warehouse environments

You have experience in working with structured and unstructured data

You have experience with dimensional data modelling

You are experienced and passionate about data storytelling with appealing graphics and visualizations

You have the ability to translate business questions and requirements into reports, views, and BI query objects

Language : Fluent written and spoken English

Requirements - Preferable

BS / MS in Computer Science or equivalent

You have experience with DBT

You have experience with AWS tools (S3, Glue, Redshift, QuickSight, etc.)

Self‑learner and eager to learn new software tools / technologies

Experience working with external APIs to extract and import data

Experience with languages such as TypeScript / JavaScript, Bash, Python, Spark, PySpark or other similar programming languages

Personal Attributes

Client Centricity & Integrity : We let Our Clients Run the Company, Surf Like Yvon to stay true to our values, and Play the Long Game with integrity.

Collaboration and Inclusion : We live by Each One, Teach Ten and ensure Everybody is Welcome.

Operational Excellence and Simplicity : We K.I.S.S. by keeping things simple while always striving to Raise the Bar.

Action, Ownership, and Execution : We Decide, Get Stuff Done, and Do Hard Things with accountability.

Growth, Innovation, and Resilience : We Choose Growth, Pioneer boldly, and remember There is No Failure.

Due to the considerable amount of virtual work and interaction with colleagues and customers in different physical locations internationally, it is essential that the successful applicant has the drive and ethic to succeed in working in small teams physically but in larger efforts virtually.

Self‑drive to communicate constantly using web collaboration and video conferencing is essential.