Senior Business Intelligence Engineer

Intrado Life & Safety, Inc.; Canada; On-site; CAD 165,000 - 175,000; Full time

Job summary

A leading emergency services company in Canada is seeking a Senior Business Intelligence Engineer to transform complex data into timely insights for the leadership team. This role involves designing high-visibility dashboards using Power BI, automating reporting processes, and ensuring data-driven decision-making. The ideal candidate should have over 5 years of experience in Business Intelligence, mastery in Excel and Power Query, and strong business acumen. The position offers a competitive salary package, comprehensive benefits, and the opportunity to make a significant impact.

Benefits

Paid parental leave

401(k) retirement plan

Employee discounts

Access to training resources

Mental health resources/support

Qualifications

• 5+ years of experience in Business Intelligence or Data Analysis.
• Mastery of Excel data model with DAX expertise.
• Proven experience in using Power Query for complex ETL tasks.

Responsibilities

• Design and build dashboards in Power BI and Salesforce.
• Analyze reporting workflows to improve efficiency.
• Transform complex data into actionable insights.

Skills

Power BI

Data Analysis

Excel data model

Power Query

Business Acumen

Education

Bachelor's degree

Tools

Salesforce

SQL

Python

Job description

About Us

Intrado is dedicated to saving lives and protecting communities, helping them prepare for, respond to, and recover from critical events. Our cutting‑edge company strives to become the most trusted, data‑centric emergency services partner by uniting fragmented communications into actionable intelligence for first responders. At Intrado, all of our work truly matters.

Responsibilities/Qualifications

We are seeking an exceptional Senior Business Intelligence Engineer to transform complex data into the timely, actionable insights our leadership team needs to make informed decisions. In this role, you will transform large, disparate datasets from multiple systems into polished, automated visualizations and reporting. You will also identify manual, error‑prone reporting processes and replace them with robust, automated solutions, ensuring that leadership has a clear view of company performance.

This is a demanding role in a results‑oriented environment with high expectations for agency, speed, and ownership.

Key Responsibilities

• Visualization & Reporting: Design and build high‑visibility dashboards and reporting that drive business behavior. You will architect polished visualizations in Power BI and build dashboards in Salesforce.
• Data Transformation (Power Query): You will act as the team’s expert in Power Query. You will build repeatable, automated workflows that extract, transform, and load large operational and financial datasets to produce actionable insights.
• Excel Expert: Build financial, operational, and relational data models in Excel.
• Process Automation: Analyze existing reporting workflows to identify inefficiencies. You will refactor fragmented, static spreadsheets into dynamic, scalable tools and build new, efficient processes.

Required Qualifications

• Experience: 5+ years of experience in Business Intelligence, Data Analysis, or FP&A with a proven track record of producing insights from large‑scale financial and operational datasets.
• Excel Expert: You must be a master of the Excel data model (Power Pivot). We require deep proficiency in writing DAX measures within Excel to build robust, relational models that can handle millions of records of data. A live Excel case study will be a part of the interview process.
• Power Query Mastery: Demonstrated ability to use Power Query to automate complex ETL tasks and manipulate large‑scale datasets to produce insights.
• Power BI Proficiency: Extensive experience building polished, interactive dashboards. You understand advanced DAX functions, data modeling best practices, and how to visualize data to tell a compelling business story.
• LLM Application: Demonstrated ability to use LLMs to accelerate data analysis, automate workflows, and increase overall productivity.
• Business Acumen: Ability to use data to answer complex business questions. You focus on outcomes, not just tools, ensuring your work directly supports decision‑making.
• Education: Bachelor’s degree.
• Misc: Basic knowledge of U.S. corporate accounting and finance concepts.

Preferred Qualifications

• Salesforce Expertise: Experience building and maintaining Salesforce reports and dashboards.
• Platform Experience: Experience working with data from Microsoft Dynamics 365 ERP, Essbase, ServiceNow, HubSpot.
• SQL & Python: Experience with SQL for basic data extraction and analysis. Python knowledge a plus.
• Prior experience working in a technology company or SaaS environment.
• Education: Bachelor’s degree in Computer Science, Engineering, Information Systems, Mathematics, Physics, or other technical or quantitative discipline.

Total Rewards

Want to love where you work? At Intrado, we offer a comprehensive benefits package that includes what you’d expect (medical, dental, vision, life and disability coverage, paid time off, a 401(k) retirement plan, and several that go above and beyond– paid parental leave, access to a robust library of personal and professional training resources, employee discounts, critical illness, hospital indemnity, access to legal support, pet insurance, identity theft protection, an EAP (Employee Assistance Program) that includes free mental health resources/support, and more! Apply today to join us in work worth doing!

The starting salary is anticipated between $165,000 and $175,000 CAD and will be commensurate with experience.

Intrado is an Equal Opportunity Employer – Veterans/Disabled and Other Protected Categories. Our Company welcomes and encourages applications of individuals with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. Intrado maintains a Drug Free Workplace.