Data Architect with Azure

ClientOur client is a leading global travel agency network specializing in luxury and experiential journeys. They are evolving their Analytics & Reporting capabilities to deliver clear, actionable insights that support informed decision‑making across products, programs, and leadership built on a scalable and efficient analytics foundation.Position overviewWe are seeking a Data Architect to define and evolve the foundational data structures that power internal reporting, partner analytics, and commercial insights. This role is responsible for canonical data modeling, identity linkage, attribution feasibility, and the overall Snowflake warehouse design. The Data Architect will ensure data can be reliably consumed by downstream analytics tools, including Tableau dashboards.ResponsibilitiesDesign and maintain canonical data models across agency, advisor, partner, and transactional domainsDefine identity linkage strategies across multiple source systems and APIsEvaluate and document attribution feasibility for reporting and commercial analytics use casesOwn Snowflake warehouse design, including facts, dimensions, and conformed entitiesPartner with Data Engineers to ensure architectural standards are implemented consistentlyCollaborate with BI and Tableau users to ensure data models support reporting and access needsEstablish modeling standards, documentation, and data governance best practicesRequirementsExperience with Snowflake, including analytical schema design and performance optimizationAdvanced experience with SQL for analytics and data modelingExperience working with Azure Blob StorageExperience with API‑driven ingestion patternsStrong knowledge of data warehousing concepts and analytics architectureNice to haveFamiliarity with DBT or similar transformation frameworksExperience with identity resolution or master data managementGeneral awareness of Tableau consumption patternsUnderstanding of Tableau Cloud, including how data models are consumed, filtered, and secured in dashboards