Data Analyst

HUB International•Winnipeg, MB

11d•Remote

About The Position

We are looking for a highly skilled Data Analyst with strong, hands-on experience in Applied Epic and Power BI to join our team. This role is central to maintaining, structuring, and leveraging data from Applied Epic to support operational decision-making, business performance tracking, and strategic initiatives across the organization. The successful candidate will take ownership of data quality metrics, build and maintain Power BI reporting infrastructure, develop Epic automation, and drive system efficiencies. Demonstrated expertise in Applied Epic's data structure and reporting capabilities, combined with advanced Power BI skills, is essential to success in this role. This is a great opportunity for someone who is detail-oriented, analytical, and excited about transforming insurance and brokerage data into actionable, visual business intelligence.

Requirements

Significant hands-on experience working directly within Applied Epic, specifically in data extraction, reporting, and analysis
Strong, proven experience with Power BI, including DAX, Power Query, data modeling, and building interactive dashboards from scratch
Proficiency in SQL and Power Query (other query languages an asset)
Proficiency in VBA coding for automation and process improvement
Solid understanding of data modeling principles, particularly as they apply to reporting, dashboard integration, and Epic's underlying schema
Strong analytical and problem-solving skills, with a sharp eye for accuracy and detail
Excellent written and verbal communication skills, with the ability to present technical findings clearly to non-technical stakeholders
Comfortable working within Windows-based systems and standard business applications (Microsoft Office suite, etc.)
Ability to manage multiple priorities and projects independently in a fast-paced environment

Nice To Haves

A background in Computer Science, Data Analytics, Information Systems, or a related field is considered an asset
Experience in the insurance or brokerage industry is a strong asset

Responsibilities

Extract, analyze, and interpret data directly from Applied Epic, using advanced knowledge of its data structure, tables, and relationships to support business reporting and analytics
Design, build, and maintain Power BI dashboards, reports, and data visualizations that present KPIs and operational metrics to stakeholders at all levels of the organization
Develop and manage data models and ETL processes connecting Applied Epic to Power BI, ensuring scalable, reliable, and efficient reporting solutions
Build and maintain Epic automation (including VBA-based tools and scripts) to streamline data extraction, reduce manual processes, and improve system efficiency
Establish and enforce data quality and validation processes to ensure accuracy and consistency across all Applied Epic-sourced reports and downstream systems
Write and optimize queries (SQL and/or Epic-native reporting tools) to support ad hoc and recurring reporting needs
Partner with underwriting, finance, operations, and leadership teams to gather reporting requirements and translate them into effective Power BI solutions
Support projects involving the migration, integration, or optimization of Applied Epic data with other business platforms (e.g., finance systems, CRM, data warehouses)
Maintain documentation of data definitions, report logic, and dashboard structures to support long-term data governance
Stay current on Applied Epic updates/releases and Power BI features to continuously improve reporting capabilities