Purpose of the Role
We are seeking an experienced Data Warehouse Architect to design, develop, and maintain our enterprise data warehouse infrastructure. Your role will involve leveraging your expertise in data warehousing, ETL processes, and database systems to ensure high-quality, scalable, and secure data solutions for the organization. Collaboration with business stakeholders to understand data requirements and create comprehensive data models and documentation will be key aspects of this role.
Duties and Responsibilities
- Design and implement scalable data warehouse solutions
- Develop ETL processes for data integration from multiple sources using tools like AWS Glue and DBT
- Optimize query performance and data storage, particularly within AWS Redshift
- Ensure data quality, consistency, and security
- Collaborate with business stakeholders to understand data requirements
- Create and maintain data models and documentation
- Utilize SQL and Python for data manipulation and analysis
- Develop data visualizations and reports using PowerBI
Required Experience & Knowledge
- 5+ years experience in data warehouse design and implementation
- Expertise in SQL and data modeling techniques
- Proficiency with ETL tools and processes, especially DBT and AWS Glue
- Strong knowledge of database systems, particularly AWS Redshift
- Excellent problem-solving and communication skills
Preferred Qualifications
- Experience with cloud data warehouse platforms, especially AWS
- Knowledge of data visualization tools, particularly PowerBI
- Familiarity with machine learning and advanced analytics
Skills and Attributes
- Strong problem-solving skills and ability to work independently and within a team
- Excellent time and task management skills
- Good team player with the desire to learn and improve
- Strong communication skills and client-oriented approach
Required Education & Qualifications
- Advanced level of both spoken and written English language
- Bachelor’s or Master’s degree in Computer Science or relevant experience
- Any relevant certification would be considered a plus
