IT DATA ANALYST

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

Job summary

A Canadian airline is seeking an IT Data Analyst to contribute to data efficiency and security. Responsibilities include designing data structures, writing complex SQL queries, and maintaining BI processes. Candidates should possess a university degree in IT, 8-12 years of relevant experience, and excellent skills in SQL and Power BI, alongside being bilingual in French and English. The position offers competitive compensation and various benefits, including an RRSP and group insurance.

Benefits

Employee RRSP with 5% employer contribution

Group insurance plan

3-week vacation allowance

Company profit-sharing

Telemedicine program

Employee Assistance Program

Flight privileges and discounted travel

Qualifications

• 8 to 12 years of relevant experience required.
• Excellent knowledge of SQL and database management systems.
• Ability to work independently and as part of a team.

Responsibilities

• Design and manage data structures and database servers.
• Develop and optimize BI processes to meet business needs.
• Write complex SQL queries and use Python/R for data processing.

Skills

SQL

Python

R

Data analysis

Attention to detail

Bilingual (French-English)

Time management

Education

University degree in IT or related fields

Tools

Power BI

Azure

Job description

Join to apply for the IT DATA ANALYST role at Air Inuit

AIR INUIT - CORPORATE PROFILE

Air Inuit has been providing essential scheduled, charter, cargo and emergency air transportation services to Nunavik and beyond, 24 hours a day, 365 days a year, for 45 years. Owned collectively by the Inuit of Nunavik through the Makivik Corporation, the airline operates a fleet of 30 aircraft and employs over 1,000 people in one of the world's most demanding flying environments.

Air Inuit's management and team of dedicated employees are committed to pursuing the company's mission of providing safe, punctual and courteous air service to the people living and doing business in the beautiful Nunavik region of northern Quebec.

Position Overview

Contributes to the IT efficiency of organizational activities by designing, managing, maintaining and developing data structures and database servers. Coordinates the operation, protection and control of the use of databases. Provides technical support to database users.

Responsible for achieving expected results or implementing action plans relating to the protection of IT data against cyber threats, including monitoring security developments, analyzing the vulnerability of information systems and implementing risk mitigation solutions.

Contributes to the efficiency of business intelligence activities by exploiting and analyzing information from the data warehouse and multidimensional databases. Monitors performance indicators and advises stakeholders in the use and interpretation of data.

As a high-level professional, offers solutions for improving or optimizing processes, programs and work methods. Contributes to the resolution of complex problems, requiring a comprehensive and in-depth analysis and understanding of all variables. Collaborates with various internal and external stakeholders. Contributes to knowledge transfer through functional guidance and coaching of less experienced team members.

Duties and Responsibilities

1. Collaborate on the efforts devoted to the execution of developing IT projects.
2. Implement and continuously enhance BI processes to align with business needs and industry best practices.
3. Rigorously monitor and improve procedures and processes to optimize the quality of the services offered.
4. Ensure the creation and development of an internal knowledge base (including documentation).
5. Write complex SQL queries or use Python / R to extract, transform, analyze and shape data efficiently from multiple sources.
6. Create and maintain comprehensive cloud solutions, utilizing key components for data integration, management, and transformation.
7. Collect, process and study data collaborating with stakeholders to produce business analyses, recommendations, actionable insights and support decision-making.
8. Design and implement data models, including star schemas and semantic models, to enhance reporting and analytics.
9. Utilize M and DAX languages to develop, maintain, and optimize Power BI dashboards and reports.

Qualifications

• University degree in IT, statistics, finance, accounting or related fields with experience.
• At least 8 to 12 years of relevant experience.
• Technical knowledge :
• Excellent knowledge of SQL language and database management systems.
• Good knowledge of Python / R
• Previous experience with cloud platforms (Azure / Fabric)
• Good knowledge of data security best practices.
• Analytical mind and mastery of data analysis.
• Attention to detail, solution-oriented, customer-focused, and quality-driven.
• Expertise in developing content in Power BI actively using M and DAX language.
• Good knowledge of development concepts and methodologies.
• Work independently, while being a team player.
• Excellent oral and written communication.
• Bilingual (French-English).
• Exceptional perseverance in finding technical means to carry out projects and tasks.
• Excellent time management skills and ability to prioritize work while meeting deadlines under pressure (stress tolerance).

Compensation

• Compensation and benefits are determined in accordance with corporate policy;

Benefits

What we offer :

• An employee Registered Retirement Savings Plan (RRSP) - 5% employer contribution;
• A group insurance plan (life, medical, dental, short- and long-term disability);
• A 3-week vacation allowance (6%);
• Company profit-sharing;
• Telemedicine program for employee and family members;
• Employee Assistance Program (EAP) for employee and family members;
• A retirement allowance program;
• A program of flight privileges and discounted travel with several airlines around the world;
• Various innovative recognition programs.

Other Benefits

Referral program : This posting is eligible for the referral program for Air Inuit employees during the posting period.

APPLICATION

We thank all applicants for their interest in the position. We are proud of our culture, which encourages diversity. We believe in fair employment practices. All qualified candidates are considered for employment. Only those selected for the recruitment process will be contacted.

The use of the masculine gender has been adopted for ease of reading and is not intended to be discriminatory.

Air Inuit is committed to employment equity and invites applications from women, Aboriginal people, people with disabilities and members of visible minorities. For questions about job accessibility, contact [e-mail].

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology

Industries: Airlines and Aviation

Referrals increase your chances of interviewing at Air Inuit by 2x

Get notified about new IT Analyst jobs in Montreal, Quebec, Canada.