Business Intelligence Developer

Gestal; Mirabel; On-site; CAD 70,000 - 90,000; Full time

Job summary

Gestal in Mirabel (Quebec, Canada) is seeking a Business Intelligence Developer to join the Program Applications and Tools team. The role focuses on designing data solutions, building data extractions, consolidating and normalizing data, and visualizing harmonized data through reports.

You will contribute to the evolution of BI tools, ensuring security and compliance with business requirements while supporting both program and engineering needs.

Qualifications

• Experience in BI development or data analytics.
• Ability to design data solutions and build data extractions.
• Experience with reporting and data visualization tools.
• Ability to translate stakeholder requirements into solutions.
• Focus on security and compliance in tool evolution.

Responsibilities

• Design data solutions and develop data extractions from multiple sources.
• Consolidate and normalize data for a BI data warehouse.
• Visualize harmonized data through reports and dashboards.
• Identify opportunities to improve BI platform efficiency and implement solutions.
• Document development with comments and templates; maintain documentation.
• Gather stakeholder requirements and translate them into business solutions.

Skills

Data analysis

SQL

Power BI

Python

Tools

T-SQL

Reporting Services

Power BI

Analysis Services

Qlik Sense

Python

Google Apps Script

Job description

You have experience in software development, business intelligence, or database development, and you want to evolve and develop new skills? This position is for you!

We are looking for a Business Intelligence Developer to join our Program organization based in Mirabel (Quebec, Canada).

You will be part of the Program Applications and Tools team, attached to the Competence Center, responsible for developing data analysis solutions for the entire organization, with a focus on Program and Engineering.

Your role as a Business Intelligence Developer will be to design data solutions, including the development of data extractions from various business applications, data consolidation and normalization, as well as the visualization of harmonized data through reports. Your role will also involve contributing to the evolution of our tools during their transformation to ensure security and compliance with business requirements.

Your challenges:

• Develop and maintain the A220 business intelligence solution using Microsoft SQL tools (T-SQL, Reporting Services, Power BI, Analysis Services, Qlik Sense);
• Develop extraction routines for various data sources from a multitude of different technologies, departments, and network locations to be integrated into the data warehouse used for business intelligence (Python, Google App Script);
• Develop various types of reports such as KPIs and Analytics for senior management and the operational level;
• Identify opportunities for improvement and optimization of the efficiency of all processes used within the global business intelligence platform, and then develop the necessary solutions to realize the identified opportunities;
• Document your new development and improvements through thorough code comments and using documentation templates;
• Gather stakeholder requirements and translate them into a business solution for users.