Senior Programmer Analyst - BI

Be part of 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 healthy dose of fun enable us to achieve great things every day. Our dedication has earned us the title of the world's best leisure airline multiple times, and we’re just getting started.

Want to join us? You will have the chance to enjoy exclusive travel privileges to explore the world and create unforgettable memories. You'll also have the opportunity to work in a modern, inspiring environment.

The incumbent will design, implement, and support quality BI applications that meet the business needs, and ensure that the BI applications created will meet specifications.

Responsibilities

• Design, plan, and implement BI solutions (such as ETL or ELT, reporting, and generating multidimensional structures) with the development team
• Actively participate in Transat’s digital transformation, with the migration of the actual BI platform to Cloud technologies
• Actively work with various contributors, from business partners to technical experts
• Make strategic recommendations in line with the current ecosystem and best practices
• Assess the general time required for all development stages of the solution
• Provide support and maintenance for the applications developed and, as needed, 24/7 emergency support

Requirements

• Bachelor’s degree in IT or a related discipline
• Six years of programming experience (minimum) and three years of BI application development experience;
• Application development background and experience with Microsoft BI suite (MSQL, SSIS, SSAS, SSRS, Power BI)
• Familiar with Cloud data technologies (Snowflake, Big Query), an asset
• Adept at ETL concepts and development (logging, tracking, Star schema and data vault modeling, metadata management, etc.)
• Creative, with an aptitude for and an interest in solving complex problems
• A cooperative team player
• Bilingualism mandatory (spoken and written)

#LI-IK1

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.