Data Architect

Pratt & Whitney; Longueuil; On-site; CAD 110,000 - 140,000; Full time

Benefits offered by this job

Pension and savings plan

Group insurance

Career progression

Merit program

Health and wellness program

Transit and parking

Job summary

Pratt & Whitney Canada is seeking a senior Data Architect/Engineer to design scalable data architectures, models, and governance frameworks at our Longueuil site. You will lead data modeling, integration, and security initiatives, collaborating with data scientists, engineers, and business units.

Role requires 8+ years in data roles, strong SQL/NoSQL skills, and experience with Snowflake and Databricks. On-site work with 5–10% travel may be required.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Computer Engineering, or related field.
• 8+ years of experience as a Data Architect, Data Engineer, or similar.
• Strong relational and non-relational database knowledge.
• Hands-on with data warehousing and data lake platforms (Snowflake, Databricks).
• Advanced skills in designing and maintaining data models and schemas.
• Proven experience building and optimizing ETL pipelines.
• Familiarity with big data frameworks (e.g., Apache Spark) and cloud platforms (AWS & Azure).
• Strong analytical and communication skills for cross-functional teams.

Responsibilities

• Design and develop innovative database solutions and data models.
• Develop and maintain logical, conceptual, and physical data models.
• Establish data governance standards and ensure data quality and compliance.
• Consolidate data from multiple sources into a unified architecture for BI and analytics.
• Ensure data security and compliance with regulations and policies.
• Evaluate emerging data technologies and tools for architecture improvements.
• Create comprehensive documentation for data architecture, models, workflows, and standards.
• Attend business travel 5–10% of the time.

Skills

Data Architecture

Data Engineering

ETL Pipelines

Spark

Cloud Platforms

Databases

English Communication

Education

Bachelor's or Master's in CS/Engineering

Tools

Snowflake

Databricks

Apache Spark

AWS

Azure

Job description

About Pratt & Whitney Canada

Pratt & Whitney Canada (P&WC) is a global leader in aerospace innovation, proudly headquartered in Longueuil, Quebec, since 1928. We design and manufacture next-generation aircraft engines that power the world’s largest fleet of business, general aviation, and regional aircraft and helicopters.

For nearly 100 years, our teams have been at the forefront of propulsion technology, pushing boundaries to make flight more efficient and reliable. Our engines support missions that truly matter, from transporting people and essential goods, to enabling emergency medical services, humanitarian operations, and wildfire suppression around the world.

An Employer of Choice

Pratt & Whitney Canada was named one of Canada’s Best Employers for 2026 by Forbes, marking the 11th consecutive year the company has earned this recognition. Pratt & Whitney Canada also ranked #1 employer in the aerospace and defense industry in the country. In addition, our headquarters continues to be recognized among the top employers in the Montreal region. Together, these distinctions reinforce our reputation as an employer of choice in Montreal, across Canada, and around the world.

Why join our team?

You will work alongside experts in data, artificial intelligence, and engineering to design scalable architectures and innovative solutions that address complex business challenges. Your expertise will have a tangible impact on strategic projects, while giving you the opportunity to explore new technologies and deepen your knowledge in a constantly evolving field.

The position is based at our Longueuil location, from Monday to Friday, with flexible hours and exclusively on-site.

What will your day-to-day look like?

• Design and Development: Create and implement innovative database solutions and data models to efficiently store, organize, and retrieve company information.
• Data Modeling: Develop and maintain logical, conceptual, and physical data models that align with and support enterprise data architecture strategies.
• Data Governance: Establish and uphold data governance standards and best practices to ensure data quality, consistency, and compliance across the organization.
• Data Integration: Consolidate data from multiple sources into a unified architecture to enable robust business intelligence, reporting, and analytics capabilities.
• Security: Ensure that data is managed securely and complies with all relevant regulations, standards, and internal policies.
• Technology Evaluation: Assess and implement emerging data technologies and tools to optimize data architecture processes and maintain a competitive edge.
• Documentation: Create and maintain comprehensive documentation for data architecture, models, workflows, and standards to support transparency and operational efficiency.
• Business Travel: 5 to 10% of the time

What You Will Learn

• Gain hands‑on experience working on a large-scale AI initiative that leverages cutting‑edge technologies and practices to solve complex, real‑world challenges.
• Deepen your expertise in advanced AI methodologies, including machine learning (ML), deep learning, and data engineering workflows.
• Collaborate with a diverse and talented team of data engineers, data scientists, and machine learning engineers (MLEs) to design innovative solutions.

What do you need to be successful?

• Bachelor’s degree or Master’s degree in Computer Science, Computer Engineering, or a related field.
• 8+ years of experience as a Data Architect, Data Engineer, or in a similar technical role.
• Expertise in database management systems, with a strong understanding of relational and non‑relational databases.
• Hands‑on experience with data warehousing and data lake platforms (e.g., Snowflake, Databricks).
• Advanced skills in designing and maintaining data models and schemas.
• Proven experience in building and optimizing ETL (Extract, Transform, Load) pipelines.
• Familiarity with big data frameworks and technologies (e.g., Apache Spark).
• Proficiency in working with cloud‑based data platforms (e.g., AWS & Azure).
• Strong analytical and problem‑solving abilities to address complex data challenges.
• Exceptional communication and collaboration skills to work effectively with cross‑functional teams.
• Demonstrated ability to juggle multiple projects simultaneously and manage priorities in a fast‑paced environment.
• This position is part of a French‑speaking work environment, it requires a very good knowledge of English to read and understand, on a daily basis, documentation and technical terms that may emanate from international organizations, as well as to write and communicate in English with customers, suppliers or international colleagues.

What do we offer?

• Pension and savings plan with employer contributions
• Group insurance program
• Opportunities for advancement (career progression)
• Merit or recognition program
• Health and wellness program, including virtual health care
• Recreational and sports club
• Nearby daycares
• Transportation accessibility or public transit program and free parking

Working at Pratt & Whitney Canada

The masculine pronoun is used without discrimination and solely for the purpose of making the text easier to read. We will consider applications from all qualified candidates.

At Pratt & Whitney Canada, we combine passion, boldness, and precision to design, manufacture, and maintain the most advanced and reliable aircraft engines in the world. Our work and the quality of our products contribute to the success of our customers, who in turn save lives, support commerce, connect communities, and protect freedoms.

At Pratt & Whitney Canada, you have the opportunity to make a difference every day—just look up. Are you ready to go beyond?

The selected candidate will be required to complete a criminal background check and any applicable clearances with respect to the handling and transfer of controlled goods. Employment is conditional upon the successful completion of these checks and obtaining the required clearances. Failure to do so will result in the withdrawal of the employment offer.