> Markdown version of [/jobs/ext/1349649-sr-data-warehouse-architect](https://www.wearedevelopers.com/jobs/ext/1349649-sr-data-warehouse-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. Data Warehouse Architect - **Company:** COLLETTE TRAVEL SERVICE INC - **Location:** Pawtucket, RI, United States - **Experience:** Expert - **Salary:** $140,000.0 - $190,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Business Analytics Applications, Data Analysis, Architectural Patterns, ARM Architecture, Microsoft Azure, Information Systems, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Mart, Data Security, Data Systems, Data Warehousing, Database Queries, Software Design Patterns, Digital Assets, Dimensional Modeling, Python (Programming Language), Machine Learning, Metadata, Meta-Data Management, Metadata Repositories, Microsoft SQL Server, Performance Tuning, Power BI, Data Streaming, Cloud Platform System, Data Ingestion, Microsoft Power Automate, Snowflake, Prompt Engineering, Generative AI, Microsoft Fabric, Data Lakes, Semi-structured Data, Information Technology, Data Lineage, Data Management, Physical Data Models, Data Lakehouse, Domain Driven Design, Data Pipelines - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=7ab0dc1d3377ff12 ## About the Role * Strong analytical and problem-solving skills * Ability to test, troubleshoot and resolve system problems under tight deadlines. * Ability to think out of the box to come up with solutions to complex data issues. * Outstanding attention to detail with high levels of concentration. * Ability to multi-task with a strong drive for results. * Demonstrated ability in prioritizing and handling multiple projects. * Excellent project management skills with a proven ability to meet established deadlines. * Extensive latitude for independent judgment, must be able to work independently * Talent for quickly learning new disciplines, approaches, technology, etc. * Excellent communication and interpersonal skills. Knowledge & Skills * Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field. * 10+ years of experience in data architecture, data engineering, or related disciplines. * Strong expertise in data modeling, data warehousing, dimensional modeling, and data integration. * Experience with cloud platforms such as Microsoft Azure. * Hands-on experience with modern data technologies including: + Snowflake + Microsoft Fabric + Matillion + Azure/Fabric Data Factory + SQL Server + Power BI * Strong SQL skills and Python skills. * Experience implementing data governance and data catalogs. * Excellent communication, presentation, and stakeholder management skills. * Experience supporting AI, machine learning, and generative AI initiatives. * Knowledge of Data Lakehouse / Medallion / domain-driven architecture principles. * Experience within travel, hospitality, retail, financial services, or other large-scale consumer-facing industries. ## Description 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: Enterprise Data Architecture * 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. Data Platform Leadership * 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, Claude, 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. Data Governance & Quality * 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. Business Intelligence, AI, & Analytics * Define architecture standards supporting enterprise BI platforms such as Power BI. * Enable scalable semantic models, reusable data products, and performance optimization strategies. * Contribute and support the development of Snowflake Cortex and Microsoft Copilot Data Agents. * Support advanced analytics, machine learning, and AI initiatives by designing data architectures that maximize accessibility and reliability. Leadership * Lead design and development reviews and provide technical guidance on complex data initiatives. * Mentor data engineers, analysts, and architects on best practices, design patterns, and emerging technologies. * Influence technology strategy and vendor evaluations. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)