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/ETL Developer plays an important role within our IT team by helping design, maintain, and improve the data pipelines and reporting tools that support our business. This role is ideal for someone early in their BI and data engineering career who is eager to learn, contribute, and grow in a supportive environment.
In this position, you will help build efficient ETL/ELT processes using tools such as Airflow, Python, and dbt, and you will support the creation of meaningful dashboards and reports using Power BI. You’ll work closely with senior developers and key business partners to ensure our data remains accurate, secure, and accessible.
You will also assist with writing SQL queries, maintaining documentation, and supporting data users across the organization. This is a hands‑on role where curiosity, attention to detail, and strong communication skills are essential. You’ll be encouraged to ask questions, seek help when needed, and actively build your technical foundation as you take on new challeng es.
*Hybrid working model based out of our Winnipeg, MB office, with three days in-office per w eek.
Duties and Responsibiliies
- Develop and optimize ETL/ELT workflows using Airflow, Python, and dbt.
- Write SQL queries and support BI users and developers with reporting needs.
- Support the planning, testing, and implementation of ETL processes.
- Deploy code to testing and production environments.
- Prepare and maintain clear technical documentation.
- Collaborate effectively with teammates and stakeholders, and work independently when required.
- Recommend improvements to tools and processes to enhance efficiency.
- Share knowledge and support team members in a professional and friendly manner.
- Participate in technical planning and solution discussions.
- Approach new tasks with a learning mindset and apply knowledge as you progress.
- Communicate openly about areas where you need support or clarification.
Qualificaions:
- Bachelor’s degree or diploma in Computer Science, Information Technology, or a related field.
- Training or experience with SQL and relational databases (e.g., DB2 for IBMi, Postgres).
- Exposure to stored procedures, dbt, and RESTful APIs.
- Experience with ETL tools such as Airflow.
- Familiarity with scripting languages such as Python.
- Understanding of dimensional data modeling.
- Strong Excel skills for data analysis and reporting.
- Ability to translate business and technical requirements into workable solutions.
- Comfortable communicating with both technical and non‑technical audiences.
- Practical experience may come primarily from academic coursework or project work.
- Experience with Git is considered an asset.
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 e mail at human.resources@johnston group.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.
Similar jobs you might like
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/ETL Developer plays an important role within our IT team by helping design, maintain, and improve the data pipelines and reporting tools that support our business. This role is ideal for someone early in their BI and data engineering career who is eager to learn, contribute, and grow in a supportive environment.
In this position, you will help build efficient ETL/ELT processes using tools such as Airflow, Python, and dbt, and you will support the creation of meaningful dashboards and reports using Power BI. You’ll work closely with senior developers and key business partners to ensure our data remains accurate, secure, and accessible.
You will also assist with writing SQL queries, maintaining documentation, and supporting data users across the organization. This is a hands‑on role where curiosity, attention to detail, and strong communication skills are essential. You’ll be encouraged to ask questions, seek help when needed, and actively build your technical foundation as you take on new challeng es.
*Hybrid working model based out of our Winnipeg, MB office, with three days in-office per w eek.
Duties and Responsibiliies
- Develop and optimize ETL/ELT workflows using Airflow, Python, and dbt.
- Write SQL queries and support BI users and developers with reporting needs.
- Support the planning, testing, and implementation of ETL processes.
- Deploy code to testing and production environments.
- Prepare and maintain clear technical documentation.
- Collaborate effectively with teammates and stakeholders, and work independently when required.
- Recommend improvements to tools and processes to enhance efficiency.
- Share knowledge and support team members in a professional and friendly manner.
- Participate in technical planning and solution discussions.
- Approach new tasks with a learning mindset and apply knowledge as you progress.
- Communicate openly about areas where you need support or clarification.
Qualificaions:
- Bachelor’s degree or diploma in Computer Science, Information Technology, or a related field.
- Training or experience with SQL and relational databases (e.g., DB2 for IBMi, Postgres).
- Exposure to stored procedures, dbt, and RESTful APIs.
- Experience with ETL tools such as Airflow.
- Familiarity with scripting languages such as Python.
- Understanding of dimensional data modeling.
- Strong Excel skills for data analysis and reporting.
- Ability to translate business and technical requirements into workable solutions.
- Comfortable communicating with both technical and non‑technical audiences.
- Practical experience may come primarily from academic coursework or project work.
- Experience with Git is considered an asset.
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 e mail at human.resources@johnston group.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.