Data Solutions Analyst

Being part of Air Canada is being part of a Canadian icon, Air Canada recently elected best airline in North America. Take off your career by joining our innovative and diverse team at the forefront of passenger air transport.

The role of the Knowledge – Operations team is to explore operational data through a range of enterprise data exploitation solutions. The Data Management team is the primary resource for all operational data needs. It ensures the management of reliable data assets and develops key performance indicators, data models, and standardized reporting and data management solutions that support business units across the organization.

The person occupying the position of Data Solutions Analyst is responsible for designing, implementing, and maintaining enterprise data solutions by collecting, integrating, and modeling operational data and customer data intended for large-scale use within the organization. This position consists of developing scalable data pipelines and organized data models that support reporting, analysis, advanced visualizations as well as new AI and machine learning use cases across all directions of the organization.

Responsibilities:

Design and Development of Data Solutions

• Design, implement, and maintain enterprise data management solutions for operational data and customer data.
• Develop scalable data pipelines and organized data models intended for use by the organization.
• Implement initiatives related to data transformation, logic, and queries to provide reliable indicators.
• Automate data-related processes and reporting to improve efficiency and scalability.
• Design provisional or manual data management solutions when automation is not yet possible.

Data Acquisition and Integration

• Acquire and integrate data from key operational systems and data sets.
• Develop manual data extraction methods when automated access is not possible.
• Support the ingestion and insertion of data into regulated internal data environments.
• Collaborate with IT partners to harmonize integration approaches with enterprise platforms and standards.

Data Quality and Governance

• Evaluate data quality and its suitability for the intended use in business and operational contexts.
• Identify, analyze, and resolve data-related anomalies and data integrity issues.
• Implement data validation rules, controls, and monitoring mechanisms.
• Propose design and process improvements to increase data reliability.
• Ensure compliance with enterprise data governance frameworks and standards.

Facilitation of Data Use

• Facilitate reporting, analysis, and advanced visualization through well-designed data assets.
• Provide reliable modeled data for dashboards, performance indicators, scorecards, and reports.
• Provide data and analytics support for business cases and improvement initiatives.
• Develop data solutions that improve visibility into operational performance and trends.

Business Partnerships and Collaboration

• Collaborate with business stakeholders to translate data needs into technical solutions.
• Collaborate with Business Intelligence, Analytics, and IT teams to develop end-to-end data solutions.
• Present data results, perspectives, and solutions to stakeholders as needed.
• Support enterprise and cross-functional initiatives by providing reliable data.

Knowledge Sharing and Continuous Improvement

• Transmit technical knowledge and best practices in data management to team members.
• Contribute to the continuous improvement of processes, tools, and data-related working methods.
• Support testing on new data sources, new pipelines, and modifications made to existing structures.
• Promote sustainable, well-documented, and supportable data solutions.

Qualifications

• University or college degree in computer science or data management, or in a related discipline.
• At least three years of relevant professional experience.
• Experience working with enterprise data platforms, notably in the field of data integration, management, and storage solutions.
• Experience with data processing and storage platforms such as Microsoft Fabric, Azure Data Factory, Talend, and Snowflake.
• Experience with statistical or data analysis tools like SAS or other data mining and analytical programming tools.
• Mastery of data and query languages, notably SQL/T-SQL, Python, DAX, and other database or scripting languages.
• Strong talent for analysis, logic, and problem solving, and great attention to detail.
• Ability to design and implement data solutions in a dynamic, constantly changing environment.
• Strong oral and written communication skills; ability to explain technical concepts to a non-technical audience.
• Initiative and ability to manage multiple priorities with minimum supervision.
• Ability to understand the operational and financial impacts of data-driven decisions and support cost-benefit analysis.

Employment Conditions:

Candidates must be eligible to work in the country concerned at the time a job offer is presented and are responsible for obtaining work permits, visas, or other necessary authorizations. Proof of eligibility must be provided before the start date.

Language Requirements

All things being equal, preference will be given to bilingual candidates.

Diversity and Inclusion

Air Canada is firmly committed to diversity and inclusion and aims to create a healthy, accessible, and rewarding workplace that highlights the unique contribution of our employees to the success of our company.

As an equal opportunity employer, we encourage the most diverse applications in order to provide us with a varied workforce representative of our customers and the communities where we live and offer our services.

Air Canada thanks all candidates for their interest, but only those selected for an interview will be contacted.