Marketing Data Engineering Specialist (Martech & AI)

In collaboration with the Marketing Data Manager, the Marketing Data Engineering Specialist acts as the operational technical pillar of the marketing data ecosystem.
The role is responsible for designing, building, operating, and ensuring the reliability of data flows that support Martech and artificial intelligence initiatives, ensuring that the right data is available, reliable, and actionable, at the right place and at the right time.
The incumbent translates strategic directions into concrete, scalable, and sustainable technical solutions that enable marketing activation, advanced analytics, and the operationalization of AI use cases.

Key Responsibilities

• Design, develop, and maintain robust and scalable data pipelines to ingest data from key marketing sources (CRM, Web, Customer Experience, media platforms, etc.) into the marketing data warehouse.
• Ensure data quality, consistency, and freshness through validation, cleansing, testing, and monitoring mechanisms.
• Automate data flows to ensure reliable, repeatable operations and minimize manual intervention.
• Model and structure data (tables, views, analytical layers) to facilitate marketing analysis and activation.
• Optimize data warehouse performance to support analytical needs and near‑real‑time marketing activations.
• Prepare and transform raw data into clean, documented, and usable datasets to fuel AI models, recommendation engines, advanced segmentation, and personalized activations.
• Act as a technical reference for marketing data flows, support the integration of new Martech platforms, and contribute to the rapid resolution of data‑related incidents.

• University degree in computer science, information systems, software engineering, mathematics, statistics, or a related field.
• 6 to 8 years of experience in technical data roles (data engineering, pipelines, data warehousing), ideally in a marketing, digital, or e‑commerce environment.
• Advanced proficiency in SQL and strong experience with at least one cloud data warehouse (Snowflake, BigQuery).
• Excellent command of a scripting language, preferably Python, and experience with data orchestration and transformation tools (e.g., Airflow, Prefect, dbt).
• Strong understanding of marketing data sources (Google Analytics, Google Ads, CRM, media platforms) is a significant asset.
• Excellent proficiency with MS Office tools (Word, Excel, Outlook, Teams) and demonstrated ease with collaborative digital tools and AI solutions (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 and partners in Quebec and internationally.

Please note that the internal job title may differ from the title used in this posting.

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.

Employment Equity

At Transat, we foster an environment where inclusiveness, respect and equity reign. We endeavour to build a workforce that reflects the diversity of our customers as well as the communities to which we travel. We encourage women, members of visible minorities, ethnic minorities, aboriginal peoples as well as people with disabilities to submit their candidacy. Transat will accommodate people with disabilities throughout the recruitment and selection process. If you require an accommodation, please contact us in order to work together in meeting adequately your needs.