Published: Sun, 05 Jan 2025 06:51:24 GMT
Position: Senior Data Warehouse Developer
Company: ALX Africa (A division of Sand Company)
Location: Global (Remote)
Job Type: Full-time
Salary: Competitive
ABOUT US:
ALX Africa, a leading tech training company, is dedicated to addressing the global tech talent shortage. We equip individuals with the skills and tools they need to succeed in the digital world and provide access to a global network of career opportunities through our partnership with Sand. With cutting-edge technology training programs, we empower our graduates to build impactful careers in high-growth industries.
ABOUT THE TEAM:
Our tech team is responsible for all learning platforms at ALX, including the Intranet, auto-correction system, cloud development sandbox for students, and anti-plagiarism system. We pride ourselves on being bold, moving fast, and encouraging self-accountability and initiative from design to deployment. At ALX, we have goals and features to deliver, and we tackle them by iterating quickly and making adjustments as needed. Our products currently support the learning of over 230,000 students, with approximately 30,000 new students each month.
KEY RESPONSIBILITIES:
– Design, implement, and maintain our Data Warehouse and Data Lake
– Develop end-to-end business intelligence solutions, including data visualization, data modeling, ETL processes, and data warehousing
– Create and maintain ETL processes for data extraction, transformation, and loading from various source systems into the data warehouse
– Ensure data security and quality
– Uphold and improve coding and delivery standards
– Collaborate with cross-functional teams to gather and analyze data warehouse requirements
– Participate in architecture design processes
– Design and review reports to ensure accuracy, performance, usability, and alignment with business requirements
– Review code and designs from other team members
– Identify opportunities for improving data quality, reliability, and efficiency within the data warehouse environment
– 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:
– 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 developing near real-time DWH/data lake solutions
– Expertise in Data Warehouse, ETL, and Report design and development
– Strong analytical and troubleshooting skills
– Extensive experience with report development using various tools (SSRS, Power BI, Tableau, QuickSight, Excel, etc.)
– Fluent in modeling, managing, scaling, and performance tuning high-volume data warehouse environments
– Experience working with structured and unstructured data
– Experience with dimensional data modeling
– Experienced and passionate about data storytelling with appealing graphics and visualizations
– Ability to translate business questions and requirements into reports, views, and BI query objects
– Fluent in written and spoken English
NICE TO HAVE:
– BS/MS in Computer Science or equivalent
– Experience with DBT
– Experience with AWS tools (S3, Glue, Redshift, QuickSight, etc.)
– Self-learner with a desire to learn new software tools and 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
HOW TO APPLY:
If you are passionate about data and want to join a team that works hard, has fun, and makes history, please send your resume and cover letter to [contact email]. In your cover letter, please include a brief description of your experience and how it aligns with the requirements of this role. We look forward to hearing from you! Apply link
