BI Developer

Intelcom | Dragonfly; Montreal (administrative region); On-site; CAD 70,000 - 100,000; Full time

Benefits offered by this job

On-site gym with a personal trainer

Employer-provided lunch of your choice

Comprehensive group insurance

Group RRSP plan

Care & Well‑Being Activities

Partial reimbursement for public运输

Employee Assistance Program

Job summary

Intelcom | Dragonfly is seeking a BI Analyst to own end-to-end BI solutions, translate business needs into data-driven reports, and collaborate with stakeholders across Canada. The role emphasizes building scalable data models and ensuring data quality across Power BI dashboards.

You will work with SQL, data dictionaries, and semantic models, contributing to governance and self-service analytics while supporting UAT and deployment activities.

Qualifications

• Strong working knowledge of SQL and relational data concepts.
• Practical experience with Power BI or a similar business intelligence platform.
• Good knowledge of ETL/ELT principles, data modeling standards, and semantic modeling concepts.
• Ability to understand business processes and translate requirements into maintainable analytical solutions.
• Ability to validate data, troubleshoot issues systematically, and explain complex technical concepts to non-experts.

Responsibilities

• Collaborate with stakeholders to understand the business problem, decision, data, and analytical requirements before defining a solution.
• Translate business needs into clear functional and technical requirements, including business rules, data definitions, transformation logic, workflows, and acceptance criteria.
• Own assigned BI solutions from requirements and detailed design through development, validation, User Acceptance Testing, deployment support, and continuous improvement.
• Challenge unclear or duplicative requirements and identify when an existing solution can be extended rather than creating new reporting.

Skills

SQL

Power BI

ETL/ELT concepts

Data modeling

Stakeholder communication

Analytical thinking

Education

Bachelor's degree in Data Engineering/Analytics/BA/CS/IS or related field

Tools

Power BI

ETL tools

Job description

Intelcom | Dragonfly

With more than 100 sorting stations and operations across three continents, Intelcom | Dragonfly is Canada’s leader in last-mile logistics. Our vision is clear: to deliver fast, accurate, and reliable service powered by cutting-edge technology.

A Strategic Role at the Heart of Logistic

Responsibilities

• Collaborate with stakeholders to understand the business problem, decision, data, and analytical requirements before defining a solution.
• Translate business needs into clear functional and technical requirements, including business rules, data definitions, transformation logic, workflows, and acceptance criteria.
• Own assigned BI solutions from requirements and detailed design through development, validation, User Acceptance Testing, deployment support, and continuous improvement.
• Challenge unclear or duplicative requirements and identify when an existing solution can be extended rather than creating new reporting.

Intelcom | Dragonfly

With more than 100 sorting stations and operations across three continents, Intelcom | Dragonfly is Canada’s leader in last-mile logistics. Our vision is clear: to deliver fast, accurate, and reliable service powered by cutting-edge technology.

A Strategic Role at the Heart of Logistic

Responsibilities

• Collaborate with stakeholders to understand the business problem, decision, data, and analytical requirements before defining a solution.
• Translate business needs into clear functional and technical requirements, including business rules, data definitions, transformation logic, workflows, and acceptance criteria.
• Own assigned BI solutions from requirements and detailed design through development, validation, User Acceptance Testing, deployment support, and continuous improvement.
• Challenge unclear or duplicative requirements and identify when an existing solution can be extended rather than creating new reporting.

Business Requirements and Solution Ownership

• Collaborate with stakeholders to understand the business problem, decision, data, and analytical requirements before defining a solution.
• Translate business needs into clear functional and technical requirements, including business rules, data definitions, transformation logic, workflows, and acceptance criteria.
• Own assigned BI solutions from requirements and detailed design through development, validation, User Acceptance Testing, deployment support, and continuous improvement.
• Challenge unclear or duplicative requirements and identify when an existing solution can be extended rather than creating new reporting.

BI Development and Data Modeling

• Develop and maintain BI solutions using Power BI or similar tools, SQL, and sound data and semantic modeling practices.
• Reuse and extend existing reports, governed datasets, semantic models, measures, and common definitions before introducing new report-specific logic where appropriate.
• Contribute to solution architecture and detailed design in collaboration with senior BI developers and Data Engineering.
• Document solutions sufficiently to support maintainability, knowledge transfer, and ongoing support.

Quality, Validation, and Support

• Develop and document test scenarios and validate reports, dashboards, datasets, and business logic before release.
• Prepare and accompany users through User Acceptance Testing and support adoption of delivered solutions.
• Participate in incident and problem resolution, identify root causes, and propose sustainable solutions and action plans.
• Apply a strong quality mindset to data accuracy, reliability, and solution performance.

Continuous Improvement and Self-Service

• Identify and recommend opportunities to improve performance, automate repetitive work, reduce duplication, and simplify existing solutions.
• Support and train application super users and contribute to progressively enabling governed self-service.
• Share knowledge with colleagues and contribute to reusable practices, documentation, and team standards.
• Proactively propose practical improvements rather than waiting for detailed direction.

Key Performance Indicators (KPIs)

• Accuracy and reliability of BI solutions and business logic.
• On-time delivery of assigned BI solutions and quality of validation before release.
• Reuse of existing governed datasets, semantic models, measures, and reporting capabilities where appropriate.
• Reduction of recurring manual work, duplicate logic, and avoidable support issues.
• Adoption and usability of delivered solutions by business stakeholders.
• Quality of documentation, maintainability, and knowledge transfer.
• Demonstrated growth in independent problem solving and solution ownership.

Qualifications

• 4-5 years of experience working on business intelligence, analytics, or related data projects.
• Experience translating business requirements into data flows, business rules, data dictionaries, functional specifications, and analytical solutions.
• Bachelor's degree in Data Engineering, Analytics, Business Analysis, Computer Science, Information Systems, or related field, or equivalent relevant experience.
• Strong working knowledge of SQL and relational data concepts.
• Practical experience with Power BI or a similar business intelligence platform.
• Good knowledge of ETL/ELT principles, data modeling standards, and semantic modeling concepts.
• Ability to understand business processes and translate requirements into maintainable analytical solutions.
• Ability to validate data, troubleshoot issues systematically, and explain complex technical concepts to non-experts.
• The role involves daily (or regular) communication with pan-Canadian stakeholders.

Preferred

• Experience with cloud data platforms, version control, APIs, or modern BI development practices.
• Experience supporting business users through training, UAT, and self-service analytics.
• Experience improving or automating existing BI processes and solutions.

Why Join Us?

Benefits

At Intelcom | Dragonfly, you’ll thrive in a flexible and stimulating environment, surrounded by passionate talent. You’ll also enjoy a wide range of benefits:

• On-site gym with a personal trainer
• Employer-provided lunch of your choice
• Comprehensive group insurance
• Group RRSP plan
• Care & Well‑Being Activities
• Partial reimbursement for public transportation
• Employee Assistance Program

and much more.

This position has been opened to address a genuine organizational need within the company.

At Intelcom | Dragonfly, we move forward guided by strong values: collaboration, innovation, excellence, and responsibility.

We embrace diversity, ensure equity, and foster a true sense of belonging.

Accommodation measures are available for individuals with disabilities throughout our recruitment process, in compliance with the law. Please let us know if you have any specific needs.