Business Intelligence Developer

WHO WE ARE

As a recognized leader in emergency communications, E-Comm is an organization that provides first responders and the public with critical life-safety services in communities across B.C. Our people are passionate about their work and public safety. We operate two emergency communications centres - one located in Vancouver and one in Saanich. E-Comm also provides integrated police, fire call taking, dispatch services to more than 70 police and fire departments, and owns/operates the largest multi-jurisdictional, tri-service wide-area radio network in B.C. We are proud to serve communities across this beautiful province through our four operational and administrative locations in Vancouver, Burnaby and Saanich. Learn more at

At E-Comm 9-1-1, we are committed to building a diverse and inclusive workforce that represents the

many communities that we proudly serve.

OUR VALUES

RESPECT | ACCOUNTABILITY | INTEGRITY | SERVICE | COLLABORATION

We are seeking a temporary Cloud BI Developer (1 year term) with strong Power BI expertise, including advanced DAX, Power Query, and DirectQuery optimization. The ideal candidate has experience delivering end-to-end solutions on Microsoft Fabric using Lakehouse and semantic models; contact center experience is considered an asset.

In this role, you will be responsible for designing, developing, deploying, and maintaining enterprise business intelligence solutions that enable data-driven decision-making across the organization. You will work closely with analysts, subject matter experts, and senior leaders to transform complex data into meaningful insights that support operational, financial, and workforce strategies.

This is a highly collaborative role that bridges business needs with technical execution, delivering trusted analytics products that track KPIs, surface trends, and identify opportunities for improvement.

What you'll do:

• Design, develop, deploy, and maintain business intelligence solutions including dashboards, reports, data models, and semantic layers using Power BI and cloud-based platforms
• Translate business requirements into technical specifications and scalable analytics solutions that support operational, financial, and workforce decision-making
• Build and optimize data models, DAX calculations, SQL queries, and Power BI datasets to deliver accurate, high-performing insights
• Ensure data quality, reliability, security, and performance through testing, validation, monitoring, and adherence to BI best practices
• Perform advanced and ad hoc analyses, including deep dives, trend analysis, and predictive or exploratory analytics; present findings to senior leadership
• Act as a subject matter expert for BI and analytics initiatives, supporting project planning, implementation, and evaluation
• Partner with stakeholders across Operations, Finance, Human Resources, and Technology to define KPIs, reporting needs, and improvement opportunities
• Support and enable BI end users through training, documentation, troubleshooting, and ongoing consultation
• Maintain and enhance the existing BI ecosystem, including continuous improvement of reports, dashboards, tools, and methodologies
• Contribute to documentation, knowledge management, and transition planning to ensure sustainable analytics operations

What you'll bring:

• A level of education, training, and experience equivalent to a Bachelor's degree in Analytics, Computer Science, Information Systems, Statistics, Mathematics, or a related discipline
• Five (5) years of experience in data-specific or business intelligence roles
• Extensive experience developing BI tools, including interactive dashboards, applications, and reports for business users
• Microsoft Azure certifications are a strong asset
• Advanced analytical thinking with the ability to translate raw data into clear, actionable insights
• Expert-level proficiency in Power BI, including advanced DAX calculations, Power Query, and row-level security
• Strong experience with MS SQL Server BI technologies including SSRS, T-SQL, MDX, and related tools
• Working knowledge of analytics platforms such as Power BI, Cognos, and Tableau
• Strong understanding of database design, operations, and optimization (e.g., SQL Server, PostgreSQL, NoSQL, flat-file storage)
• Experience with Azure Data Lake, Azure SQL, Synapse Analytics, and Analysis Services
• Familiarity with cloud environments (Microsoft Azure preferred)
• Working knowledge of object-oriented programming (VB.NET or C# considered an asset)
• Ability to work independently and collaboratively in a fast-paced, cross-functional environment
• Strong verbal and written communication skills, with the ability to explain complex concepts clearly to technical and non-technical audiences

Security Requirements:

As a condition of employment at E-Comm, the required Police Security Clearance applicable to the position must be acquired and maintained. This is a process carried out by our law enforcement partner agencies, facilitated by E-Comm. The minimum residency in Canada to qualify for this position, as established by our law enforcement partner agencies, is 5 years.

To qualify for this process, a candidate may be either a Canadian Permanent Resident or Canadian Citizen. We regret any candidates under Student, Visitor, or Work Visas are not eligible for consideration.

What We Offer:

• Meaningful work - work with a sense of purpose, supporting the public and first-responders
• Competitive salary - with the opportunity for increases
• 4 weeks' vacation to start
• Eligibility to participate in our Personal Time-Off Program
• 100% paid extended health and dental benefits

Vaccination Policy: E-Comm 911 has a vaccination policy that is currently suspended. However, should the policy be reinstated, it will be a requirement for all current and future employees.

Job Details:

• Number of positions: 1
• Job status: Temporary Full-Time (until March 31, 2027)
• Hours of work: Monday to Friday, 40 hours per week
• Wage/Salary: $85,500 to $106, rates) depending on experience
• Employee Group: Exempt
• Department: Data & Analytics
• Location: Vancouver/Hybrid
• CLOSING DATE FOR APPLICATIONS: Friday February 13, 2026 @ 11.59pm.

We are committed to accommodating persons with disabilities during the recruitment process and we will provide reasonable accommodations as requested. If you require assistance or accommodation due to a disability, please email