Senior, Decision Modelling (Montreal)

Ernst & Young Advisory Services Sdn Bhd; Montreal; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading advisory firm in Montreal is seeking a Senior Decision Modeller. You will design, build, and test integrated financial models while engaging in client management responsibilities. Ideal candidates possess strong Excel skills, are bilingual in French and English, and have experience in decision modelling. The role offers a collaborative team environment with opportunities for career progression.

Benefits

Comprehensive medical and dental coverage

Mental health benefits

Generous time off

Qualifications

• Ability to identify factors driving business performance.
• Passion for Decision Modelling and logical thinking.
• Bilingual in French and English is required.

Responsibilities

• Design, build, and test integrated financial models.
• Review financial models ensuring logical integrity.
• Work on business modelling and transaction decision projects.

Skills

Strong Excel Skills

Knowledge of complementary coding languages (M, DAX, VBA, Python, R)

Stakeholder Management

Logical thinking

Attention to Detail

Communication

Education

Strong commercial awareness

Experience in Decision Modelling

Tools

Data Visualization applications (e.g. MS Power BI, Tableau)

Statistical packages (e.g. MATLAB, SPSS)

VBA, C#, R or Python

Job description

At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.

The opportunity

Underpinning everything is our focus on developing a talented team through investment in technical and commercial training and knowledge transfer. Within the team you will have the opportunity to take on client management responsibilities and have the potential to gain excellent career progression.

The Decision Modelling team, within the EY Parthenon practice, is a provider of business modelling and analytics solutions to help support the full spectrum of strategy, transactions and consulting services. We work across sectors and our solutions focus on supporting strategic, operational, and financial decision making using flexible, robust and user-friendly models.

As part of your role you would work a varied portfolio of business modelling and transaction decision-related projects, which would include model builds to assist clients with developing Excel-based business planning and forecasting models as part of their ongoing business needs. You will also work on model review services and these are predominantly transaction decision-focused, typically project finance or buy side for potential investors as well as getting involved with the wider team on project work. Although our team are largely Toronto based, we operate as a national team and many of our engagements involve multi-national clients. There would likely be travel in Canada and a requirement to work outside of the country from time to time.

Your key responsibilities

As a Senior within Decision Modelling, you will join a collaborative team where our experienced leaders will coach and mentor your growth as a modeler, analyst and rounded commercial advisor. You will likely spend your day-to-day designing, building and testing integrated financial models for transaction decision-related projects or even for forecasting purposes for our clients. You’ll need a strong knowledge of Excel and how it can be applied to corporate finance and be flexible and adaptable when it comes to different projects. Reviewing financial models is key too and you will be part of teams that provide preliminary conclusions regarding the logical integrity of our clients’ models. Knowledge of analytical tools and techniques would also be of benefit in the role, such as data visualization software.

Skills and attributes for success

• Strong Excel Skills - designing and building models as well as testing them; incorporating operational, tax, accounting and financing aspects across a range of sectors. Strong understanding of Excel and its key functionality (such as Power Query, Power Pivot, spill functions, tables) and demonstrated ability to build models and analysis in Excel
• Knowledge of one or more complementary coding languages (such as M, DAX, VBA, Python and R) how they can be applied to corporate finance and business strategy problems
• Stakeholder Management - every day you’ll interface with multiple stakeholders across different functions to identify underlying business drivers and appreciate context of the transaction and the client's business issues
• Logical thinking - you’ll apply logical thinking and creative problem-solving skills to support resolution of issues
• Attention to Detail – you will build models to meet our rigorous standards and review models built by others to identify logical concerns
• Communication - Communicating effectively with the engagement manager, the client, and the wider team in a concerted effort towards delivering work products of the highest standard
• Support - assisting senior team members in developing new business

To qualify for the role you must have

• Strong commercial awareness and an ability to identify the factors that drive business and financial performance, and proven ability to think logically and map business understanding into Excel-based analytics or modelling
• A passion for Decision Modelling; highly motivated, numerate and a logical thinker are all key to the role
• This role involves interaction with clients operating nationally and globally. Bilingualism in both French and English is therefore a requirement of this role.

Ideally, you’ll also have

• Proven experience of Decision Modelling, with 2-3 years of commercial, client-facing work experience
• Strong interpersonal skills and previous experience of working within a similar team
• A designation (such as CFM, CFMP, CBV, CFA, CPA or P.Eng) certification or significant progress towards these or similar certifications
• Strong communication skills that enable you to simplify complex technical topics and share those with non-technical stakeholders.
• Experience with any of the following software packages: Data Visualization applications (e.g. MS Power BI, Tableau), Statistical packages (e.g. MATLAB, SPSS), VBA; C#, R or Python, MS Access; SQL Server

What We Are Looking For

We are looking for candidates who are highly motivated, analytical, logical thinkers with a passion for decision modelling and analytics, with very strong attention to detail. Being a strong team player is critical with the ability to adapt to changing requirements or deadlines in support of our clients’ goals. Also, being highly motivated and self-aware to work autonomously where required.

What we offer

The EY benefits package is designed to support your physical, emotional, financial, and social wellbeing. Our extensive benefits include comprehensive medical, dental, and prescription drug coverage, as well as mental health benefits, a robust Employee Assistance Program and group savings plans to promote your overall wellbeing. We offer generous time off, including personal days, vacation days, and additional firm-wide holidays, along with the option to purchase extra vacation days. Employees can take advantage of EY's exclusive learning programs tailored just for them. We also provide internal opportunities for career development and advancement, enabling you to grow within the firm. Get involved in meaningful volunteering through EY Ripples and make a positive impact in the community.

Are you ready to shape your future with confidence? Apply today.

To help create the best experience during the recruitment process, please describe any accommodations you may need.

Diversity and Inclusion at EY / Inclusiveness at EY

Diversity and inclusiveness are at the heart of who we are and how we work. We’re committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism, advancing gender equity and women in leadership, advocating for the 2SLGBTQIA+ community, promoting our neuroinclusion and accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.