Business Intelligence Analyst

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

Job summary

A family-owned property management company is seeking a Business Intelligence - Business Analyst to join their team in Campbell River, Canada. The role involves preparing data sets, developing reports, and supporting the budgeting process. Ideal candidates will have experience with Power BI, SQL, and strong analytical skills. This position promotes a collaborative environment focused on employee well-being and innovation.

Qualifications

• Business analyst experience with enterprise-level software.
• Understanding of ETL processes.
• Experience connecting APIs or integrating third-party software data.

Responsibilities

• Prepare, clean, and aggregate large data sets.
• Develop and maintain customized, interactive reports in Power BI and Excel.
• Support the annual budget process through data consolidation.
• Perform financial variance analysis and identify improvement opportunities.
• Collaborate with teams to define reporting requirements.

Skills

Power BI

Advanced Microsoft Excel

SQL

Data modeling

Analytical skills

Problem-solving skills

Communication skills

Python or other scripting languages

Education

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

Tools

Power BI

Excel

SQL databases

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

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 of other scripting languages for data analysis or automation
• Knowledge of real estate, construction, property management, or hospitality operations
  
  

Why Broadstreet?

Broadstreet Properties is a family owned and operated property management company partnered with Seymour Pacific Developments to build apartment and townhome communities. We are a growing organization made up of diverse team members who are motivated to continuously innovate our approach to asset management. We consider employee wellbeing 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 and is 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.

Powered by JazzHR

QxoaOw95jc