Job Description
Description
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 Senior Developer, Data & Analytics – 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 Senior, Data & Analytics – BI will be reporting to the Manager, Data & Analytics.
Responsibilities:
- Analyze business objectives and develop data solutions to meet customer needs.
- Manage and administer the Power BI platform, including user access, security settings, gateways and data source connections.
- Ensure the overall health of the Power BI platform, ensuring users have the tools and resources to create insightful reports and dashboards.
- 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.
Qualifications
- Bachelor’s degree in a related field (Information Technology, Engineering, Computer Science). An advanced degree in a related area, an asset.
- Minimum of 5 years of experience in a large company querying and manipulating datasets.
- Minimum of 3 years of hands-on experience in Power BI administration, report development, and data modeling. (Relevant certifications are a plus).
- 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.
- Experience in tool migration of BI reports would be an asset.
- 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.
Conditions of Employment:
Linguistic Requirements
Based on equal qualifications, preference will be given to bilingual candidates.
Diversity and Inclusion
Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees’ unique contributions to our company’s success.
As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.
Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.