Full-Time Senior Data Warehousing Developer
Sandtech is hiring a remote Full-Time Senior Data Warehousing Developer. The career level for this job opening is Experienced and is accepting USA based applicants remotely. Read complete job description before applying.
Sandtech
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
About Us
ALX Africa, a Sand company, is a global tech talent provider. We help aspiring tech leaders develop skills and secure careers in high-growth industries. Our programs provide graduates with access to global career opportunities.
About the Team
Our tech team manages ALX's learning platforms (intranet, auto-correction system, cloud sandbox, anti-plagiarism system). We prioritize speed, self-accountability, and rapid iteration. We're currently supporting over 230,000 students (growing by ~30,000 monthly).
Key Responsibilities
• Design, implement, and maintain the Data Warehouse and Data Lake
• Develop end-to-end business intelligence solutions including data visualization, ETL processes, data modeling, and warehousing.
• Implement ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Maintain data security and quality.
• Maintain and improve coding and delivery standards.
• Contribute to architecture design.
• Participate in report design and review solutions for accuracy, performance, usability, and business requirements.
• Review others' code and design.
• Identify opportunities to improve data quality, reliability, and efficiency.
• Collaborate with cross-functional teams to gather and analyze data warehouse requirements.
• Support and advise product and project managers.
• Provide technical mentorship to junior team members.
• Stay current with industry trends and drive technology adoption.
Requirements
• 5+ years of experience in data warehousing development, including ETL.
• Proficiency in SQL and relational database systems (e.g., SQL Server, PostgreSQL, AWS Redshift).
• Experience with large-scale data warehouses and complex data integration.
• Experience in 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).
• Experience modeling, managing, scaling, and performance tuning high-volume data warehouse environments.
• Experience with structured and unstructured data.
• Experience with dimensional data modeling.
• Passion for data storytelling using appealing visuals and graphics.
• Ability to translate business requirements into reports, views, and BI query objects.
• Fluency 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-learning and eager to learn new tools/technologies
- Experience working with external APIs
- Experience with programming languages like TypeScript/JavaScript, Bash, Python, Spark, PySpark, etc.