Senior Business Analyst - Production Planning | Full-Time Temp (12 Months) Opportunity

De Havilland Aircraft of Canada Limited (DHC) is a storied name in the aerospace industry, recognized worldwide for its pioneering contributions to aviation and its unwavering commitment to quality, innovation, and reliability. Headquartered in Calgary, AB, DHC currently has approximately 1,400 employees across British Columbia, Alberta and Ontario, as well as in markets and distribution hubs world-wide.

Established in 1928, De Havilland Canada has a rich history marked by the development of some of the most iconic and versatile aircraft ever built. These aircraft have served a variety of roles—from bush flying to commercial aviation—and are celebrated for their rugged durability, operational versatility, and excellence in performance.

Over the decades, De Havilland Canada has evolved to meet the changing needs of the aviation industry. Today, we are more than just an aircraft manufacturer; we are a comprehensive aerospace company with capabilities that span design, production, maintenance, repair, and overhaul (MRO) services. Our operations are supported by a team of skilled engineers, technicians, and industry professionals who are dedicated to upholding the highest standards of craftsmanship and innovation.

Profile

As a Senior Business Analyst, you will be a leader amongst our Analyst teams and develop the framework and data architecture to support their activities as well as to enable advanced reporting and modelling techniques to improve the overall capabilities and efficiency of Business Intelligence teams. You will also work in support of new and challenging projects to provide information solutions and guidance that will enable their efficient and timely success.

The scope of work includes developing database SQL Views, data warehousing, developing complex models using a combination of database management techniques and Microsoft Excel, developing processes, tools, and systems to enable the efficient and scalable management of BI reporting by other Analysts and the activities of the Master Schedulers, and offering tutelage and guidance on ERP/Database issues.

A successful Senior Business Analyst has strong leadership skills, and are motivated self-learners with a mind for identifying and actioning opportunities for improvement. They care about excellence in their job and are passionate about team and company success. They have an excellent analytical mind and have the social and communication skills to confidently lead meetings with multidisciplinary teams.

Key Responsibilities

• Develop expertise in Front End use of ERP software and the ERP database structure.
• Design, develop, maintain, and improve scalable data architecture of the company; particularly for use by Analysts to develop BI dashboards, reports, and presentations.
• Advanced data mining and data uploading from/to the ERP database.
• Develop complex models and tools (PowerQuery, Excel, SAP Crystal Reports, SQL Views, etc.) that extract, visualize, and/or load information to/from databases to improve efficiency and efficacy of other employees and groups.
• Support and provide guidance and recommendations in the evaluation and implementation of programs, projects, and processes that relate to ERP usage.
• Support MPC Manager, Master Production Schedulers, and others by providing data models and visualizations for presentations.
• Stand-in on behalf of the MPC Manager for projects, presentations, and delegated decision making.
  
  
  

Qualifications & Skills

• Self-teaching and strong desire to learn.
• Motivated to improve methods and practices for managing and communicating company data with consideration for big-picture use and information relationships.
• Strong SQL coding knowledge and understanding of ERP systems (Visual ERP preferred) and relational databases.
• Experience using BI reporting tools (SAP Crystal Reports, Microsoft PowerBI, etc.).
• B.A./B.S. in a related field (data science, engineering, data analysis, statistics, etc) is highly desirable.
• 7+ years of related experience in data analysis, database administration, ERP management, or similar in a manufacturing environment.
• Strong Microsoft Office skills and advanced Microsoft Excel skills (with knowledge of Power Query and database interfacing)
• Excellent analytical skills with a proven ability to create integrated business models that facilitate decision making and/or business metric & KPI visualization.
  
  
  

At De Havilland Aircraft of Canada (DHC), we are committed to protecting our people, customers, shareholders and the public through Health & Safety Excellence. As such, it is expected that all employees maintain strict adherence to Health & Safety Policies and to perform key physical tasks of the position described in the job description and interview process. This may include but is not limited to the ability to work in a variety of environmental conditions including temperature extremes, confined spaces, working at heights and with or around chemicals. Employees are expected to adhere to the use of personal protective equipment (PPE) when at work which must include but is not limited to the ability to maintain a positive fit test when mask use is required.

At De Havilland Canada, we aim to be inclusive and diverse and provide equal opportunity for employment. All qualified applicants, regardless of gender, age, race, religion, sexual orientation, and disability, are encouraged to apply. De Havilland will accommodate the needs of applicants with disabilities throughout all stages of the selection process. If you need accommodation during the recruitment process, please advise your Talent Acquisition representative. Information relating to the need for accommodation and accommodation measures will be addressed confidentially.

Any offer of employment is conditional on the completion of positive and satisfactory background checks, which may include, proof that you are legally entitled to work in Canada, professional references, verification of employment history, verification of educational background and criminal background checks.