Lead Data Warehouse & BI Architect

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

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.