EY Senior Decision Modelling Calgary 

Canada, Alberta, Calgary 

242489700

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.

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

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
• Financial modelling experience
• 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

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.