Senior Data Modeling

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.

Position Summary:
We are seeking a highly skilled and detail-oriented
Senior Data Modeling & Analytics Specialist
to join our MPC Business Analytics Team. The successful candidate will play a key role in driving data-driven decision-making within the manufacturing environment. This role requires a blend of strong technical expertise, analytical capability, and business process understanding to support data initiatives and enable actionable insights across the organization.

The ideal candidate will have a deep understanding of data engineering, data modeling, and business intelligence tools, along with the ability to collaborate effectively with cross-functional teams to translate operational processes into analytical logic.

Key Responsibilities:
Data Analysis & Modeling:

• Design, build, and maintain data models that support manufacturing and operational analytics.
• Develop, test, and optimize dataflows, pipelines, and data models to support reporting and analytics.
• Integrate data from multiple sources, including IFS Cloud and Microsoft Fabric.
• Automate and streamline recurring processes using Python, APIs, and scripting tools.
• Translate complex business processes into logical data flows and analytical structures.
• Ensure data accuracy and consistency across systems.

Data Visualization & Reporting:

• Develop advanced Power BI dashboards and reports to visualize insights for leadership and operational teams.
• Advanced DAX skills.
• Optimize report performance and usability for end-users.

Technical Development:

• Utilize advanced SQL, Python or R to extract, transform, and analyze data from multiple sources.
• Implement automation scripts and workflows to streamline recurring data processes.
• Work with Microsoft Fabric to design scalable analytical environments.

Collaboration & Stakeholder Engagement:

• Partner with business and functional teams to validate data logic and align metrics between operational and analytical layers.
• Document data definitions, logic, and reporting processes in a structured and accessible manner.

Data Governance & Quality:

• Ensure adherence to data governance standards and maintain strong discipline.
• Support data quality checks and process improvements.

Required Skills & Qualifications
:

Education:

• Bachelor's degree in data science, Computer Science, Engineering, Statistics, or a related field.

Core Technical Skills:

• Advanced SQL – strong query development and optimization experience.
• Python – data manipulation, automation, and integration scripting.
• Data Modeling – design and maintain efficient data structures for analytics.
• Power BI (Advanced) – strong DAX, data modeling, and visualization skills.
• Microsoft Fabric – experience with dataflows, pipelines, and notebooks.
• Data Integration – building and maintaining ETL/ELT processes.
• Documentation Discipline – clear, consistent technical documentation.
• Proven ability to translate business processes into scalable data logic.

Good-to-Have Skills:

• Experience with IFS Cloud (ERP systems).
• Knowledge of API integration and automation scripting.

Experience:

• Minimum 8+ years of experience in Data Engineering, Business Analytics, or similar technical analytics roles, preferably in a manufacturing or operations environment.

Work Environment:

• Full-time position with a competitive salary and benefits package.
• Opportunities for professional development and career growth.
• Collaborative environment within the MPC Business Analytics Team, focused on innovation, efficiency, and data-driven excellence.

Why work at De Havilland?
De Havilland Canada is a Canadian-owned and operated aircraft manufacturer dedicated to providing rewarding opportunities in a diverse and welcoming workplace.

• Work with a team that makes a true difference in the world- making it possible for people to travel around the globe efficiently, comfortably and safely.
• We've manufactured over 5,600 aircraft including the most advanced turboprop in the air today. Our experience and expertise in constructing the highest performing aircraft in the industry is second to none.
• Our state-of-the-art manufacturing facilities are dynamic workplaces led by teams that support and encourage all employees.
• With a passionate team of innovators and a global network of support, De Havilland Canada proudly carries on it's tradition as a leader in aerospace.

In addition to plenty of opportunities for career growth in a stimulating work environment, De Havilland Canada offers:

• Competitive wages
• Paid vacation
• Extended health benefits (medical, dental, vision, paramedical)
• Life insurance
• RRSP/DPSP Plan
• Employee and family assistance program

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.