Specialist Data & AI - Business Intelligence - Temporary

Air Canada•Dorval, QC

16h

About The Position

Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation. The Specialist, Data & AI – BI leads Business Intelligence projects by understanding the requirements, analyze and collects requisite data, design & develop BI solutions and provides ongoing support of to the business to help provide effective insights and drive decision making within the organization. They follow effective data policies, standards, guidelines, and usage of data within the organization. The Specialist, Data & AI – BI will be reporting to the Manager, Data & AI.

Requirements

Bachelor’s degree in a related field (Information Technology, Engineering, Computer Science).
Minimum of 5 years of experience in a large company querying and manipulating datasets.
Minimum of 5 years of hands-on experience in Power BI administration, report development, and data modeling.
Expertise in creation of datasets, data models, BI reports in Power BI.
Expert level knowledge of SQL and demonstrated ability to apply SQL creatively to a wide variety of business requirements.
Ability and interest in data analysis.
Effective problem solving and analytical skill.
Ability to manage multiple projects and report simultaneously across different stakeholders.
Client-focused professional approach
Openness to different and new ways of doing things.
Ability to work in a team environment while also demonstrating initiative and independence.
Demonstrate punctuality and dependability to support overall team success in a fast-paced environment.
Candidates must be eligible to work in the country of interest at the time any offer of employment is made and are responsible for obtaining any required work permits, visas, or other authorizations necessary for employment.
Prior to their start date, candidates will also need to provide proof of their eligibility to work in the country of interest.

Nice To Haves

An advanced degree in a related area, an asset.
Relevant certifications are a plus.
Experience in tool migration of BI reports would be an asset.
Based on equal qualifications, preference will be given to bilingual candidates.

Responsibilities

Analyze business objectives and develop data solutions to meet customer needs.
Design & Develop data visualization solutions derived from multiple data sources using right tools to enable insight and decision-making at various levels of the organization.
Design and develop semantic layers / data marts which are conducive to reporting needs of different line of businesses in Air Canada.
Develop data visualizations for key business metrics on an ongoing basis.
Define and document data dependencies and data flow diagrams of the solution developed, e.g. between source and systems consuming the data, as well as the logical processes and interfaces with other systems.
Initiate data analysis and identify strategic opportunities that creates a positive impact on business.
Provide technical oversight and recommendations on data infrastructure (on-premises and Cloud) and BI tool configuration to project teams.
Work closely with key stakeholders to ensure all business requirements are developed and clearly communicated.
Determine root cause for data integrity gaps and provide appropriate data resolution and process remedy solutions.
Develop innovative and effective approaches to solve business problems through data analytics approaches and communicate results and methodologies
Design and administer data collection tools, clean, merge and manage existing data sets as well as establish and maintain data quality procedures to ensure accuracy and timeliness of data.
Develop code that is reusable, easily testable, and highly efficient.
Analyze and resolve technical and applications issues.
Play an active role in projects-related activities. Work with the team and cross-team members to design, develop, debug and release and deploy production quality products.
Assist with preparation and coordination of test plans (if needed).
Actively contribute to the continuous enhancement of the team by bringing new ideas and solutions on how to ameliorate the applications, the processes, the delivery, the communication, etc.
Provide technical and operational inputs to Business Governance and Operational Management Committees where necessary.