Data Warehouse Architect

2 days ago

Apply Now

Receive Emails with Similar Jobs

Cruise Planners Travel Agency

WebsiteLinkedInAll Job Openings

Cruise Vacations • Land Vacations • All-inclusive Resorts • Tours • Car rental

2 - 10

Description

• We are seeking a skilled and experienced Data Warehouse Architect to join our team. • Responsible for designing, building, and managing an AWS-based data warehouse. • Preparing data for ETL processes utilized by Power BI and Excel. • Design, implement, and manage scalable data warehouse solutions on AWS. • Develop and optimize logical and physical data models to meet business requirements. • Build and maintain ETL pipelines to extract, transform, and load data from various sources. • Prepare datasets to be consumed by end-users, optimizing for performance and usability. • Manage AWS resources, ensuring efficient performance, cost management, and security. • Monitor and improve the performance of the data warehouse, tuning queries.

Requirements

• Minimum 3 to 5 years of experience working as a Data Warehouse Architect, Data Engineer, or similar role, with hands-on experience in AWS data warehouse technologies. • Expertise in designing and managing data warehouses on AWS (Redshift, S3, Glue, etc.). • Strong experience with ETL tools and processes, particularly in preparing data for use in Power BI and Excel. • Proficiency in SQL and scripting languages (e.g., Python) for data processing and automation. • Familiarity with BI tools, particularly Power BI and Excel, including how to structure data for optimal performance in these tools. • Experience in data modeling, query optimization, and database performance tuning. • Strong knowledge of data warehousing best practices and cloud architecture principles. • Excellent problem-solving and analytical skills. • Effective communication and documentation skills. • Experience with MySQL is required.