Data Scientist/Architect

Bombardier Transportation GmbH; Mississauga; On-site; CAD 80,000 - 110,000; Full time

Job summary

A global aerospace company in Mississauga seeks a Data Scientist/Architect to develop business intelligence solutions and support the supply chain management processes. The ideal candidate will hold a Bachelor’s degree in Computer or Software Engineering and have at least 5 years of experience in the field. Proficiency in SQL, Python, Power BI, and big data analytics is essential. Bilingualism in French and English is beneficial. A comprehensive benefits program is offered, emphasizing employee well-being and growth.

Benefits

Comprehensive insurance plans

Retirement savings plan

Employee Assistance Program

Qualifications

• 5+ years of experience in developing business intelligence solutions in a supply chain environment.
• Knowledge of supply chain concepts and processes.
• Bilingualism in French and English is an asset.

Responsibilities

• Develop SQL scripts to create reports from the data warehouse.
• Support and develop Python scripts for ETL processes.
• Participate in collaborative sessions to define business requirements.
• Analyze and utilize data to drive solutions for supply chain processes.

Skills

Business intelligence solutions

Big data analytics

Data transformation

SQL

Python

Power BI

Azure Synapse

MS Suite

Advanced Excel

Interpersonal skills

Education

Bachelor's degree in Computer or Software Engineering

Master's degree or relevant certifications

Tools

Microsoft Azure Data Lake

R Studio

Access

Job description

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

What are your contributions to the team?

• Participate in our data transformation with the design, development, and implementation of business intelligence solutions across materials management focused on driving actions in support of our core business objectives.
• Develop SQL scripts to create reports from our data warehouse (SQL server) or Microsoft Azure Data Lake.
• Support and develop Python scripts for data transformation (ETL) to reproduce existing analysis tool or to build new ones in collaboration with other business analysts.
• Develop, improve and maintain our Data Governance tools in Access & Power BI.
• Facilitate collaborative sessions with cross functional business stakeholders to drive discovery, data analysis, review to gain a more in-depth understanding of problem statements, define business requirements and document the project scope.
• Lead and/or participate in continuous improvement initiatives to augment the materials management team’s operational processes efficiencies.
• Analyze, develop problem statements, and utilize data to drive solutions and insight into our inventory control practices and supply chain processes within a worldwide parts network to improve parts availability and / or inventory turns.
• Validate all development work for quality and ensure requirements are met with the relevant stakeholders.
• Conduct walk-through and sign off sessions.
• Build and maintain a repository of reusable documentation to support future initiatives and training.
• Provide ad-hoc analysis requirements as needed.

How to thrive in this role?

• You hold a Bachelor degree in Computer or Software Engineering, or other related fields combined with 5 or more years of experience in developing business intelligence solutions in a supply chain environment.
• Masters or other relevant certification, after-market supply chain management and aerospace industry context knowledge are considered as strong assets.
• You exhibit a continuous improvement mindset with relevant experience in improving business processes.
• You have a passion and strong capacity for big data analytics using relevant technologies to automate, perform data transformation, build business intelligence, and improve analytical insights.
• You hold knowledge of core supply chain concepts, processes, and systems. Able to understand how different departments and processes intersect to impact supply chain processes.
• You have appropriate interpersonal skills and communication methods to effectively develop presentations, present business cases and communicate to all levels of the organization.
• You are comfortable working with big data, cloud-based computing, interacting with IT solutions and technical personnel.
• You are proficient with MS Suite (Required), Advance excel (Required), Power BI (Required), Azure Synapse (Required), Python (Required), SQL (Required), Access (Preferred), R Studio (Preferred) with the ability and excitement to learn new tools.
• Occasional travel may be required in this role.
• Bilingualism in French and English is mandatory for Montreal, and an asset for Toronto.

Now that you can see yourself in this role, apply and join the Bombardier Team!

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 Scientist/Architect

Primary Location Global 7500/8000

Organization Aerospace Canada

Shift Day job

Employee Status Regular

Requisition 10605 Data Scientist/Architect