BI/ETL Developer

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 challenges.

*Hybrid working model based out of our Winnipeg, MB office, with three days in-office per week.

Duties and Responsibilities:

• 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.

Qualifications:

• 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 email at human.resources@johnstongroup.ca or by phone at 204-772-9565.