BI/DW Solution Architect and Developer
Montreal Dorval, QC, CA
5d ago


At Bombardier, our employees work together to evolve mobility worldwide - one good idea at a time. If you have a good idea, we’ll provide the environment where it will thrive and grow into a great product or customer experience. Your ideas are our fuel.

In your role, you will :

Design and implementation of data warehouse solutions to meet the business needs

Generate value from the Azure enterprise data lake and manage its operations

Hands-on technical leader for ETL and DW with Microsoft solutions (SQL / Azure)

Work with business to define BI requirements, develop BI architecture and develop associated project plan / work breakdown structure

Design application management and operations models

Deliver BI solutions autonomously (simple project) or by leading external development team (complex project)

Support definition of the enterprise BI roadmap and execution

Identify, design, test and implement internal process improvements related to data valorization (automation, data delivery optimization, scalable / elastic solution design)

Ensure high availability of BI solutions with effective troubleshooting when needed

Produce high-quality and reusable code establish & monitor good development and code management process

Generate deployment artifacts align to ITIL best practices

Evangelize self-service BI and visual discovery and move the organization away from Excel / MS Access culture

Provide technical coaching to team members and business colleagues


As our ideal candidate,

  • You hold aUniversity degree in Computer Science, Engineering, Statistics, Information Systems or another quantitative field
  • You have a minimum of 10 years of experience in development of complex business intelligence / data warehouse solution

    You have an expert-level in SSAS, SSIS, SQL Server, SSRS technologies and fluent in OLTP, OLAP models

    You have the ability to bring data from different sources, formats, varied details into a unified format to enable actionable insights.

    Experience with SAP ECC ERP would be a key asset.

    You master .NET and at least 2 scripting languages generally used in BI solutions : Python, Java, C++, C#, etc

    You have experience in various projects delivered on Microsoft Azure Data Platform (SQL DB, Blob, Data Lake Hub, Data Factory, Synapse, Automation, etc.)

    You have experience with Azure DevOps / VSTS and / or TFS-GIT tools to run the full development lifecycle (or similar tool)

    You have the knowledge of semi-structure and unstructured data solutions (NoSQL)

    You have the knowledge of WhereScape Red and Power BI would be an asset

    You have strong project management / delivery mindset with good understanding of agile framework.

    You have the ability to thrive under pressure and demonstrate proficient priority management skills

    You have knowledge of latest market trends Big Data, Blockchain, AI

    You have strong written, verbal communication and strategic presentation skills Effectively communicate with non-technical staff & with members of interdisciplinary teams

    You must be able to work well both autonomously and collaboratively

    You have experience in managing external parties to deliver robust BI solutions.

    Bombardier is an equal opportunity employer and encourages women, Aboriginal people, persons with disabilities and members of visible minorities to apply.

    Whether your candidacy is moving on to the next step of the hiring process or not, we will keep you informed by email or by phone.

    Join us at

    Your ideas move people.


    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form