Junior BI Developer

The Westman Group of Companies; Winnipeg; On-site; CAD 55,000 - 75,000; Full time

Job summary

Forthright Properties in Winnipeg, MB, seeks a Junior BI Developer to join the enterprise systems team and advance business intelligence capabilities. The role focuses on using SQL Server, Azure, Excel, and AI-assisted workflows to drive data‑driven decisions.

You will build reports, optimize queries, and support data integration while collaborating with IT and business users. This in‑office position offers ongoing learning across cloud technologies and data modeling.

Qualifications

• Diploma or bachelor's degree in CS/IT/SE/Data Analytics or related field.
• 0–2 years of software development, database development, or business intelligence (co‑op/internship = acceptable).
• Knowledge of Microsoft SQL Server and SQL query development.
• Familiarity with Microsoft Azure services.
• Advanced Excel skills (PivotTables, Power Query, VBA) are an asset.
• Strong analytical skills and a proactive approach to AI-powered workflows.
• Understanding of relational databases and data modeling.
• Familiarity with Git version control.

Responsibilities

• Develop, maintain, and support internal applications and software solutions.
• Design, develop, and maintain reports, dashboards, and BI solutions.
• Develop and optimize SQL queries, stored procedures, views, and database objects in SQL Server.
• Support Microsoft Azure cloud services, applications, and databases.
• Assist with data integration, ETL processes, and migrations across systems.
• Utilize AI tools to accelerate coding, generate test cases, and document tech specs.
• Assist in training and fine‑tuning AI models.
• Collaborate with management to integrate APIs into enterprise systems.
• Translate business requirements into technical solutions.
• Create automated reports and data models using Excel and other tools.
• Work with users to identify automation opportunities and process improvements.
• Troubleshoot application, database, and reporting issues.
• Participate in testing, deployment, and documentation.
• Monitor performance and suggest enhancements.
• Support system integrations using APIs and other technologies.
• Maintain technical docs, user guides, and development standards.

Skills

Analytical skills

Team collaboration

Communication

AI-powered workflows

Education

Bachelor's/Diploma in CS/IT/SE/Data Analytics

Tools

SQL Server

Azure

Excel

Git

Job description

Location:

Job Type:

Full Time

Professional Areas:

Finance
Information Services

Manitoba Made. Manitoba Owned. Welcome to Your New Home!

Established in 2011 and located in Winnipeg, MB, Forthright Properties is a professionally managed, family-owned company. A rapidly growing and expanding portfolio of properties allows us to meet our goal; to provide you with a modern, affordable place to call home.

Position Overview

Reporting to the Manager, Enterprise Systems & Technology, the Junior BI Developer supports the development, maintenance, and enhancement of business applications, databases, and business intelligence solutions. The successful candidate will work with Microsoft Azure, SQL Server, Excel, and other business systems to develop technical solutions, automate processes, improve reporting, and support data-driven decision‑making. This role will leverage AI solutions to support and enhance the organization’s strategic goals. This position offers an excellent opportunity to gain experience across software development, cloud technologies, data integration, and business intelligence.

This position will be located in office at our head office at 7 Green Acres Lane, Navin, MB. Remote or hybrid work are not available for this role.

Key Responsibilities

• Develop, maintain, and support internal applications and software solutions.
• Design, develop, and maintain reports, dashboards, and business intelligence solutions.
• Develop and optimize SQL queries, stored procedures, views, and database objects within Microsoft SQL Server.
• Support Microsoft Azure cloud services, applications, and databases.
• Assist with data integration, ETL processes, and migration activities across multiple business systems.
• Utilize AI tools to accelerate coding, generate test cases, and create technical documentation.
• Assist in developing, training, and fine‑tuning AI models.
• Work with management to integrate conversational AI, APIs into enterprise systems.
• Analyze business requirements and translate them into technical solutions.
• Create and maintain automated reports and data models using Excel and other reporting tools.
• Collaborate with business users to identify opportunities for process improvements and automation.
• Troubleshoot application, database, and reporting issues.
• Participate in software testing, deployment, and documentation.
• Monitor application and database performance and recommend enhancements.
• Support system integrations using APIs and other integration technologies.
• Maintain technical documentation, user guides, and development standards.
• Stay current with emerging technologies and recommend improvements to existing systems and processes.

Required Qualifications

• Diploma or bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or a related discipline.
• 0–2 years of experience in software development, database development, or business intelligence (co‑op or internship experience considered).
• Knowledge of Microsoft SQL Server and SQL query development.
• Familiarity with Microsoft Azure services.
• Experience with Microsoft Excel, including advanced formulas, PivotTables, Power Query, or VBA is an asset.
• Strong analytical skills and a proven desire to adopt and responsibly use AI‑powered workflows.
• Understanding of relational databases and data modeling principles.
• Familiarity with version control systems such as Git.
• Strong analytical, troubleshooting, and problem‑solving skills.
• Excellent communication and interpersonal skills.
• Ability to manage multiple priorities in a collaborative team environment.

Preferred Qualifications

• Experience with Microsoft Power BI or other business intelligence platforms.
• Knowledge of ETL processes and data warehousing concepts.
• Experience working with ERP, CRM, or other enterprise business systems.
• Understanding of REST APIs and system integrations.
• Microsoft Azure Fundamentals (AZ‑900) or related Microsoft certifications are an asset.

Key Skills

• Microsoft SQL Server (T‑SQL)
• Business Intelligence & Reporting
• Power BI
• Microsoft Excel (Advanced)
• Data Analysis & Data Modeling
• ETL & Data Integration
• C#/.NET, Python, Blazor or similar programming languages