Business Analyst

Colliers Macaulay Nicolls Inc.

Canada

Hybrid

CAD 92,000 - 105,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Innovative projects
Career growth
Competitive benefits & compensation
Collaborative culture
Diversity & Inclusion program
Global network

Job summary

Colliers is seeking a Business Analyst for the Global Financial Systems team in Canada. You will translate business and data needs into clear requirements and practical solutions, working with Finance stakeholders, the Product Manager, data teams and delivery partners to improve finance platforms like D365 Finance and OneStream.

You will own analysis delivery, create future-state processes, user stories, acceptance criteria, data mappings and test scenarios, and lead UAT and release validation.

Qualifications

  • Post-secondary education or equivalent practical experience.
  • Experience translating business, system and data needs into clear requirements.
  • Experience with D365 Finance processes, data and reporting is required.

Responsibilities

  • Own business analysis delivery across D365 Finance, OneStream and TM1 with limited oversight.
  • Translate requirements into future-state processes, user stories and test cases.
  • Lead stakeholder workshops, document decisions, and manage dependencies.
  • Coordinate UAT, E2E and regression testing and manage defects.
  • Use SQL/data-analysis techniques to validate and troubleshoot data and reporting.

Skills

Strong communication
D365 Finance
Business analysis
Testing
Azure DevOps
SQL
OneStream/TM1

Education

Post-secondary education or equivalent

Tools

Azure DevOps
ServiceNow
Excel
SharePoint
Teams
Process mapping tools

Job description

Accelerate your success at Colliers. Why Colliers? As one of Canada’s leading commercial real estate services firms, we are driven by our mission to accelerate success for our people, clients, and communities. A career at Colliers gives you the opportunity to make an impact, advance your career, and collaborate with top-tier talent. Don’t just take our word for it – we’ve been recognized as a top employer on a number of prestigious lists, including Best Workplaces in Canada, Best Workplaces with Most Trusted Executive Teams, among others.

About the role:

As a Business Analyst within our Global Financial Systems team, you will support Colliers’ North American finance platforms by translating business, system, reporting and data needs into clear requirements and practical solutions. Working in an Agile environment, you will partner with Finance stakeholders, the Product Manager, data and reporting teams, and technical delivery partners to improve Microsoft Dynamics 365 Finance, OneStream, IBM Planning Analytics / TM1 and related platforms. In this role, you will: Own business analysis delivery: Manage assigned analysis across D365 Finance, OneStream, IBM Planning Analytics / TM1 and associated finance, data and reporting platforms with limited oversight. Translate requirements into solutions: Analyze processes, system interactions and data flows, then develop future-state processes, requirements, user stories, acceptance criteria, data mappings and test scenarios. Facilitate stakeholder alignment: Lead workshops, interviews, process walkthroughs and solution-validation sessions while documenting decisions, assumptions, dependencies and open items. Coordinate testing and release readiness: Plan and execute UAT, end‑to‑end, regression, data and release validation; manage defects and support cutover, go‑live, hypercare and stabilization. Improve financial systems and data: Use SQL and data‑analysis techniques to validate, reconcile and troubleshoot financial data, integrations and reporting issues, and recommend sustainable process improvements.

What you bring:
  • Strong communication skills: Ability to translate complex business, system, reporting and data needs into clear requirements and communicate effectively with Finance stakeholders, product leadership, data teams and technical delivery partners.
  • Microsoft Dynamics 365 Finance: Experience supporting D365 Finance processes, integrations, data, testing or reporting, with working knowledge of finance processes such as record‑to‑report, close, consolidation, budgeting, forecasting, procure‑to‑pay or order‑to‑cash.
  • Business analysis and testing: Experience producing process documentation, requirements, user stories, acceptance criteria, data mappings, test plans, test cases and training materials, and coordinating UAT, E2E and regression testing.
  • Tools and data: Proficiency with Azure DevOps, ServiceNow, Microsoft Excel, SharePoint, Teams and process‑mapping tools; SQL experience is an asset.
  • Additional platform exposure: Experience with IBM Planning Analytics / TM1 and Planning Analytics Workspace is a strong asset; IBM Cognos, OneStream and enterprise reporting or integration platforms are also valued.
