About MHI Canada Aerospace, Inc.
MHI Canada Aerospace, Inc. (MHICA), a group company of Mitsubishi Heavy Industries, is a Tier 1 manufacturer of major aircraft structures and assemblies, based in Mississauga, Ontario. Over the past decade, MHICA has built more than aircraft components, it has built a recognized worldwide reputation for capacity, precision, on-time delivery, and excellence. MHICA has two state-of-the-art facilities combined to 476,000 sq. ft. This comprises of Manufacturing & Assembly, Engineering, Quality and Supply Chain, where highly-skilled employees are working on Bombardier's sector-leading Global 5000/6000 and Challenger 350 business aircraft. MHICA's technicians build and join wing assemblies and fuselage sections, as well as perform systems and flight control assembly installations and testing.
Reporting to the Director, the Senior SQL Server & Data/AI Engineer will own our SQL Server data layer end-to-end and help lay the foundations for our AI platform. Roughly 70% of your time will be on SQL Server, ETL, and data modelling: stabilizing, tuning, and improving what we already run in production. The rest will be spent designing data structures and pipelines for AI (vector store, RAG-style data access) and, if it makes sense, basic semantic models/SSAS.
Infrastructure/IT will manage servers, OS, and patching. You own schema, code, performance, ETL, and data models. You’ll be expected to make architecture decisions, challenge assumptions, and push for robust, maintainable solutions.
SQL Server Ownership (Data Layer)
Own several production SQL Server instances and ~10 databases from a data perspective (schemas, code, performance, reliability, security at the DB level, backups/restore strategies).
Tables, views, indexes, constraints, and other DB objects for new features and integrations.
SQL Development & Optimization
Refactor and optimize stored procedures, functions, and queries to reduce runtime, resource usage, and complexity.
Naming conventions, error handling, transaction handling, deployment/version control for DB objects.
AI & Data Platform Enablement (Cloud-Friendly)
Prepare and structure enterprise data for AI use cases (RAG, copilots, internal assistants, automation).
Design and implement a vector-aware data store using pragmatic options (e.g., Azure SQL, managed vector stores, or similar), including:
Collaboration & (Light) Analytics Enablement
Skills and Qualifications
Designing, owning, and troubleshooting production ETL jobs (SSIS or similar tools, or custom script-based ETL).
RAG-style architectures, embeddings, prompt design, chatbots, or internal copilots.
Background in manufacturing, aerospace, or industrial environments with data flowing between ERP, PLM, MES, and quality systems.
Please note – the Company will conduct a criminal background check upon hire.
We thank all applicants in advance for their interest; however, only those candidates selected for an interview will be contacted.
MHI Canada Aerospace is an equal opportunity employer and encourages women, aboriginal people, persons with disabilities and members of visible minorities to apply. MHICA is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). MHICA will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.