Senior SQL Server & Data / AI Engineer

Senior SQL Server & Data / AI Engineer at MHI Canada Aerospace, Inc.

Job Title : Senior SQL Server & Data / AI Engineer. Department : IT / ERP. Reports to : Director. Job Category : Yearly.

Job Description

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.

Scope of Position

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.

Responsibilities

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).
• Monitor and tune performance :
• Index and statistics strategy, query plans, blocking / deadlocks, resource usage.
• Maintain and troubleshoot :
• Replication, SQL Agent jobs, and other DB‑level automation.
• Design and implement :
• Tables, views, indexes, constraints, and other DB objects for new features and integrations.
• Work with infrastructure / IT on :
• Capacity, patching windows, and DR, while ensuring the data layer supports those plans.

ETL & Data Workflows

SQL Development & Optimization

AI & Data Platform Enablement (Cloud‑Friendly)

Collaboration & (Light) Analytics Enablement

Work Conditions

Skills And Qualifications

Nice to Have

Education

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.

#J-18808-Ljbffr