Travel FI Data Audience Analyst

Air Canada; Dorval; On-site; CAD 90,000 - 125,000; Full time

Job summary

Air Canada is seeking an experienced Travel & FI Data Audience Analyst to design, automate, and optimize customer marketing audiences across Air Canada and Aeroplan channels. You will work with Snowflake, Dataiku, and Adobe Campaign Suite to deliver scalable targeting, consent management, and crediting processes while ensuring data quality and governance.

The role collaborates with Analytics, Campaign Operations, Marketing, and Technology teams to improve delivery speed and campaign readiness

Qualifications

• 3–5 years of experience in CRM campaign operations or marketing tech.
• Experience with large-scale customer datasets.”
• Advanced SQL development experience including complex queries and data transformations.

Responsibilities

• Own end-to-end delivery of campaign audiences from design to activation.
• Develop and optimize targeting and segmentation logic for multiple campaigns.
• Support offer registration, consent management, eligibility, and crediting logic.
• Develop audience workflows in Adobe tools and Dataiku/Snowflake.
• Prepare and deliver audience files to activation teams for paid media platforms.
• Design complex SQL-based audience views and transformations in Snowflake and Dataiku.
• Integrate data from loyalty, travel, partner, and engagement sources.
• Perform data validation, QA, and post-launch checks for targeting accuracy.
• Create reusable audience frameworks and technical documentation.
• Identify opportunities to automate recurring audience creation and processes.
• Apply Adobe Experience Cloud knowledge to future capabilities and automation.
• Collaborate with cross-functional teams to clarify requirements and mitigate risks.

Skills

SQL development

Data analysis

Audience segmentation

Stakeholder management

Project management

Problem solving

Documentation

Quality assurance

Campaign operations

Education

University degree in Computer Science / Information Systems

Related experience

Tools

Snowflake

Dataiku

Adobe Campaign Classic

Adobe Experience Platform

Adobe Journey Optimizer

Job description

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

The Travel & FI Data Audience Analyst supports the design, execution, automation, and optimization of customer marketing audiences across Air Canada and Aeroplan channels. The role develops scalable targeting and segmentation solutions; supports Aeroplan offer registration, consent, eligibility, and reward crediting processes; and ensures accurate and timely audience delivery through Snowflake, Dataiku, Adobe Campaign Classic, Adobe Experience Platform, and Adobe Journey Optimizer. Working across complex data environments, the role collaborates with Analytics, Campaign Operations, Marketing, and Technology teams to improve data quality, operational efficiency, governance, and the delivery of personalized customer communications.

Responsibilities

• Own the end-to-end delivery of campaign audiences, from requirements assessment and audience design through data extraction, validation, delivery to activation teams, issue resolution, and post-launch quality assurance.
• Develop, maintain, and optimize targeting and segmentation logic for email, digital, loyalty, travel, and financial institution partner marketing campaigns.
• Support Aeroplan offer registration, consent management, campaign eligibility, reward crediting logic, and the generation and validation of crediting files.
• Develop and support audience workflows in Adobe Campaign Classic, Adobe Experience Platform, and Adobe Journey Optimizer, within the scope of audience operations.
• Prepare and deliver audience files and segments to activation teams for use on Meta, Google, and other paid-media platforms, without ownership of media strategy, campaign creative, or channel execution.
• Design and develop complex SQL-based audience views, multi-step segmentation logic, and data transformations in Dataiku and Snowflake.
• Integrate and reconcile data from loyalty, travel, financial institution partner, campaign, customer preference, and digital engagement sources.
• Perform data validation, audience quality assurance, deployment testing, troubleshooting, and post-launch checks to ensure targeting accuracy, compliance, and campaign readiness.
• Create and maintain reusable audience frameworks, recurring campaign assets, data-source mappings, technical documentation, version control, and change-management practices.
• Identify and implement opportunities to automate recurring audience creation and operational processes, reducing manual effort while improving scalability, reliability, and delivery speed.
• Apply knowledge of Adobe Experience Cloud to support future-state audience capabilities, AI agents, workflow automation, and the modernization of marketing operations.
• Manage multiple concurrent campaign requests, assess complexity and operational dependencies, identify delivery risks, communicate impacts, and implement mitigation plans to support accurate and timely audience delivery.
• Collaborate with Campaign Operations, Customer and Loyalty Analytics, Data Engineering, Marketing Technology, IT, agencies, partners, and suppliers to clarify requirements, resolve issues, improve governance, and continuously strengthen audience delivery processes.

Qualifications

• University degree in Computer Science, Information Systems, Data Analytics, Marketing Technology, or another relevant discipline, or equivalent relevant experience.
• Minimum of 3-5 years of experience in CRM campaign operations, marketing technology, data engineering, marketing analytics, or a related field.
• Advanced SQL development experience, including complex queries, relational databases, data transformation, deduplication, and audience segmentation logic.
• Hands-on experience with Snowflake and large-scale customer or marketing datasets.
• Experience with Adobe Campaign Classic, including workflow development, audience preparation, validation, and deployment support.
• Strong understanding of customer segmentation, campaign targeting, personalization, consent management, privacy, compliance, and marketing data governance.
• Strong analytical, documentation, quality assurance, and problem-solving skills, with close attention to detail and accuracy.
• Strong project management, organizational, communication, and stakeholder management capabilities, with the ability to manage competing priorities, communicate risks, and drive issue resolution in a fast-paced environment.

Conditions Of Employment

Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment. Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.

Linguistic Requirements

Based on equal qualifications, preference will be given to bilingual candidates.

Diversity and Inclusion

Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees’ unique contributions to our company’s success.

As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.

Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.