Deals Value Creation Analytics Senior Associate

PwC Canada; Montreal (administrative region); Hybrid; CAD 78,000 - 128,000; Full time

Benefits offered by this job

Hybrid work environment

Job summary

PwC Canada is building a Deal and Value Creation Analytics team. The role focuses on valuations, financial analysis, and post-merger integration strategy, partnering with clients across deals, divestitures, and restructuring.

You’ll join a team of problem solvers delivering data-driven insights and managing complex analytics projects. You will communicate findings to both technical and non-technical stakeholders while traveling up to 20% of the time, supporting growth and client value creation.

Qualifications

• Experience integrating disparate data sources and structuring data using Alteryx, SQL, Python, Databricks, or Power Query.
• Experience with cloud data environments (AWS or Azure).
• Experience with AI platforms such as GPT and Claude, and coding agents like GitHub Copilot.
• Experience applying prompt engineering best practices for high‑quality outputs.
• Professional experience in management consulting focused on finance/analytics or in Corporate Development or M&A.
• Intermediate to advanced Excel proficiency.
• Experience with financial modelling and business case development, incl. integrated models, forecasting, scenarios, KPI trees.
• Able to explain technical details to non‑technical stakeholders and drive decision making.
• Willingness to travel up to 20% within Canada and internationally.
• PwC Canada hybrid work environment awareness.

Responsibilities

• Support analytics projects showcasing drivers and equity stories to increase deal confidence.
• Arm management with data‑driven insights for fact‑based decisions.
• Bring structure to complex problems and meet tight deadlines.
• Translate technical work for non‑technical stakeholders to support decisions.
• Review and create reports and presentations for diverse audiences.
• Collaborate with Global Data Analytics to enhance analytics offerings.
• Build relationships across levels internally and with clients.
• Support business development to research new/existing clients.
• Act as a business partner and strategic advisor translating analysis into commercial questions.

Skills

Alteryx

SQL

Python

Databricks

Power Query

AWS

Azure

GPT/Claude

GitHub Copilot

Prompt engineering

Excel

Financial modelling

Business case development

Non-technical communication

Travel readiness

Tools

Alteryx

SQL

Python

Databricks

Power Query

AWS

Azure

GPT

Claude

GitHub Copilot

Job description

At PwC, our people in deals focus on providing strategic advice and support to clients in areas such as mergers and acquisitions, divestitures, and restructuring. They help clients navigate complex transactions and maximise value in their business deals. Those in deal integration and valuation realisation at PwC will focus on assisting clients in successfully integrating acquisitions and maximising the value of their investments. You will be responsible for conducting valuations, financial analysis, and developing strategies for post-merger integration.

The Opportunity

As a Deal and Value Creation Analytics member, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. Responsibilities include but are not limited to:

• Supporting high profile analytics projects showcasing the drivers and equity story of a business either to management or to bidders to increase deal confidence
• Supporting analytics projects to arm management with data driven insights to enable fact-based decision making and drive value within the business
• Bringing structure and clarity to complex problems and business scenarios within tight deadlines
• Using your technical know-how and translating this for our non-technical stakeholders to support robust, evidence-based decisions
• Reviewing & creating reports and presentations and translating our findings to technical and non-technical stakeholders
• Working with our Global Data Analytics community to further enhance our analytics proposition
• Building and developing strong relationships at all levels both internally and externally
• Supporting business development activities to help identify and research opportunities on new/existing client
• Most importantly, we need you to become a business partner and strategic advisor to our clients, translating and communicating your analysis to help answer critical commercial questions.

What You’ll Bring

• Experience integrating disparate data sources and structuring, cleansing, and transforming data using tools such as Alteryx, SQL, Python, Databricks, or Power Query
• Experience working in cloud-based data environments, including AWS or Azure, with an understanding of data architectures and scalable analytics workflows
• Working knowledge of AI platforms such as GPT, Claude, and coding agents like GitHub Copilot or Claude Code
• Experience applying prompt engineering best practices to drive high quality, reliable outputs for analysis, content generation, and workflow automation
• Professional experience, ideally in management consulting focused on finance and analytics or in Corporate Development or M&A (e.g. Private Equity)
• Intermediate to advance proficiency with Excel
• Experience with financial modelling and business case development would be considered an asset, including exposure to integrated financial models, forecasting, scenario and sensitivity analysis, KPI driver trees, and investment case support.
• Technically minded and driven by solving complex problems. You will be working with some excellent analytical brains and varying stakeholders for our clients, and for this reason you will know how to explain technical details to non-technical people
• Use your commercial and financial skills to understand the drivers of a business, analyze their data, and use this to provide clear insights and advice to our clients
• Understand commercial drivers of a business and able to succinctly articulate this to stakeholders
• Able to articulate complex financial or technical concepts to non-finance staff
• Proven capability to self-motivate and learn
• The ability and willingness to travel around up to 20% within Canada and internationally
• PwC Canada is committed to cultivating an inclusive, hybrid work environment. Exact expectations for your team can be discussed with your interviewer

This newly created role reflects our commitment to growth and delivering distinctive value for our clients and stakeholders.

The salary range for this position is $77,500 - $127,500. The posted salary range represents the expected hiring range for PwC locations in major city centres. Given our national recruiting approach, ranges may vary for positions in other locations. At PwC Canada, base salary is determined by your skills, experience, qualifications and work location. In addition to base salary, eligible employees may have opportunities to participate in variable incentive pay programs which are designed to reward individual and firm-wide achievements. We are committed to offering competitive compensation and adhere to all relevant pay transparency legislation. During the hiring process, our Talent Acquisition team will provide details about our comprehensive total rewards package.

Why you’ll love PwC

We’reinspiring and empowering our people to change the world. Powered by the latest technology,you’llbe a part ofdiverseteams helping public and private clients build trust and deliver sustained outcomes. This meaningful work, and our continuous development environment, will take your career to the next level. We reward your impact, and support your wellbeing, through a competitive compensation package, inclusive benefits and flexibility programs that will help you thrive in work and life.

PwC Canada acknowledges that we work and live across Turtle Island, on the land that is now known as Canada, which are the lands of the ancestral, treaty and unceded territories of the First Nations, Métis and Inuit Peoples. We recognize the systemic racism,colonialismand oppression that Indigenous Peoples have experienced and still go through, and we commit to allyship and solidarity.

We’re committed to providing accommodation throughout the application, interview, and employment process. If you require accommodation to be at your best, please let us know during the application process.

The use of artificial intelligence (AI) in recruiting is just getting started, so we know you have questions about how and why we use it. At certain points during our recruiting process, we rely on AI to improve your experience. This could be during resume review or curating personalized job recommendations, asking you clarifying questions via a chatbot or during our interview scheduling to improve your experience. Our use of AI helps ensure we combat bias by evaluating candidates equally and fairly, without seeing identity information, such as your name, or gender for example). AI also helps us better predict successful hires by reviewing all applicants for a role and the relationship between your skills, experience and likely success at PwC Canada. While AI supports parts of our recruitment process, final hiring decisions always involve human review. For more information about our use and protection of your data, please refer to our Privacy Policy (https://www.pwc.com/ca/en/privacy-policy.html).