Data Analyst

HUB International; Winnipeg; On-site; CAD 70,000 - 100,000; Full time

Benefits offered by this job

RRSP match

Company perks

Work flexibility

Paid educational training

Job summary

HUB International is seeking a highly skilled Data Analyst to manage data from Applied Epic and build Power BI reporting infrastructure. You will own data quality, automate Epic processes, and drive efficiencies across the organization, enabling informed decision-making and strategic insights.

The role focuses on extracting data from Applied Epic, modeling it for dashboards, and delivering scalable analytics solutions with VBA-based automation and robust data governance.

Qualifications

• Hands-on experience with Applied Epic for data extraction and reporting.
• Strong Power BI expertise including DAX, data modeling and dashboards.
• Proficiency in SQL and Power Query; other query languages are a plus.
• Background in CS/Data Analytics/Information Systems or related field is an asset.
• Experience in insurance/brokerage industry is a strong asset.
• Excellent analytical and communication skills.

Responsibilities

• Extract and interpret data from Applied Epic to support reporting and analytics.
• Design, build, and maintain Power BI dashboards and reports for KPIs.
• Develop data models and ETL processes linking Applied Epic to Power BI.
• Maintain Epic automation (including VBA-based tools) to streamline data extraction.
• Establish data quality and validation across all Applied Epic reports.
• Write and optimize SQL queries for ad hoc and recurring reporting needs.
• Collaborate with underwriting, finance, operations, and leadership to gather requirements.
• Support migration/integration/optimization of Applied Epic data with other systems.
• Document data definitions and dashboard governance for long-term use.
• Stay updated on Applied Epic updates and Power BI features.

Skills

Applied Epic data

Power BI

SQL

Power Query

DAX

Data modeling

VBA

Education

Degree in Computer Science or related field

Tools

Epic automation

VBA tools

Job description

Ignite your potential. Impact what matters. Hi, we’re HUB – a network of doers with diverse stories and a shared goal to support our clients and communities. To do it, we believe in supporting each other, because great work happens when people come together, and that means building a team where anyone can spark an idea, and where everyone can make a difference. Where pushing ourselves forward helps us give more to others. When you partner with us, you’re at the center of a vast network of risk, insurance, employee benefits, retirement and wealth management specialists that bring clarity to a changing world with tailored solutions and unrelenting advocacy – so you’re ready for tomorrow.

The Opportunity:

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.

What You’ll Do

• 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

What We’re Looking For Required:

• 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)
• A background in Computer Science, Data Analytics, Information Systems, or a related field is considered 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
• Experience in the insurance or brokerage industry is a strong asset
• 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

Why Join HUB?

• An exceptional, welcoming, and inclusive company culture
• Excellent compensation, benefits, RRSP match, referral incentives, and company perks
• Work flexibility
• Paid educational training and vast learning opportunities
• Room for advancement and growth within the organization
• Paid day off for your birthday – we want to celebrate you!
• Diversity, Inclusion and Community Groups to connect employees

What makes us different than all the rest?

Our Vision: To be everywhere risk exists – today and tomorrow. Helping protect what matters most.

Our Mission: To protect and support the aspirations of individuals, families, and businesses. To empower our employees to learn, grow and make a difference in their communities.

Our Core Values:

• Entrepreneurship: We encourage innovation and educated risk‑taking
• Integrity: We do the right thing every time
• Teamwork: We work together to maximize results
• Accountability: We measure and take responsibility for outcomes
• Service: We serve clients, communities, and colleagues

Ready to join HUB and build a career in a rapidly growing industry? Department Business Operations Required Experience: 2-5 years of relevant experience Required Travel: No Travel Required

Hola, ¡SOMOS HUB! En un mundo que cambia constantemente, apoyamos y guiamos a negocios e individuos a prepararse para lo inesperado. Cuando te unes a nosotros estás rodeado de una red de expertos que te ayudarán a alcanzar tus metas, desde servicios de manejo de riesgo, manejo de reclamaciones y apoyo en cumplimiento. Esto te dará la tranquilidad mental de que las cosas que te importan más, estarán bien protegidas, a través de nuestra impecable asesoría y soluciones de seguros personalizadas que te proveerán mayor control y seguridad. SOBRE HUB INTERNATIONAL Nuestras Oficinas Corporativas tiene como sede la ciudad de Chicago en Illinois, Hub International Limited (Hub) es un corredor líder global que provee servicios y productos en Propiedad y Contingencia, Vida y Salud, Beneficios a Empleados, Manejo de Riesgo e Inversión. Tiene Oficinas localizadas a través de todo América del Norte. La extensa y amplia red de especialistas de HUB proveen tranquilidad mental en lo que más importa, protegiendo a los clientes por medio de la asesoría y soluciones de seguros atemperadas a sus necesidades. Para más información puedes visitar hubinternational.com