Supervising Associate

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

EY GDS – Pricing Platforms & Tools – Supervising Associate

As a Supervising Associate in the Platform & Tools, Strategic Pricing & Insights team under Commercial Excellence, you will support pricing and commercial initiatives by transforming data into actionable insights, managing analytics workflows, and building scalable solutions and dashboards.

The focus is on enabling decision-making through business analysis, requirements gathering, data modeling, solution design, and visualization using modern tools.

This role goes beyond traditional analytics, spanning:

• Business Analysis & Requirements – Collaborate with stakeholders to define requirements, translate business needs into analytical solutions, and prioritize deliverables.
• Data Engineering & Modeling – Execute data ingestion, transformation, and modeling using SQL, Power Query M, and Python; assist in ETL processes in Microsoft Fabric/Azure Synapse.
• Solution Design & Enablement – Develop, maintain, and enhance scalable analytics solutions and dashboards for pricing and commercial decision-making.
• Visualization & Reporting – Build KPI-driven dashboards in Power BI and Excel with compelling storytelling for both technical and non-technical audiences.
• Workflow Automation – Automate routine tasks using Power Automate, Excel macros, and Python scripts to improve operational efficiency.

Your key responsibilities

• Data Architecture & Engineering: Support data ingestion and transformation using SQL, T‑SQL, and Power Query M. Assist in building ETL pipelines and managing data flows within Microsoft Fabric (Dataflow Gen2, Lakehouse/Warehouse, Pipelines) and Azure Synapse environments.
• Analytics & Decision Support: Analyze structured and unstructured data using statistical methods (regression, correlation, time-series forecasting) to generate insights and ongoing reports. Apply a hypothesis-driven approach to synthesize findings that inform pricing decisions.
• Visualization & Insight Generation: Develop dashboards in Power BI and Excel; use Python visualization libraries (Matplotlib, Seaborn) for exploratory analysis. Emphasize KPI design, storytelling, and clear communication to both technical and non-technical audiences.
• Pricing Analytics & Commercial Strategy: Support analytics programs such as willingness-to-pay, win-loss analysis, and price waterfall basics; contribute to value leakage assessment and pricing dispersion analysis to improve commercial outcomes.
• Tools Development & Automation: Maintain and enhance pricing tools on SharePoint and the SPI Tools Suite, including rates benchmarking and financial modeling. Participate in SIT/UAT testing, release coordination, and incremental improvements.
• Automate and Scale Workflows: Use Power Automate, Excel VBA/macros, and Python scripts to streamline recurring tasks. Where relevant, leverage Microsoft SQL Server Management Studio and Apache Spark (PySpark/Spark SQL) for distributed processing.
• Excel-Based Modeling & Reporting: Build pricing and financial models in Excel (advanced formulas, pivot tables, scenario analysis). Design dashboard-style reporting for real-time insights; integrate data via Power Query ETL and prototype analytical methods (e.g., price waterfall calculators).

Skills and attributes for success

Primary (Must-Have)   

For Data and Analytics role:

• SQL, T-SQL
• Power Query M
• Power BI
• Python, R, Pandas
• Power Automate
• Foundational statistics (distributions, variance, correlation; regression, basic forecasting, hypothesis testing, clustering, time-series forecasting)

For Pricing Tools Support role:

• Advanced Excel (Formulas, Pivot tables, VBA macros, Data integration, Pivot tables)
• SharePoint (data extraction & reporting)
• Software Development Lifecycle exposure, Agile ways of working
• Power BI (visualization and reporting)

General:

• Financial Modelling, Pricing, Deal Shaping & reporting (support role)
• Data analysis & interpretation
• Business analysis & requirements gathering
• Storytelling, insight generation
• Pricing analytics basics (WTP, win-loss analysis, price waterfall, price dispersion, dynamic pricing, value leakage)

PowerPoint Skills

• ETL (cleaning, transformation, modeling)
• Hypothesis-driven analysis and sound judgment in tool/method selection; Operates with a high degree of independence; mentors junior team members.
• Strong pursuit management, relationship management, executive presence and influencing skills.
• Strong communication, facilitation, relationship-building, presentation, and negotiation skills. High proficiency at collaborating, managing conflicting interests and dealing with ambiguity.
• Be highly flexible, adaptable, and creative.
• Be detail oriented, ensuring accuracy and precision in every task, with a strong focus on numbers and data integrity.
• Strong project management skills

Secondary (Preferred) 

• Microsoft Fabric (Dataflow Gen2, Lakehouse/Warehouse, Data Pipelines)
• Azure Synapse Analytics; broader Azure data ecosystem
• Apache Spark, PySpark, Spark SQL
• Exposure to Operationalizing ML pipelines via Azure Machine Learning
• Exposure to Machine learning libraries: scikit-learn, XGBoost, PyTorch
• Working knowledge of Visualization libraries: Matplotlib, Seaborn

Good to have (optional) 

• Power Apps; Power Automate (advanced)
• Copilot Studio; AI Builder
• Experience with SharePoint/web-based pricing tools

Qualifications for the role:

• A bachelor’s degree in a STEM field relevant to data analysis, data engineering, or data science is required. Examples include (but are not limited to) computer science, finance & accounting, statistics, data analytics, artificial intelligence, operations research, or econometrics.
• 3–6+ years of experience in data analysis, data engineering, tools development or a closely related field, ideally within a professional services environment.
• Certifications are not required. Credentials such as Azure, Microsoft Fabric, or MOS: Excel Expert are desirable but optional.
• English language fluency (oral and written).

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.