Senior Data Warehousing Developer
2025-01-05
USA
Sandtech
ABOUT US
ALX Africa, a Sand company, is at the forefront of addressing the global tech talent shortage. We provide the tech-fluent leaders of tomorrow with the skills and tools they need to succeed in today's digital world. Through our cutting-edge technology training programs, we empower individuals to build impactful careers in high-growth industries. Our partnership with Sand provides our graduates with access to a global network of career opportunities, ensuring a seamless transition from learning to employment.
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?
ALX Africa, a Sand company, is at the forefront of addressing the global tech talent shortage. We provide the tech-fluent leaders of tomorrow with the skills and tools they need to succeed in today's digital world. Through our cutting-edge technology training programs, we empower individuals to build impactful careers in high-growth industries. Our partnership with Sand provides our graduates with access to a global network of career opportunities, ensuring a seamless transition from learning to employment.
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?