Senior Data Warehouse Engineer

ABOUT ALX AFRICA

ALX Africa, a non-profit organisation under the ALX Foundation, is dedicated to unlocking the potential of Africa's digital future. Formerly part of Sand Tech Holdings, we've embarked on an independent journey to provide world-class tech skills training and career acceleration programmes. Our mission is to bridge the digital divide, upskill and reskill talent, and create a generation of innovative leaders. By 2030, we aim to empower 2 million Africans to secure sustainable tech careers.

With hubs in 8 cities across Africa and counting, we provide safe access to quality learning and a dedicated network of expert instructors. Our innovative programmes equip learners with the practical skills and knowledge needed to succeed in today's rapidly evolving tech industry. Through a combination of rigorous coursework, industry partnerships, and hands-on projects, we prepare our students for in-demand roles in software engineering, data science, and cybersecurity.

We achieve this by:

• Providing young professionals with access to the most in-demand tech skills that will power the future.
• Empowering the next generation of technology innovators, entrepreneurs, and business leaders through challenging, real-world coursework.
• Building a lifelong, impactful community of tech professionals that support them at all stages of their career journey. 

 Visit our website www.alxafrica.com to learn more about our digital revolution.

ABOUT THE DATA  DEPARTMENT

We are a team of passionate and dedicated data engineers, analysts and scientists who are on a mission to build data products that solve the needs of our customers. This includes a data warehouse, BI dashboards, Impact tracking and Predictive & AI models.  We work as business partners with our key stakeholders to empower them with data access, visibility and insights to make data driven decisions and optimise outcomes (enrolment, payment, retention, placements)  across the talent journey to enable growth and scale while minimising costs.

ABOUT THE ROLE

As a Data Warehouse Developer you will be working with the latest cloud technologies to design and implement the next generation data pipelines, analytics and BI platform to support our whole system of learning applications and selection application to deliver the best in class technology. 

KEY RESPONSIBILITIES

• Design, implement and maintain our data warehouse.
• Design, implement and maintain ETL processes for data extraction, transformation, and loading from various source systems into the data warehouse
• Ensure and maintain data security and quality
• Maintain and improve our standards of coding and deliveries
• 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 DWH development

REQUIREMENTS:

• 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
• You are fluent in modeling, 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 modeling
• You have strong analytical and troubleshooting skills
• Language: Fluent written and spoken English

NICE TO HAVE:

• 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

This is a remote role, with a preference for candidates based in the GMT to GMT+4 time zone. Join us to build cutting-edge data solutions that shape the future of education and impact!