Education:

Post‑secondary education or equivalent practical experience

Approximate Compensation Range for this Role:

$92,450 to $105,000

What we offer:
  • Innovative projects: Work on cutting‑edge initiatives that shape our communities, drive our growth, and make a tangible impact.
  • Career growth: Advance your career and achieve your goals with industry‑leading training and development programs.
  • Competitive benefits & compensation: Enjoy a comprehensive and flexible benefits package along with competitive compensation that rewards your contributions and supports your well‑being.
  • Collaborative culture: Join our enterprising team where innovation thrives, collaboration is key, and our people are empowered to be their authentic selves and do their best work.
  • Diversity, Equity & Inclusion: Our robust North American Diversity & Inclusion Program features eight Employee Resource Groups (ERGs), where you can connect, learn, and contribute to a diverse and supportive community. Learn more: https://www.collierscanada.com/en-ca/careers/diversity-and-inclusion
  • Global network: Join a global team of 28,000 professionals across 70 countries, where you'll expand your network and learn from experts in a dynamic international community. Accelerate your career and enhance your expertise as you connect and collaborate with top talent around the world.

Applicants must be currently authorized to work in Canada on a full‑time basis. The employer will not sponsor applicants for work visas.

Colliers is an equal opportunity employer and values diversity in its workforce. Colliers encourages applications from all qualified individuals and will accommodate applicants' disability‑related needs, up to the point of undue hardship, throughout all stages of the recruitment and selection process.

We are enterprising. Our expert advice to property occupiers, owners and investors leads the industry into the future. We invest in relationships to create enduring value. What sets us apart is not what we do, but how we do it. Our people are passionate, take personal responsibility and always do what’s right for our clients, people and communities. We attract and develop industry leaders, empowering them to think and act differently to drive exceptional results.

What’s more, our global reach maximizes the potential of property, wherever our clients do business. At Colliers, we accelerate success.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Business Analyst
Senior Business Analyst

Colliers • Vancouver

Hybrid
CAD 105,000 - 120,000
Innovative projects
Career growth
Competitive benefits & compensation
+2
Business Analyst
Business Analyst

Colliers • Vancouver

Hybrid
CAD 92,000 - 105,000
Innovative projects
Career growth
Competitive benefits
+3
Senior Business Analyst
Senior Business Analyst

Colliers • Vancouver

Hybrid
CAD 105,000 - 120,000
Innovative projects
Career growth
Competitive benefits & compensation
+3
Data Business Analyst
Data Business Analyst

Colliers • Toronto

Hybrid
CAD 92,000 - 105,000
Innovative projects
Career growth
Competitive benefits & compensation
+3
Financial Analyst/Senior Financial Analyst
Financial Analyst/Senior Financial Analyst

Colliers • Toronto

Hybrid
CAD 88,000 - 95,000
Innovative projects
Career growth
Competitive benefits & compensation
+2
Financial Analyst/Senior Financial Analyst
Financial Analyst/Senior Financial Analyst

Colliers • Toronto

Hybrid
CAD 88,000 - 95,000
Innovative projects
Career growth
Benefits package
+3
Commercial Real Estate Appraiser
Commercial Real Estate Appraiser

Colliers • Calgary

Hybrid
CAD 90,000 - 130,000
Licensed Commercial Sales Associate
Licensed Commercial Sales Associate

Colliers • Toronto

On-site
CAD 40,000 - 70,000
Innovative projects
Career growth
Competitive benefits & compensation
+3
Senior Lease Analyst
Senior Lease Analyst

Colliers International Real Estate Management Services (CA), Inc. • Oakville

Hybrid
CAD 85,000 - 89,000
Innovative projects
Career growth
Competitive benefits & compensation
+2
Transaction Coordinator (Enterprise Clients Support)
Transaction Coordinator (Enterprise Clients Support)

Colliers • Toronto

On-site
CAD 54,000 - 87,000
Innovative projects
Career growth
Competitive compensation
+3