Analyst Business Intelligence

Air Transat; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading airline in Montreal seeks a BI Developer to design and maintain Power BI reports and data models. This role includes collaboration across departments to optimize performance and support strategic decisions. Candidates should have a university degree, BI experience, and proficiency in both French and English.

Benefits

Exclusive travel privileges

Modern work environment

Qualifications

• Experience in BI development, especially with Power BI.
• Strong understanding of data modeling principles.
• Ability to analyze complex business requirements.

Responsibilities

• Design, develop, and maintain data models and Power BI reports.
• Integrate various data sources and ensure data consistency.
• Support users and analysts in utilizing Power BI.

Skills

Power BI

SQL

Data modeling

ETL processes

DAX

Communication skills

Teamwork

Education

University degree in computer science, business intelligence, or related field

Tools

Power Platform

Power Query

Job description

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 will also have the opportunity to work in a modern, inspiring environment.

Job Description

The incumbent is required to demonstrate analytical skills and a good knowledge of database systems in order to support the organization in its decision-making. The person will be responsible for the design, development and maintenance of data models as well as Power BI reports to support the company's strategic decisions.

- Work closely with teams across departments to ensure the creation of Power BI reports and dashboards based on performance indicators.

- Maintain certain data tables and dimensions

- Create efficient data models in Power BI;

- Integrate multiple data sources (SQL Server, Snowflake, Excel, API, etc.) and ensure consistency and quality;

- Ensure ongoing performance optimization of Power BI models and reports;

- Support users and analysts across departments in using Power BI;

- Ensure technical and functional documentation of developed solutions;

- Participate in data governance and the evolution of BI best practices within the organization.

Qualifications

• Education: University degree in computer science, business intelligence (BI), or a related field.
  
  

• BI Experience: Relevant experience in BI development, including significant work with Power BI.
  
  

• Data Modeling and Analysis: Strong understanding of data modeling principles and ability to analyze complex business requirements.
  
  

• Microsoft Tools: Proficiency with Microsoft Business Intelligence tools such as Power Platform, Power BI, Power Query, and DAX.
  
  

• Databases: Solid knowledge of SQL and hands-on experience with relational databases.
  
  

• Data Architecture: Familiarity with data warehousing concepts, ETL processes, and data governance practices.
  
  

• Creativity and Innovation: Talent for proposing innovative and effective solutions.
  
  

• Interpersonal Skills: Excellent communication skills, strong team spirit, autonomy, and organizational abilities.
  
  

• Languages: Proficiency in French and English, both spoken and written*
  
  

*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.

Additional Information

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.