Data Architect

Transat AT

$110K — $130K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • University degree in Computer Science, Data Science, AI, or a related field.
  • 8+ years in Data Architecture and 12+ years in IT.
  • Expertise in Data Warehousing, Data Vault 2.0, Lakehouse architectures, and enterprise data governance.
  • Strong leadership, communication, and strategic thinking skills.
  • Solid understanding of AI, Machine Learning, and their applications in data ecosystems.
  • Experience with cloud data platforms and streaming technologies, plus enterprise data catalogs.
  • Proficiency in Snowflake, Azure Data Platform, BigQuery, Power BI, SQL, and Python.

Responsibilities

  • Define and maintain target data architectures for cloud platforms like Snowflake and Azure.
  • Design enterprise data models, including dimensional and BI semantic layer architectures.
  • Ensure data consistency across multiple enterprise systems like ERP and CRM.
  • Establish standards for data modeling, integration, and security.
  • Design AI-ready architectures for advanced analytics and machine learning.
  • Promote DataOps, DevOps, and CI/CD practices for data pipelines.
  • Collaborate with architects, data engineers, BI teams, and stakeholders to align strategy with objectives.
  • Monitor industry trends and recommend data and AI initiatives.

Benefits

  • Collaborative work environment with cross-functional teams.
  • Opportunity to lead innovative data architecture projects.
  • Access to professional development in emerging data technologies.
  • Use of advanced AI tools and practices in the role.
  • Exposure to strategic initiatives that enhance business value.
Full Job Description
Job Description

In collaboration with the Director, Data & Analytics Solutions, the incumbent defines, evolves, and maintains the target data architecture and business intelligence ecosystem. The person in this role designs scalable, modern, and AI-ready data solutions while ensuring data consistency, governance, and business value across the organization.

Responsiblities
  • Define, document, and maintain target data architectures, including Data Warehouse, Data Lake, Lakehouse, and BI solutions across modern cloud platforms such as Snowflake, Azure, Microsoft Fabric, Power BI, dbt, and BigQuery.
  • Design and evolve enterprise data models, including dimensional, Data Vault 2.0, and BI semantic layer architectures.
  • Ensure data integration and consistency across multiple enterprise systems, including ERP, CRM, CRS, DCS, and other airline-related platforms.
  • Establish standards and best practices for data modeling, integration, transformation, quality, governance, cataloging, lineage, and security.
  • Design AI-ready architectures that support advanced analytics, machine learning, predictive models, personalization, optimization, and generative AI use cases.
  • Promote DataOps, DevOps, CI/CD, and MLOps practices, including automated testing, deployment, monitoring, and continuous improvement of data pipelines.
  • Collaborate with enterprise architects, solution architects, data engineers, BI teams, and business stakeholders to align data strategy with organizational objectives.
  • Monitor industry trends, evaluate emerging technologies, and recommend strategic data and AI initiatives that enhance business value and operational efficiency.


Qualifications
  • University degree in Computer Science, Data Science, Artificial Intelligence, or a related field.
  • Minimum of 8 years of experience in Data Architecture and more than 12 years of experience in Information Technology.
  • Proven expertise in Data Warehousing, Data Vault 2.0, Lakehouse architectures, Data Mesh, enterprise data governance, quality management, security, and cataloging.
  • Strong leadership, communication, stakeholder management, strategic thinking, and influencing skills.
  • Solid understanding of Artificial Intelligence, Machine Learning, Large Language Models (LLMs), Generative AI, and their practical application within enterprise data ecosystems.
  • Experience with cloud data platforms, streaming technologies (Snowpipe Streaming, Kafka, Azure Event Hubs), enterprise data catalogs (Purview, Collibra, Alation), semantic layers, and cloud cost optimization, particularly Snowflake credit management. SnowPro Advanced Architect certification or equivalent is considered an asset.
  • Advanced proficiency with Snowflake, Microsoft Fabric, Azure Data Platform, BigQuery, Power BI, SQL, Python, DBT, and a demonstrated ability to leverage collaborative digital tools and AI technologies (e.g., Copilot). Ability to quickly learn and adapt to new technologies.
  • Oral and written fluency in French and English.
    A good knowledge of French is required for positions in Quebec. The incumbent will be required to communicate and collaborate frequently in English, both orally and in writing, with colleagues, customers, and other stakeholders in Quebec, the rest of Canada, and internationally.

Assets
  • Experience working with loyalty programs.
  • Experience in the aviation, travel, or airline industry.


Additional Information

Artificial intelligence tools are used to analyze applications, whether to sort or preselect profiles based on criteria related to job requirements. All applications are then reviewed by our recruitment team to ensure a fair and inclusive process.

Similar Jobs

More Jobs at Transat AT

More Information Technology Jobs

Find similar Data Architect jobs: