Senior Data Warehousing & BI Developer - Sand Tech Holdings Limited

ABOUT US

Africa has an untapped talent pool that is increasing exponentially, with a projected workforce that will exceed India and China by 2035. Fueled by this, our mission is to create work opportunities for millions of Africa's youth and solve the world's shortage of technology talent. 

Our company SAND has 500 staff members from 48+ countries with plans to acquire several companies around the world to become a multi-billion dollar global technology services provider that employs over 100,000 employees across the globe.

We have 2 brands represented in our ecosystem:

• With ALX, we're cultivating the fastest-growing pool of technology talent globally, training aspiring professionals in software engineering, cloud computing, data science, and Salesforce across over 60 countries. ALX fosters a vibrant community for top tech talent, igniting transforming careers by connecting top technology talent with extraordinary opportunities for impact.
• Through Sand Technologieswe support enterprises and scale-ups around the world to develop world class technology products, build great technology teams, generate more revenue, and deliver outstanding customer experience. Our clients include one of the largest cloud computing providers in the world as well as Bestseller A/S (Denmark), Create Prime (New Zealand), Stanbic Bank (Kenya), and Tamara (Dubai). 

With varying levels of expertise in software development, data, cloud, machine learning, artificial intelligence, UX design, web development, etc, we provide unparalleled opportunities to technology talent worldwide while reshaping industries, disrupting traditional business models, and creating new opportunities for innovation and growth.

We do hard things!

ABOUT THE TEAM

The tech team is responsible for all learning platforms at ALX: Intranet, auto correction system, cloud development sandbox for students, anti-plagia system, etc. We are bold, we move fast and we rely on self accountability and initiatives - from the design to deployment. No weekly/bi-weekly sprints - we have goals and features to deliver, we tackle them by iterating quickly and adjusting if needed. Our products are currently supporting the learning of more than 230,000 students (approx. 30,000 more students each month).

KEY 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:

• 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

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
• 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

Would you like to join us as we work hard, have fun and make history?