Data Solution Architect

Bombardier Transportation GmbH; Dorval; Hybrid; CAD 120,000 - 180,000; Full time

Benefits offered by this job

Insurance plans (Dental, medical, life

Retirement savings plan

Employee Assistance Program

Job summary

Bombardier is hiring a Data Solution Architect in Canada to lead the design, governance and delivery of enterprise data and analytics solutions. You will shape data models, pipelines and lakehouse architectures across cloud platforms while working with data engineers, BI and ML teams.

The role requires strong communication in English and French, with a focus on security, governance and scalable data platforms in a hybrid work environment.

Qualifications

• Bachelor's degree in computer science, engineering or IT fields.
• 10+ years of data modeling and data pipeline development experience.
• 5+ years delivering complex Databricks Lakehouse solutions.
• Experience with cloud-based data platforms supporting big data analytics.
• Knowledge of security principles for cloud-hosted data solutions.
• Familiarity with data integration architectures and APIs.

Responsibilities

• Design and govern enterprise data and analytics solutions aligned with governance policies.
• Architect cloud data solutions (OLAP/OLTP, API, SQL, NoSQL, Lakehouse, BI).
• Collaborate with data engineers, BI and ML/AI teams to translate specs into solutions.
• Ensure observability, availability, backup, archival, and security compliance.
• Lead data platform usage rules and monitor ingestion, processing, and access.

Skills

Data modeling

ETL/ELT development

Data warehouse

Lakehouse architecture

Databricks platform

Cloud data platforms

Security for cloud analytics

API-based integration

Cross-team collaboration

Bilingual: English & French

Education

Bachelor's degree in CS/Engineering/IT

Tools

Databricks

Azure

SQL/NoSQL

JSON/Parquet/ORC

Job description

When applicable, Bombardier promotes flexible and hybrid work policies.

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.

With our employees’ well-being top of mind, we offer a comprehensive and competitive Benefits Program, which includes the following:

• Insurance plans (Dental, medical, life insurance, disability, and more)
• Retirement savings plan
• Employee Assistance 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