Posted Friday, August 16, 2024 at 6:00 AM | Expires Saturday, September 7, 2024 at 5:59 AM

De Havilland Aircraft of Canada Ltd. (‘DHC’) is a proudly Canadian aerospace company currently transitioning its corporate headquarters to Calgary, AB. DHC is undertaking a consolidation of its underlying subsidiary companies under a single brand currently offering engineering, aftermarket, new aircraft manufacturing, modifications, parts manufacturing, and flight training. DHC currently has approximately 1,200 employees based in BC, AB and ON as well as in markets and distribution hubs worldwide. Our strong entrepreneurial spirit, together with a culture of empowerment, quality and innovation create opportunities to grow and succeed in an organization with a proud heritage and bright future.

Position 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 is a motivated self-learner 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:

• 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.
• Experience using BI reporting tools (SAP Crystal Reports, Microsoft PowerBI, etc.).
• 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.

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 an expectation 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.