Sr. Data Warehouse Architect

Sr. Data Warehouse Architect

Collette is seeking a Sr. Data Warehouse Architect to join our Data & Analytics Team. This is a hybrid role based at our headquarters in Pawtucket, RI.

About Collette:
Let Us Show You the World

There has never been a better time to be in the travel industry. See the world, connect with others, and experience the immersive benefits of one of the trendiest industries when you join the Collette team! As the longest-running tour operator in North America, our family-owned business leads the industry in innovation and expertise. Collette's passionate team works hard to fulfill travel dreams and is always looking for talent that will help to shape the company's future.

Being part of the Collette team means having a willingness to grow, a desire to learn and ask questions, and a zest for seeing the world. From giving back to local communities to creating incredible experiences for a world of travelers and being part of a value-oriented team that cares for one another – Collette is all about the people.

So, what are you waiting for? Your journey starts here.

Job Summary:

We are seeking a highly experienced, hands-on, and strategic Senior Data Warehouse Architect to lead the implementation of enterprise data and analytics solutions. You will define, design, and implement scalable data solutions that support analytics, AI, business intelligence, data governance, and operational integrations, while ensuring data quality and integrity. Additionally, you will be responsible for developing strategies for future data integration, business intelligence, and AI data agent capabilities.

The ideal candidate combines deep technical expertise in modern cloud data platforms, especially Snowflake and Microsoft Fabric, with strong business acumen. This individual will play a critical role in enabling data-driven decision-making and advancing enterprise data modernization initiatives.

Primary Functions:

• Key stakeholder in the evolution of our strategic roadmap; help identify, define, and incorporate modern capabilities and approaches.
• Design a scalable, secure, and resilient data platforms supporting enterprise reporting, self-service analytics, AI/ML, and operational workloads.
• Establish architectural patterns for data ingestion, transformation, storage, integration, and consumption.

• Lead the implementation of the modern enterprise data solution leveraging cloud-based data platforms leveraging technologies such as Snowflake, Microsoft Fabric, and Matillion.
• Drive platform modernization and migration initiatives from legacy environments.
• Develop conceptual, logical, and physical data models for enterprise-wide initiatives based on business requirements meanwhile following 3NF and dimensional approaches.
• Design appropriate data assets/structures – Data Warehouse, Data Marts, Data Lake, and Reporting/Analytics layer.
• Design and develop robust data integration architecture - Data Pipelines, ELT – that meets the SLAs and performance requirements.
• Define and implement new modern patterns for data engineering including prompt engineering and coding agents (e.g. Snowflake Cortex Code, Microsoft Copilot, etc.).
• Design and write code for ELT data solutions.
• Be responsible for data quality and performance of the data value chain.
• Design and develop data pipelines for various patterns including unstructured/semi-structured data, API, real time data streaming, etc.
• Oversee the integration of data from various sources.

• Partner with Data Governance teams to establish metadata management, lineage, master data management, and data quality standards.
• Manage Data Governance (Metadata Mgmt., Data Lineage, Data Quality, Data Access & Security, Data Privacy, Compliance)
• Implement architectural controls supporting privacy, security, and retention requirements.
• Collaborate with governance and catalog teams to ensure data discoverability and trusted data assets.

• Define architecture standards supporting enterprise BI platforms such as Power BI.
• Enable scalable semantic models, reusable data products, and performance…