Business Analyst, Real Estate and Construction Data

Canadian Tire Corporation; Toronto; On-site; CAD 68,000 - 75,000; Full time

Job summary

Canadian Tire Corporation is seeking a Business Analyst for Real Estate and Construction Data to translate complex forecasting data into actionable insights. You will support Lucernex administration, testing, and improvements while collaborating with finance, construction, and operations teams.

The role requires strong SQL/JavaScript skills, advanced Excel and Power BI, and experience in AI-enabled analytics to automate processes and enhance forecast accuracy.

Qualifications

• Bachelor’s or higher in a relevant field.
• 3–5+ years in financial forecasting or analytics.
• Experience with Lucernex or similar capital project systems.
• Strong SQL/JavaScript and Excel skills.
• Experience creating dashboards with Power BI.

Responsibilities

• Translate forecasting data into clear insights for stakeholders.
• Develop dashboards and analytical models using Excel, Power BI, and 365 tools.
• Support Lucernex administration including onboarding, access, and testing.
• Coordinate UATs and document results to drive system improvements.
• Communicate complex forecast drivers to non-technical audiences.

Skills

SQL

JavaScript

Microsoft Excel

Power BI

AI-enabled analytics

Data storytelling

Executive communication

Forecasting

Education

Bachelor’s degree (Finance, Engineering, Construction Management, Data Analytics, Economics)

Tools

Lucernex (Accruent)

Microsoft Copilot

Job description

The Business Analyst, Real Estate and Construction Data is responsible for translating complex construction and financial forecasting data into clear, actionable insights while supporting the administration, testing, and continuous improvement of Lucernex and related business systems. This role bridges data, finance, operations, and technology by explaining forecast drivers, variances, risks, and assumptions; maintaining system access, roles, workflows, configurations, and data integrity; coordinating the onboarding and ongoing support of internal and external Lucernex users; and supporting system enhancements through requirements gathering, testing, issue resolution, documentation, and user training. The ideal candidate is a strong communicator and analytical problem-solver with system administration experience and working knowledge of SQL and JavaScript, capable of using AI-enabled tools and Microsoft technologies to improve system functionality, strengthen forecast accuracy, automate processes, and clearly explain the rationale behind the numbers.

What You’ll Do

Forecasting Insights & Analysis

• Interpret and synthesize construction and financial forecasting data, including cost, revenue, cash flow, productivity, and schedule impacts.
• Identify forecast drivers, trends, risks, and variances, and clearly explain their implications to non-technical audiences.
• Support short-term and long-range forecasting cycles, ensuring assumptions are well-documented and understood.
• Partner with estimating and project teams to validate inputs, challenge assumptions, and close forecasting gaps.

Data Storytelling & Communication

• Translate complex datasets into concise narratives, dashboards, and executive-ready materials.
• Prepare clear explanations for forecast changes, gaps, and anomalies, including root-cause analysis.
• Present insights to finance, construction leadership, and senior management with confidence and clarity.
• Proactively surface insights and recommendations rather than simply reporting results.

Cross-Functional Collaboration

• Collaborate closely with Finance, Construction, and Estimating teams to align forecasts and assumptions.
• Facilitate discussions to resolve discrepancies between financial and operational forecasts.
• Ensure consistency in forecasting methodologies and definitions across teams.
• AI, Automation & Microsoft Tools
• Leverage AI tools, including Microsoft Copilot and other approved solutions, to accelerate analysis and identify trends.
• Develop dashboards, reports, and analytical models using Microsoft Excel, Power BI, and Microsoft 365 tools.
• Automate recurring analyses and reporting processes to improve efficiency and accuracy.

Lucernex & Systems Administration

• Use SQL and JavaScript to query data, build reports, and support configuration of workflows
• Routinely monitor data quality and integrity with audits and coordinate coorections with data owners
• Support the onboarding and ongoing assistance of internal and external users in Lucernex, including account setup coordination, access validation, orientation, training, issue resolution, and guidance on Lucernex processes, workflows, and controls.
• Coordinate and support User Acceptance Testing (UAT) for Lucernex enhancements, system changes, and new workflows, including developing test scenarios, documenting results, identifying issues, and partnering with stakeholders to validate solutions before implementation.
• Stay current on emerging AI and analytics capabilities and recommend workflow improvements.

What You’ll Bring

• Bachelor’s degree in Finance, Engineering, Construction Management, Data Analytics, Economics, or a related field.
• 3-5+ years of experience in financial forecasting, construction analytics, project controls, or a similar analytical role.
• Strong understanding of construction cost drivers, estimating concepts, and financial forecasting principles.
• Working knowledge of SQL and JavaScript
• Experience administering a system or enterprise platform, including onboarding user access, workflow configuration, and testing
• Advanced proficiency in Microsoft Excel and experience with Power BI or similar visualization tools.
• Experience using AI-enabled analytics tools to support decision-making.
• Excellent communication and stakeholder management skills.
• Experience with Lucernex (Accruent) or similar capital project or cost management system, as well as UAT Testing
• Experience in construction, infrastructure, or capital-intensive environment.
• Familiarity with ERP systems, project management platforms, or cost control systems.
• Experience onboarding and supporting external users in systems, including access coordination, user communication, training, and resolution of account, access, or system issues.
• Experience with scenario modeling, sensitivity analysis, or long-range planning.
• Demonstrated ability to influence without authority and drive cross-functional alignment.

Key Competencies

• Data storytelling and executive communication
• Analytical thinking and problem-solving
• Attention to detail and data integrity
• Cross-functional collaboration
• Forecasting and financial acumen
• Continuous improvement and curiosity
• Responsible and effective use of AI tools

The target salary range is between $68,000.00 and $75,000.00 CAD Annual. Salary decisions are also dependent on other factors such as your experience, job-related knowledge, skills and competencies, market location, industry benchmarks, internal equity and other role-specific requirements.

This posting represents an existing vacancy within our organization.

We may use artificial intelligence tools as part of our recruitment process to assist in the initial screening of resumes. All hiring decisions, including candidate evaluation, selection, and disposition, are made by human recruiters.

About Us

Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, over 1,600 retail locations, financial services, exemplary e-commerce capabilities, and exciting market-leading merchandising strategies. We dream big and work as one to innovate with purpose for our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and wages to CTC employees, as well as store discounts, supported learning through our Triangle Learning Academy, Canadian Tire Profit Sharing, and retirement and savings programs for eligible employees. As part of our enhanced flex benefits program, we offer mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families, including total well-being, and mental health tools and resources for all employees. Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide-ranging! Join us, where there's a place for you here.

Our Commitment to Diversity, Inclusion and Belonging

We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better.

Accommodations

We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity-seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.