Associate – Deals - Deal Analytics & Value Creation

Industry/Sector

Not Applicable

Specialism

Deals

Management Level

Associate

Job Description & Summary

Job Description:

As an Experienced Associate, you will work as part of a team of problem solvers on working capital engagements. Key responsibilities include:

· Build and maintain Alteryx workflows to extract, cleanse, transform and blend large client datasets (for example, ERP extracts and data room files).

· Develop Power BI dashboards and reports, including data models, DAX measures and clear visualizations, for engagement teams and clients.

· Prepare Excel analyses and models, applying strong data handling and formatting skills.

· Perform data quality checks and reconciliations, tying outputs back to source data and client financials under the guidance of senior team members.

· Calculate key working capital metrics such as DSO, DPO and DIO using standard team templates and methodologies.

· Automate recurring data preparation and reporting steps, and document workflows and data assumptions.

· Help prepare client-ready deliverables, including charts, tables and summaries of key insights.

· Contribute to practice enablement activities, including accelerators, automation and AI-enabled tools.

PwC Professional skills and responsibilities for this management level also include, but are not limited to:

· Share and collaborate effectively with others.

· Identify and make suggestions for improvements when problems and/or opportunities arise.

· Handle, manipulate and analyze data and information responsibly.

· Communicate confidently in a clear, concise and articulate manner, verbally and in the materials you produce.

· Keep up to date with developments in your area of specialism and learn new tools and technologies as required.

· Uphold the firm's code of ethics and business conduct.

Preferred Fields of Study/Experience:

Bachelor's or Master's degree in Engineering, Computer Science, Data Analytics, Statistics, Mathematics, Finance, Accounting, Economics, Business Administration or a related field.

A total of 2–4 years of experience in data analytics, business intelligence, analytics consulting, Big 4 or management consulting, transaction services, FP&A or finance operations. Exposure to finance or working capital data is a plus but not required.

Preferred Knowledge/Skills:

Technical

· Strong hands-on experience in Alteryx, including building workflows to join, cleanse, transform and blend large datasets.

· Strong skills in Power BI, including data modeling, DAX and visualization.

· Advanced Excel skills (PowerPivot, lookups, pivot tables, formulae/formatting).

· SQL and/or Python for data extraction and analysis is a plus.

· Experience working with large, raw datasets from ERP systems or databases, with a high degree of data fluency and attention to detail.

· Experience automating data preparation or reporting processes.

· Experience using GenAI tools or large language models (LLMs) is good to have.

Finance and Working Capital (good to have)

· Basic understanding of financial statements and the working capital cycle (accounts receivable, accounts payable and inventory).

· Exposure to transaction-level finance data (for example, invoices, payments, aging reports or inventory records).

· Interest in learning working capital concepts and metrics such as DSO, DPO and DIO, and in building expertise in value creation for private equity and corporate clients.

Travel Requirements

Not Specified

Job Posting End Date