Enterprise Data Engineer

Xpera Risk Mitigation & Investigation (Xpera) is Canada’s premier national provider of risk mitigation services. Our comprehensive offerings empower clients to enhance business performance and maintain operational continuity by equipping them with the expertise and tools necessary to manage risks at all levels. Our innovative solutions encompass investigations, labour dispute management, evacuation support, emergency security, and emergency staffing. With these solutions, we collaborate with our clients as a proactive partner, poised to assist them in addressing current crises or developing strategies to mitigate potential future risks. More information about Xpera can be found at xpera.ca.

We serve a diverse population across Canada and beyond. We strive to reflect that diversity within our workforce and ensure that every employee can be their authentic self. Adventurous, respectful, determined: We lead with ‘yes’, trust in our shared expertise, embrace innovation while holding each other accountable to our shared vision.

Reporting to the Director, Application Solutions, you will be responsible for designing, developing, and maintaining Business Intelligence (BI) solutions for Xpera. As a key member of the IT team, you will work closely with business stakeholders, analysts, and fellow IT team members to build and maintain a unified, enterprise-wide data model that supports consistent reporting, analytics, and decision-making across the organization. This role plays a critical part in transforming Xpera’s data assets into trusted, governed, and actionable insights.

What You Will Do:

Design, develop and maintain BI solutions.

Develop and evolve a unified semantic data model that standardizes definitions, Key Performance Indicators (KPIs), and data relationships across Xpera.

Define and govern data relationships, hierarchies, and business logic within the unified model to support operational and strategic reporting.

Understand KPIs that drive company measurement, reporting and analytics across key data sources and functions.

Craft and execute queries upon request for data.

Develop and implement ETL processes, reports and queries in support of business analytics.

Develop and implement interactive and polished analytic reports and dashboards.

Collaborate with a wide variety of stakeholders to deliver scalable BI solutions and a unified model that supports enterprise reporting.

Ensures best practices in data modeling, ETL, and reporting are consistently applied.

Work with business users to establish reporting and analytic requirements.

What You Will Bring:

Post-secondary education in Computer Science or a related discipline or a combination of related experience and education.

5 or more years of experience implementing and supporting BI solutions. Experience working in the insurance industry is an asset.

Experience with project/application life cycle methodologies.

Experience designing semantic models or unified data models in Power BI, SSAS, or similar technologies is an asset.

Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS, Power BI) and other reporting tools.

Familiarity with Agile development methodologies.

Proven ability to work effectively in a collaborative, team-oriented environment.

Exceptional communication and interpersonal skills.

An ability to manage multiple priorities and meet deadlines.

We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates throughout the recruitment and assessment process.

In accordance with Human Rights and Accessibility legislation, Xpera is an equal opportunity employer who is committed to providing an inclusive and barrier-free recruitment process. Applicant should advise Human Resources if they require any type of accommodation during the recruitment process.

Unsolicited Outreach Statement – Recruitment Agencies:

Xpera Risk Mitigation & Investigation will not accept unsolicited resume submittals from third-party recruiters and hereby request agencies to not contact Xpera employees or managers directly to present candidates.  Be advised Xpera will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume and will consider any unsolicited resumes forwarded public information.  Xpera welcomes resumes submitted directly from candidates.