Jobs in Canada

Email me new jobs Save this search

Added 5 months ago
Senior AI Engineer
ShyftLabs
Toronto, Ontario
Full-time
ShyftLabs is looking for a Senior AI Engineer to sit at the intersection of AI/ML engineering and backend platform development. This isn't a research role, it's a hands-on engineering…
Added 1 month ago
Specialist Engineer – Feeder Analysis
AtkinsRéalis
Mississauga, Ontario
Full-time
AtkinsRéalis is currently looking for a Specialist Engineer for Feeder analysis to join our Engineering Excellence team in Mississauga. It will require a technical leadership role in the…
Added 5 months ago
Artificial Intelligence Engineer
Precision AI
Calgary, Alberta
Full-time
The Artificial Intelligence Engineer at Precision AI will contribute to the design, development, and deployment of AI-driven solutions. This role focuses on building, training, and…
Added 5 months ago
Maintenance Manager
Jumpstart Refugee Talent - Partner
New Westminster, British Columbia
Full-time
Further support efforts to ensure resident satisfaction and service delivery through prompt service, ongoing communication and follow up.
Added 5 months ago
Maintenance Technician (5th Class Power Engineer)
Jumpstart Refugee Talent - Partner
Edmonton, Alberta
Full-time
…to ensure resident satisfaction and service delivery through prompt service, ongoing communication and follow…
Added 5 months ago
Resiliency Architect
Intact FC
Toronto, Ontario · Montreal, Quebec
Full-time
Standardize blue/green deployment architecture and engineer safe traffic shifting, health gates, progressive cutovers, rollback, and zero-downtime data migrations.
Added 3 months ago
Lead AI Engineer
Altus Group
Toronto, Ontario
Full-time
Reporting to the Principal Architect, we are hiring a Lead AI Engineer to help shape and build the next generation of AI capabilities across the Altus Group platform ecosystem. As our new…
Added 23 days ago
Senior Customer Engineer - Calgary
Cloudflare
Calgary, AB
The Customer Engineer (CE) is the core driver of our technical go-to-market strategy: a trusted technical advisor and primary architect of the customer journey. You will bridge the gap…
Added 2 months ago
Specialist Electrical Engineer
AtkinsRéalis
Mississauga, Ontario
Full-time
The Specialist Electrical Engineer provides advanced technical expertise and leadership for the design, modification, maintenance, and life‑extension of electrical systems supporting CANDU…
Added 6 months ago
Electrical Engineer
AtkinsRéalis
Mississauga, Ontario
Full-time
Provide prompt response and engineering resolutions on any critical engineering related matters.
Added 3 months ago
Lead Software Engineer, AI & Emerging Tech
CPP Investments | Investissements RPC
Toronto, Ontario
Full-time
As a Lead Engineer for AI & Emerging Tech, you will drive the design, development, and deployment of next-generation tech and AI-powered solutions that unlock business value across the…
Added 2 months ago
Senior Electrical Engineer
AtkinsRéalis
Mississauga, Ontario
Full-time
Provide prompt response and engineering resolutions on any critical engineering related matters.
Added 3 months ago
Applied AI Engineer
Nexxa.AI
Remote, Canada
Full-time · Remote
Integrate and optimize AI/ML pipelines, including data preprocessing, prompt engineering, model selection, and evaluation.
Added 1 month ago
Senior SQL Server & Data/AI Engineer
Mitsubishi Heavy Industries, Ltd.
Mississauga, ON
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…
Added 4 months ago
Production Services Technician (PST)
Sony Pictures Imageworks
Vancouver, British Columbia
Issue Management: Submit prompt and detailed information through support channels, clearly communicating issues and potential solutions to Color Scientists, Resources, Production, Systems,…
Added 1 month ago
Solutions Engineer
Ask-AI
Toronto, ON
Full-time
We’re hiring a Solutions Engineer to own the technical and operational success of our customers from pre-sale through post-sale. This is a full-lifecycle role: you’ll run POVs, lead…

No more jobs.

Mitsubishi Heavy Industries, Ltd.

Senior SQL Server & Data/AI Engineer

Mississauga, ON, L4V 1S1, Canada

Posting language: English
Posted: Aug 20, 2026

Apply About employer

Applications open in a new tab.

Original job description

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.

Apply About employer

More about this job

Responsibilities

The Senior SQL Server & Data/AI Engineer will own the SQL Server data layer and help establish the foundations for the AI platform. Responsibilities include monitoring and tuning performance, maintaining ETL workflows, and collaborating with developers and stakeholders.

Requirements

Candidates should have 5+ years of experience with SQL Server, strong T-SQL skills, and proven ETL/data integration experience. A college diploma or university degree in computer science or software engineering is required.

Skills

SQL Server
T-SQL
ETL
Data Integration
Data Modelling
Performance Tuning
Stored Procedures
Functions
Data Quality
Debugging
Collaboration
AI
Cloud Services
SSIS
Power BI
Python

Visa sponsorship

Not detected in the job text

Hiring contact

Director

Keywords

SQL Server
T-SQL
ETL
Data Integration
Data Modelling
Performance Tuning
Stored Procedures
Functions
Data Quality
Debugging
Collaboration
AI
Cloud Services
SSIS
Power BI
Python
Manufacturing
Aerospace
Automation
Data Pipelines
Data Structures
Vector Stores
Semantic Models
Reporting
Analytics
Data Governance
Capacity Planning
Disaster Recovery
Root-Cause Analysis
Documentation

Report this job