Business Intelligence Analyst

Broadstreet Properties Ltd; Winnipeg; On-site; CAD 70,000 - 90,000; Full time

Job summary

A family-owned property management company in Winnipeg, Manitoba, is seeking a Business Intelligence - Business Analyst. This role involves supporting business intelligence initiatives, data integration, reporting, and automation. Candidates should have experience with enterprise-level software, proficiency in Power BI, and a strong background in data analytics. The position offers multiple perks including extended health benefits and professional development opportunities.

Benefits

Employer paid extended health, vision, and dental coverage

Employee and Family Assistance Program

Yearly health and wellness benefit

RPP eligibility after one year

Employee recognition program

Company-provided cellphone

In-house professional development opportunities

Qualifications

• Business analyst experience with enterprise‑level software.
• Proficiency in Power BI and advanced Microsoft Excel, including Power Query, DAX.
• Working knowledge of SQL and ability to query relational databases.

Responsibilities

• Prepare, clean, and aggregate large data sets from multiple systems.
• Develop and maintain customized reports and dashboards in Power BI and Excel.
• Support the annual budget process through data consolidation.

Skills

Power BI

Advanced Microsoft Excel

SQL

Data modeling

Analytical skills

Problem-solving

Communication skills

Education

Bachelor Degree in Business Administration, Data Analytics, Computer Science, or related field

Tools

Microsoft Fabric

Python

Job description

The Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross‑functional business intelligence initiatives including data integration, reporting, automation, and ad‑hoc analytics. The analyst will play a critical role in designing and developing customized data models and interactive reports that drive insight and strategic decision‑making across departments and management structures. In addition this individual will support in the budgeting process and will be responsible for key deliverables to management while liaising with regional operations staff to ensure the best practice is maintained.

This position will be located in Winnipeg MB.

Your contributions to the team include:

• Prepare, clean, and aggregate large data sets from multiple systems to support reporting and analytics needs.
• Develop and maintain customized, interactive reports and dashboards in Power BI and Excel.
• Support the annual budget process through data consolidation, report automation, and performance analysis.
• Perform financial and operational variance analysis, identifying trends, anomalies, and improvement opportunities.
• Collaborate with cross‑functional teams to define reporting requirements and key performance indicators (KPIs).
• Integrate data from various software solutions and APIs to enable centralized reporting and insights.
• Identify and resolve data quality issues, ensuring accuracy and consistency across systems and reports.
• Support the development of automated workflows and data pipelines to streamline recurring reporting tasks.
• Contribute to data governance practices and documentation of data models and reporting logic.
• Present findings and insights in a clear, visual format for both technical and non‑technical audiences.

What you need to be successful:

• Bachelor Degree in Business Administration, Data Analytics, Computer Science, or a related field.
• Business analyst experience with enterprise‑level software.
• Proficiency in Power BI and advanced Microsoft Excel (including Power Query, DAX)
• Working knowledge of SQL and ability to query relational databases.
• Understanding of data modeling and ETL processes; experience connecting APIs or integrating third‑party software data is a strong asset.
• Strong analytical, problem‑solving, and organizational skills.
• Clear and effective communicator, comfortable presenting complex data to non‑technical audiences.
• Able to manage multiple tasks and projects independently and in collaboration.
• Familiarity with Microsoft Fabric (Dataflows Gen2, OneLake, DirectLake, Etc.)
• Exposure to Python or other scripting languages for data analysis or automation.
• Knowledge of real estate, construction, property management, or hospitality operations.

The perks:

• Employer paid extended health, vision, and dental coverage (including family)
• Employee and Family Assistance Program
• Yearly health and wellness benefit
• RPP eligibility after one year
• Employee recognition program
• Company‑provided cellphone
• In‑house professional development opportunities

Why Broadstreet?

Broadstreet Properties Ltd. is a family‑owned and operated property management company, partnered with Seymour Pacific Developments, that manages multi‑family residential communities. We are a growing organisation made up of diverse team members who are motivated to continuously innovate our approach to asset management. We consider employee well‑being a priority and are dedicated to protecting the health and safety of our teams while ensuring a workplace that is respectful of everyone.

Broadstreet Properties Ltd. practices equal opportunity hiring and onboarding processes to ensure equal access and participation for everyone. We understand that we have a responsibility to ensure a safe, dignified, and welcoming environment, and we are committed to creating an inclusive environment for all employees irrespective of race, colour, religion, sexual orientation, gender identity, or any other status protected by law. We believe in integrating people with disabilities into our workforce by removing barriers and meeting accessibility needs.