Top Benefits
About the role
Johnston Group provides employee benefit solutions to over 30,000 companies, ranging from one employee to thousands across various product lines, including Chambers of Commerce Group Insurance Plan, Canada’s #1 employee benefits plan for small businesses. JG is a platinum member of Canada’s Best Managed Companies and was named one of Manitoba’s Top Employers. We support a positive work atmosphere where we value the diversity in the people we serve and are looking for talent who will contribute to our diverse and inclusive workplace; where individual differences are recognized, appreciated, and respected. JG believes in giving back and contributes significantly to local health, arts, sports, and other community organizations.
The BI Developer is responsible for designing, developing, and maintaining business intelligence solutions that support data-driven decision-making across the organization. This includes building and maintaining Power BI dashboards, developing data pipelines using tools like Python, dbt, Apache Airflow, and AWS Glue, and creating reusable data models to support analytics. This role involves working closely with business stakeholders to understand reporting needs, deliver ad-hoc reports using SQL, and build user-friendly data visualizations and interfaces. The BI Developer also resolves data quality issues, supports data governance efforts, and collaborates with analysts, managers, and business units to ensure reporting solutions are effective, accurate, and aligned with business objectives.
- Hybrid working model based out of our Winnipeg, MB office, with three days in-office per week.
Qualifications:
- Bachelor’s degree or diploma in Computer Science, Data Science, Statistics, or a related discipline
- Minimum 1 year of experience in BI development, data analytics, or a similar role involving data modeling and reporting
- Proficiency in Power BI, with experience designing and publishing dashboards, reports, and data visualizations
- Familiarity with other BI tools and platforms is considered an asset
- Strong SQL skills and experience working with relational databases, data lakes, and RESTful APIs
- Experience developing and maintaining ETL pipelines using tools such as Python, dbt, Apache Airflow, and AWS Glue
- Solid understanding of dimensional data modeling and data warehousing principles
- Skilled in developing stored procedures and user-defined functions
- Advanced Excel capabilities for analyzing and presenting data
- Strong communication and collaboration skills, with the ability to translate complex data into actionable insights for stakeholders
- Detail-oriented, analytical, and proactive in identifying and resolving data quality or reporting issues
The successful candidate must be legally eligible to work in Canada. We thank all applicants for their interest. Please note that only those selected for an interview will be contacted.
JG welcomes the opportunity to provide accommodation throughout the selection process. Please contact us to discuss your requirements by email at human.resources@johnstongroup.ca or by phone at 204-772-9565.
About Johnston Group Inc.
One of Canada's Leading Group Insurance Administrators.
Johnston Group offers companies a new way of thinking about how to structure an employee benefit program that meets the employees’ and company’s needs. Integrity, respect and professionalism, along with a strong desire to strive for excellence, mean clients can expect exceptional service and a positive experience each time they contact Johnston Group.
Johnston Group provides benefit services to more than 30,000 businesses and their employees. With over $400 million in premiums under its administration, and over 30 years of experience, Johnston Group’s strength lies in its administrative capabilities. Headquartered in Winnipeg, Manitoba, a staff of approximately 200:
* issue 300 new group cases a month;
* field 26,000 calls monthly from advisors, employers and employees; and
* process over 1,200 health and dental claims on a typical day, virtually all within 48 hours of receipt.
Johnston Group is proud to have been recognized as one of Canada’s 50 Best Managed Companies every year since 2001 and a member of the Platinum Club since 2007. The country’s leading business awards program, sponsored by Deloitte, CIBC Commercial Banking, National Post, Mackay CEO Forums, and Queen's School of Business, recognizes excellence in privately-owned and managed Canadian companies.
In the Spirit of respect, we honour and acknowledge our head office is on Treaty One territory and the traditional lands of the Anishinaabe, Ininew, Oji-Cree, Dene, Dakota, and the Homeland of the Red River Métis Nation. We are grateful and thankful for our water, which comes from Shoal Lake 40 First Nation Treaty 3 territory, and we understand its significance in light of the many communities who currently do not enjoy the benefit of clean drinking water. We are committed to supporting the interests of Indigenous peoples and communities and we pledge to listen, learn and work together in the spirit of truth and reconciliation.
Top Benefits
About the role
Johnston Group provides employee benefit solutions to over 30,000 companies, ranging from one employee to thousands across various product lines, including Chambers of Commerce Group Insurance Plan, Canada’s #1 employee benefits plan for small businesses. JG is a platinum member of Canada’s Best Managed Companies and was named one of Manitoba’s Top Employers. We support a positive work atmosphere where we value the diversity in the people we serve and are looking for talent who will contribute to our diverse and inclusive workplace; where individual differences are recognized, appreciated, and respected. JG believes in giving back and contributes significantly to local health, arts, sports, and other community organizations.
The BI Developer is responsible for designing, developing, and maintaining business intelligence solutions that support data-driven decision-making across the organization. This includes building and maintaining Power BI dashboards, developing data pipelines using tools like Python, dbt, Apache Airflow, and AWS Glue, and creating reusable data models to support analytics. This role involves working closely with business stakeholders to understand reporting needs, deliver ad-hoc reports using SQL, and build user-friendly data visualizations and interfaces. The BI Developer also resolves data quality issues, supports data governance efforts, and collaborates with analysts, managers, and business units to ensure reporting solutions are effective, accurate, and aligned with business objectives.
- Hybrid working model based out of our Winnipeg, MB office, with three days in-office per week.
Qualifications:
- Bachelor’s degree or diploma in Computer Science, Data Science, Statistics, or a related discipline
- Minimum 1 year of experience in BI development, data analytics, or a similar role involving data modeling and reporting
- Proficiency in Power BI, with experience designing and publishing dashboards, reports, and data visualizations
- Familiarity with other BI tools and platforms is considered an asset
- Strong SQL skills and experience working with relational databases, data lakes, and RESTful APIs
- Experience developing and maintaining ETL pipelines using tools such as Python, dbt, Apache Airflow, and AWS Glue
- Solid understanding of dimensional data modeling and data warehousing principles
- Skilled in developing stored procedures and user-defined functions
- Advanced Excel capabilities for analyzing and presenting data
- Strong communication and collaboration skills, with the ability to translate complex data into actionable insights for stakeholders
- Detail-oriented, analytical, and proactive in identifying and resolving data quality or reporting issues
The successful candidate must be legally eligible to work in Canada. We thank all applicants for their interest. Please note that only those selected for an interview will be contacted.
JG welcomes the opportunity to provide accommodation throughout the selection process. Please contact us to discuss your requirements by email at human.resources@johnstongroup.ca or by phone at 204-772-9565.
About Johnston Group Inc.
One of Canada's Leading Group Insurance Administrators.
Johnston Group offers companies a new way of thinking about how to structure an employee benefit program that meets the employees’ and company’s needs. Integrity, respect and professionalism, along with a strong desire to strive for excellence, mean clients can expect exceptional service and a positive experience each time they contact Johnston Group.
Johnston Group provides benefit services to more than 30,000 businesses and their employees. With over $400 million in premiums under its administration, and over 30 years of experience, Johnston Group’s strength lies in its administrative capabilities. Headquartered in Winnipeg, Manitoba, a staff of approximately 200:
* issue 300 new group cases a month;
* field 26,000 calls monthly from advisors, employers and employees; and
* process over 1,200 health and dental claims on a typical day, virtually all within 48 hours of receipt.
Johnston Group is proud to have been recognized as one of Canada’s 50 Best Managed Companies every year since 2001 and a member of the Platinum Club since 2007. The country’s leading business awards program, sponsored by Deloitte, CIBC Commercial Banking, National Post, Mackay CEO Forums, and Queen's School of Business, recognizes excellence in privately-owned and managed Canadian companies.
In the Spirit of respect, we honour and acknowledge our head office is on Treaty One territory and the traditional lands of the Anishinaabe, Ininew, Oji-Cree, Dene, Dakota, and the Homeland of the Red River Métis Nation. We are grateful and thankful for our water, which comes from Shoal Lake 40 First Nation Treaty 3 territory, and we understand its significance in light of the many communities who currently do not enjoy the benefit of clean drinking water. We are committed to supporting the interests of Indigenous peoples and communities and we pledge to listen, learn and work together in the spirit of truth and reconciliation.