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, Quick Sight, etc.)
- Self-learner and eager to learn new software tools/technologies
