BI Developer

Johnston Group Inc.; Winnipeg; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A leading employee benefits provider is seeking a BI Developer in Winnipeg. The role involves designing and maintaining Power BI dashboards, developing ETL pipelines, and collaborating with stakeholders to ensure effective reporting solutions. Ideal candidates should have a degree in Computer Science or a related field and at least one year of experience in BI development. A hybrid working model is offered, with three days in-office per week.

Benefits

Hybrid working model

Community involvement opportunities

Qualifications

• Minimum 1 year of experience in BI development, data analytics, or a similar role.
• Proficiency in Power BI with experience designing and publishing dashboards.
• Strong communication and collaboration skills.

Responsibilities

• Design and maintain Power BI dashboards.
• Develop data pipelines using Python, dbt, Apache Airflow, and AWS Glue.
• Work closely with stakeholders to understand reporting needs.

Skills

Power BI

SQL

Python

Data Analytics

Data Visualization

Education

Bachelor’s degree or diploma in Computer Science, Data Science or related discipline

Tools

Apache Airflow

AWS Glue

dbt

Job description

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 ofCanada’s Best Managed Companiesand was named one ofManitoba’sTop 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 daysin-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 [e-mail] or by phone at 204-772-9565.