Data Solution Architect

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

Benefits offered by this job

Insurance plans (Dental, medical)

Retirement savings plan

Employee Assistance Program

Job summary

Bombardier's Data, AI & Automation team seeks a Data Solution Architect to define and govern enterprise data and analytics solutions, aligning with architecture standards, security and governance. You will lead data integration, analytics, AI/ML, cloud platforms and BI initiatives.

Requirements include a bachelor’s degree in CS/engineering/IT, 10+ years in data modeling and ETL/ELT, 5+ years in Databricks Lakehouse, and strong cloud/data security expertise; proficiency in English and French is

Qualifications

• 10+ years of data modeling, data pipeline development, data warehouse and lakehouse administration.
• 5+ years delivering complex solutions in a Databricks Lakehouse environment.
• Strong understanding of cloud-based data platforms and data security.

Responsibilities

• Architect cloud data solutions (OLAP, OLTP, API, SQL, NoSQL, Lakehouse, BI).
• Design data models, metadata usage and data integration requirements.
• Ensure observability, availability, backup, archival, disaster recovery and security compliance.
• Collaborate with data engineers, BI and ML/AI developers to translate specs into data solutions.
• Align solutions with data governance policies and data management strategy.
• Investigate data quality issues and address root causes.
• Support data platform usage rules and access management.
• Coordinate with multiple departments and external vendors.

Skills

Data modeling

ETL/ELT

Data warehouse

Lakehouse

Databricks

Cloud architecture

Security principles

API-based solutions

Stakeholder management

Communication

Education

Bachelor's degree in CS/Engineering/IT

Tools

Databricks

Azure

SQL

NoSQL

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