Senior SQL Server & Data/AI Engineer
About the role
Job Title
Senior SQL Server & Data/AI Engineer
Department
IT/ERP
Reports to
Director
Job Category
Yearly
Job Description 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.
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
- Own and improve existing ETL workflows (SSIS packages and/or custom ETL processes).
- Stabilize ETL:
- Add proper logging, monitoring/alerting, and restart/recovery patterns.
- Document and rationalize data flows:
- Between SQL databases, ETL, upstream applications, and reporting/analytics.
- Improve data quality:
- Implement validation checks, reconcile source vs target, and create repeatable fixes for recurring data issues.
SQL Development & Optimization
- Refactor and optimize stored procedures, functions, and queries to reduce runtime, resource usage, and complexity.
- Debug and resolve production data issues:
- Do real root-cause analysis (schema, ETL logic, upstream systems) rather than just patch symptoms.
- Establish and enforce SQL development standards:
- 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:
- Schemas for documents, embeddings, and metadata.
- Ingestion and refresh pipelines that keep AI-ready data up to date and governed.
- Work with AI developers and stakeholders to define:
- What data AI can access, under which rules, and via which APIs/queries.
- Help evaluate:
- When to use Azure or other cloud services (e.g., Azure OpenAI, managed search/vector services) and how they integrate with on-prem SQL.
Collaboration & (Light) Analytics Enablement
- Partner with application developers, BI/reporting, and business stakeholders to ensure data structures match actual usage.
- Translate business questions into reusable models/views/semantic layers where possible.
- If relevant and time allows, explore:
- Basic SSAS/semantic models or equivalent for stable reporting and as a source for AI tools.
Work Conditions
- Overtime hours with advanced notice may be required to meet project deadlines.
- Hybrid opportunities available – incumbent must commute to work.
Skills And Qualifications
- 5+ years hands-on experience as a SQL Server Developer / Database Engineer / Data Engineer with SQL Server as your main platform.
- Strong T-SQL skills:
- Complex stored procedures, functions, and views.
- Solid query tuning using execution plans, index strategies, and statistics.
- Proven ETL / data integration experience:
- Designing, owning, and troubleshooting production ETL jobs (SSIS or similar tools, or custom script-based ETL).
- Solid grasp of:
- Relational data modelling, normalization vs denormalization, and the impact of design on performance and maintainability.
- Comfortable taking over legacy SQL and ETL:
- Reading messy code, simplifying it, and documenting what’s actually happening.
- Used to owning outcomes:
- You can prioritize, communicate trade-offs, and defend good technical decisions to both technical and non-technical stakeholders.
- Clear written and verbal communication.
Nice to Have
- Experience with LLM/AI systems:
- RAG-style architectures, embeddings, prompt design, chatbots, or internal copilots.
- Hands-on exposure to vector databases / vector stores or search platforms with vector capabilities (cloud or self-hosted).
- Experience with:
- SSIS, SSRS, SSAS, or similar ETL/reporting/analytics tools.
- Power BI modelling (DAX is a plus but not mandatory).
- Programming in .NET/C# or Python for data/ETL/AI integration and automation.
- Background in manufacturing, aerospace, or industrial environments with data flowing between ERP, PLM, MES, and quality systems.
Education
- A college diploma or university degree in computer science or software engineering.
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.
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's facilities include a 270,000 sq ft state-of-the-art manufacture and assembly facility and a 70,000 sq ft supply chain and logistics centre, where more than 700 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 centre sections, as well as perform systems and flight control assembly installations and testing.
Building complex aircraft structures at the highest levels requires a full and well-managed inventory. MHICA's logistics centre ensures the stable and on-time delivery of materials, sub-assemblies and tooling needed for continuous and fluid assembly. Our Supply Chain and Logistics Centre sources materials and manages more than 30 supply chain partners from across North America. MHCIA conducts quality control and inspections of incoming components and materials, assembles work kits and warehouses the inventory that keeps our assembly facility running smoothly.
MHICA's dedicated people, extensive experience, demonstrated efficiency and world-class facilities contribute to Bombardier Aerospace's success as a world-class aerospace leader, enabling them to be atop of the aerospace world in the business and commercial aircraft design and production.
MHI Canada Aerospace, Inc looks to the future and the development of new partnerships with leading aerospace manufacturers. For more information about MHICA's skilled workforce, logistics centre, and world-class assembly facilities, please contact us at 905-612-8131
Senior SQL Server & Data/AI Engineer
About the role
Job Title
Senior SQL Server & Data/AI Engineer
Department
IT/ERP
Reports to
Director
Job Category
Yearly
Job Description 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.
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
- Own and improve existing ETL workflows (SSIS packages and/or custom ETL processes).
- Stabilize ETL:
- Add proper logging, monitoring/alerting, and restart/recovery patterns.
- Document and rationalize data flows:
- Between SQL databases, ETL, upstream applications, and reporting/analytics.
- Improve data quality:
- Implement validation checks, reconcile source vs target, and create repeatable fixes for recurring data issues.
SQL Development & Optimization
- Refactor and optimize stored procedures, functions, and queries to reduce runtime, resource usage, and complexity.
- Debug and resolve production data issues:
- Do real root-cause analysis (schema, ETL logic, upstream systems) rather than just patch symptoms.
- Establish and enforce SQL development standards:
- 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:
- Schemas for documents, embeddings, and metadata.
- Ingestion and refresh pipelines that keep AI-ready data up to date and governed.
- Work with AI developers and stakeholders to define:
- What data AI can access, under which rules, and via which APIs/queries.
- Help evaluate:
- When to use Azure or other cloud services (e.g., Azure OpenAI, managed search/vector services) and how they integrate with on-prem SQL.
Collaboration & (Light) Analytics Enablement
- Partner with application developers, BI/reporting, and business stakeholders to ensure data structures match actual usage.
- Translate business questions into reusable models/views/semantic layers where possible.
- If relevant and time allows, explore:
- Basic SSAS/semantic models or equivalent for stable reporting and as a source for AI tools.
Work Conditions
- Overtime hours with advanced notice may be required to meet project deadlines.
- Hybrid opportunities available – incumbent must commute to work.
Skills And Qualifications
- 5+ years hands-on experience as a SQL Server Developer / Database Engineer / Data Engineer with SQL Server as your main platform.
- Strong T-SQL skills:
- Complex stored procedures, functions, and views.
- Solid query tuning using execution plans, index strategies, and statistics.
- Proven ETL / data integration experience:
- Designing, owning, and troubleshooting production ETL jobs (SSIS or similar tools, or custom script-based ETL).
- Solid grasp of:
- Relational data modelling, normalization vs denormalization, and the impact of design on performance and maintainability.
- Comfortable taking over legacy SQL and ETL:
- Reading messy code, simplifying it, and documenting what’s actually happening.
- Used to owning outcomes:
- You can prioritize, communicate trade-offs, and defend good technical decisions to both technical and non-technical stakeholders.
- Clear written and verbal communication.
Nice to Have
- Experience with LLM/AI systems:
- RAG-style architectures, embeddings, prompt design, chatbots, or internal copilots.
- Hands-on exposure to vector databases / vector stores or search platforms with vector capabilities (cloud or self-hosted).
- Experience with:
- SSIS, SSRS, SSAS, or similar ETL/reporting/analytics tools.
- Power BI modelling (DAX is a plus but not mandatory).
- Programming in .NET/C# or Python for data/ETL/AI integration and automation.
- Background in manufacturing, aerospace, or industrial environments with data flowing between ERP, PLM, MES, and quality systems.
Education
- A college diploma or university degree in computer science or software engineering.
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.
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's facilities include a 270,000 sq ft state-of-the-art manufacture and assembly facility and a 70,000 sq ft supply chain and logistics centre, where more than 700 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 centre sections, as well as perform systems and flight control assembly installations and testing.
Building complex aircraft structures at the highest levels requires a full and well-managed inventory. MHICA's logistics centre ensures the stable and on-time delivery of materials, sub-assemblies and tooling needed for continuous and fluid assembly. Our Supply Chain and Logistics Centre sources materials and manages more than 30 supply chain partners from across North America. MHCIA conducts quality control and inspections of incoming components and materials, assembles work kits and warehouses the inventory that keeps our assembly facility running smoothly.
MHICA's dedicated people, extensive experience, demonstrated efficiency and world-class facilities contribute to Bombardier Aerospace's success as a world-class aerospace leader, enabling them to be atop of the aerospace world in the business and commercial aircraft design and production.
MHI Canada Aerospace, Inc looks to the future and the development of new partnerships with leading aerospace manufacturers. For more information about MHICA's skilled workforce, logistics centre, and world-class assembly facilities, please contact us at 905-612-8131