BI Expert, Digital Analytics Data

Join the journey!

Our mission is to be the preferred airline of our customers and our team. Open-mindedness, concern for others, intelligence at work, and above all, a good dose of fun allow us to achieve great things every day. Our commitment has earned us the title of best leisure airline in the world several times, and this is just the beginning. Want to join us? You will have the chance to enjoy exclusive travel privileges to explore the world and create unforgettable memories. You will also have the opportunity to work in modern and inspiring work environments.

In collaboration with the director, the person contributes to the design and evolution of digital analytics data solutions, leveraging Google Analytics (GA4) data to support marketing initiatives, customer experience, and web and mobile platform performance.

Responsibilities

• Design, plan and implement BI solutions (batch and streaming) to collect, transform and load GA4 analytical data;
• Structure, model, and document GA4 event-based data (web and mobile) to support analysis, visualization, and decision-making;
• Collaborate closely with the digital performance analyst to ensure optimal configuration of analytics tools (Google Analytics, Google Tag Manager);
• Participate in the implementation of tracking solutions and advertising pixels (Meta, TikTok, Snapchat, Floodlight, etc.);
• Work proactively with business and technology partners to understand needs and propose adapted BI solutions;
• Provide strategic recommendations aligned with best practices and the analytics ecosystem;
• Estimate effort required for various development phases of BI solutions;
• Ensure support, maintenance, and optimization of BI solutions, including performance and cost management in BigQuery;
• Support users in building reports and dashboards in Looker.

• Bachelor’s degree in Computer Science, Software Engineering, or a related field;
• Minimum of 6 years of experience, including at least 3 years in BI development and digital analytics;
• Strong knowledge of ETL/ELT concepts: historization, data modeling (star schema, data vault), lineage, and metadata management;
• Experience with digital analytics environments (GA4, Google Tag Manager, tracking plans, UTM, attribution models) and privacy concepts (consent, cookies, GDPR);
• Strong problem-solving skills, autonomy, and ability to collaborate with cross-functional teams;
• Excellent mastery of Google Cloud tools (BigQuery, Dataform, Looker, Fivetran);
• Excellent command of MS Office tools (Word, Excel, Outlook, Teams) and demonstrated ease with collaborative digital tools and AI (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.

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.