Data Solution Architect

Bombardier; Dorval; On-site; CAD 120,000 - 180,000; Full time

Benefits offered by this job

Insurance plans

Competitive base salary

Retirement savings plan

Employee Assistance Program

Tele Health Program

Job summary

Bombardier's Data, AI & Automation team is seeking a Data Solution Architect to define and govern enterprise data and analytics solutions. You will provide architecture leadership across data integration, analytics, AI/ML, cloud platforms, and BI to align with business objectives and security policies.

You will design cloud data solutions (OLAP/OLTP, API, SQL/NoSQL, Lakehouse) and collaborate with data engineers, BI and ML/AI developers to deliver scalable data platforms.

Qualifications

• Bachelor’s degree in computer science, engineering, information technology or related technical fields.
• 10+ years of data modeling, data pipeline development (ETL/ELT), data warehouse and lakehouse administration.
• 5 years’ experience in delivering complex solution in a Databricks Lakehouse environment.
• Expertise in cloud-based data platform capable to support big data analytics use cases.
• Knowledge of security principles for cloud-hosted data and analytics solutions.
• Familiar with data integration architecture, microservice architecture, and API-based solutions.
• User is fluent in English and French for business communication.

Responsibilities

• Architect cloud data solutions (OLAP, OLTP, API, SQL, NoSQL, Lakehouse, BI) aligned with architecture standards and governance.
• Design data models and metadata usage requirements; manage reference/master data integration.
• Define non-functional aspects (observability, availability, backup, DR, security).
• Collaborate with Data Engineers, BI and ML/AI teams to translate technical specs into data & analytics solutions.
• Ensure data platform usage rules and monitor ingestions, processing and access management.
• Identify and address data quality issues and root causes.

Skills

Data modeling

ETL/ELT

Data pipelines

Data warehouse

Lakehouse

Databricks

SQL

NoSQL

Cloud platforms

API integration

Security concepts

English/French

Education

Bachelor’s degree in CS/Engineering/IT

Tools

Azure

Databricks Lakehouse

Job description

When applicable, Bombardier promotes flexible and hybrid work policies.

Why join us?

At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and defining excellence, together.

Working at Bombardier means operating at the highest level. Every day, you are part of a team that delivers superior experiences and products, pushing the boundaries of what’s possible in our industry and beyond. By prioritizing employee growth and development, we empower everyone to reach their full potential on their own terms, because the best work happens when you are free to be yourself and share your unique expertise.

Bombardier’s Benefits Program

• Insurance plans (Dental, medical, life insurance, disability, and more)
• Competitive base salary
• Retirement savings plan
• Employee Assistance Program
• Tele Health Program

Overview

Within the Data, AI & Automation team of Bombardier, reporting to the Manager of Data Integration & Business Intelligence CoE, the Data Solution Architect is responsible for defining, governing, and designing enterprise data and analytics solutions that align with business objectives, enterprise architecture standards, security requirements, and data governance policies. The role provides architecture leadership across initiatives involving data integration, analytics, AI/ML, cloud platforms, and business intelligence.

What are your contributions to the team?

• Architect cloud data solutions (OLAP, OLTP, API, SQL, NoSQL, Lakehouse, BI) that complies with approved architecture framework, standards, and principles.
• Design and document functional aspect of analytics solutions (data model, metadata usage or creation requirement, reference/master data integration).
• Design and document non-functional aspects of analytics solutions (observability, availability, backup, archival, disaster recovery, security compliance).
• Assist the support team to troubleshoot or optimize solution performance after project delivery.
• Work with Technical Delivery Leads, Data Engineers, BI and ML/AI developers to translate technical specifications into data & analytics solutions (data ingestion, integrations, transformations and serving/sharing).
• Align your technical solutions to the data governance policies and data management strategy.
• Investigate data quality issues impacting the business and propose solutions to address root cause.
• Support definition of the data platform usage rules and monitor compliance (ingesting, processing and access management)
• Collaborate with multiple departments, stakeholders, partners, and external vendors.

How to thrive in this role?

• You hold a bachelor's degree in computer science, engineering, information technology or related technical fields.
• You have at least 10 years of data modeling, data pipeline development (ETL/ELT), data warehouse and lakehouse administration.
• You have 5 years’ experience in delivering complex solution in a Databricks Lakehouse environment.
• You have expertise in cloud-based data platform capable to support big data analytics use cases
• You have a good understanding of security principles for cloud-hosted data and analytics solutions.
• You are familiar with data integration architecture, microservice architecture, and API-based solutions.
• You are keeping up to date with columnar and NoSQL databases, data visualization, and processing of unstructured data.
• You have experience with data file format for large scale analytics (CSV, JSON, Parquet, ORC, AVRO, …).
• You have knowledge of XML Schema Definition (XSD), JSON and XML Metadata Interchange (XMI).
• Azure Solution Architect, Databricks Data Engineer/Architect, or equivalent certifications are considered assets
• You can resolve complex problems and provide innovative solutions.
• You are flexible and can adapt towards changing organizational needs.
• Proven ability to influence stakeholders and drive architectural decisions across multiple teams and business domains.
• You have excellent communication and interpersonal skills.
• You have business level proficiency of English and French.

Please note: You don’t need all the skills, knowledge, and experience listed to apply for this position. We’re not looking for the perfect candidate, we’re looking for great talent and passionate individuals.

Bombardier is an equal opportunity employer and encourages persons of any race, religion, ethnicity, gender identity, sexual orientation, age, immigration status, disability or other applicable legally protected characteristics to apply.

Job

Data Solution Architect

Primary Location

Administrative Centre (CA)

Organization

Aerospace Canada

Shift

Day job

Employee Status

Regular

Requisition

15264 Data Solution Architect