Business Intelligence Analyst

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

Job summary

A growing property management company in Winnipeg is seeking a Business Analyst to support business intelligence initiatives. This role involves data integration, reporting, and analytics to enhance decision-making. The ideal candidate will have a strong background in developing reports using Power BI and Excel, along with proficiency in SQL and data modeling. Perks include comprehensive health coverage and professional development. A degree in a related field is required.

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

• Experience in business analysis for enterprise-level software.
• Understanding of data modeling and ETL processes.
• Able to manage multiple tasks and projects independently.

Responsibilities

• Prepare, clean, and aggregate large data sets for reporting.
• Develop and maintain interactive reports in Power BI and Excel.
• Support annual budget process through data consolidation.

Skills

Proficiency in Power BI

Advanced Microsoft Excel

Strong analytical skills

Clear communication

Education

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

Tools

SQL

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 reportsSupport 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 of 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.