Real Estate Business Intelligence Analyst

Wesgroup Properties started as a family business in British Columbia more than 60 years ago and today is one of Western Canada’s largest private real estate companies with a diversified portfolio spanning across residential and commercial real estate. Wesgroup owns and manages over 3.2 million square feet of commercial and multi-family real estate and has built more than 7,000 homes in 100 communities. With the active projects in our development pipeline, the portfolio will grow to over 7 million square feet over the next six years. Our operations are vertically integrated, encompassing land acquisition, construction, finance, design, marketing, sales, leasing, and property management. We have a long history of looking forward and we are dedicated to conducting business in line with our values of adaptability, accountability, relationships, and observing The Golden Rule without fail.

PROFILE SUMMARY

Wesgroup is poised for substantial growth over the next several years and in preparation for this exciting and challenging phase, we are actively seeking a highly engaged, driven and experienced Business Intelligence Analyst to join our team.

The Business Intelligence Analyst will play a pivotal role within the Development Analysis team, spearheading initiatives to enhance the data analytics and business intelligence processes for large-scale real estate development and construction projects.

KEY ACCOUNTABILITIES
- Create new processes and systems to coordinate and manage information from development proformas, cashflow forecasts, sales reports, development budgets, and accounting systems.
- Develop dynamic reports and integrated spreadsheets to identify outliers and trends.
- Lead efforts to extract, transform, and analyze data for actionable insights.
- Collaborate with cross-functional teams to drive data-driven decision-making processes.
- Create monthly, quarterly reports and on-demand dashboards.
- Enable real-time access to forecast returns, development metrics, and forecasts for individual development projects and across the entire development and construction pipeline.
- Provide actionable insight, information, and reporting for senior management to make strategic decisions.
- Implement the adoption, understanding, and use of new reporting tools across relevant users in the organization and create user documentation and training materials.
- Support with the creation and management of integrated development proformas and the consistency of development project proforma assumptions across the portfolio by creating the ability to quickly review key project statistics.

QUALIFICATIONS, KNOWLEDGE & EXPERIENCE
- Minimum 3 years of data analytics and reporting experience in a development and construction related field.
- Certificate, Diploma, or Degree in Data Science, Computer Science, Real Estate or equivalent experience.
- Expert knowledge of Microsoft Excel, Power Query, Power BI is a requirement.
- Understanding and experience within the Greater Vancouver real estate development industry is highly desired.
- Experience with proforma analysis and cash flow forecasting is desired.
- Experience and knowledge of Yardi is desired.
- The ability to challenge existing assumptions, an eye for recognizing trends, and investigating unexplained variances is required.
- Proven ability to present complex processes, information, and analysis into simple but informative presentations and reports is required.

EXPECTED COMPENSATION
- The expected salary range for this role is $90,000 - $105,000 per annum. Actual offered salary will depend on individual experience, qualifications, geographic location, market conditions for the role, and internal equity.
- Annual Bonus Program - Wesgroup also offers a competitive Annual Bonus Program that is intended to financially reward eligible employees for their contribution to the Company’s financial, and overall success.

WHAT WE OFFER
- A competitive compensation package with robust and extensive health benefits.
- A fun and inclusive culture supported by an employee-led Culture Committee with sponsorship from the President, providing you with opportunities to participate in group workouts, team sports, company-wide social events or celebrations, and other great initiatives that foster Wesgroup’s culture.
- The Wesgroup Store, stocked with amazing name-brand apparel and items to purchase using points earned for milestones, participation, and going above and beyond.
- A Lifestyle Spending Account which includes coverage for fitness, daycare, and eldercare costs. Wesgroup also covers the cost for all employees to attend two fitness classes per week at partnering fitness facilities to promote wellbeing.
- Wesgroup supports a broad range of community initiatives through donations and employee volunteer activities, including paid days off to volunteer your time each year and give back to our communities.
- Stocked kitchens with healthy (and not-so-healthy) snacks, fresh fruit