Data Analyst - Enterprise Reporting & Analytics

Management Level Senior Associate Job Description & Summary

At PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights, enabling informed decision-making and driving business growth. In data engineering at PwC, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis.

You will be responsible for developing and implementing data pipelines, data integration, and data transformation solutions. Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality.

Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow. Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:
Respond effectively to the diverse perspectives, needs, and feelings of others. Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems. Use critical thinking to break down complex concepts. Understand the broader objectives of your project or role and how your work fits into the overall strategy. Develop a deeper understanding of the business context and how it is changing.

Use reflection to develop self awareness, enhance strengths and address development areas. Interpret data to inform insights and recommendations. Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.

Key Responsibilities:

Enterprise Reporting & Business Intelligence Design, develop, and maintain enterprise reports, dashboards, and analytical solutions. Translate business requirements and reporting needs into effective analytical solutions. Develop reporting solutions using Microsoft Power BI and associated technologies. Develop reusable reporting datasets and semantic models. Define and implement appropriate KPIs, metrics, calculations, and business rules. Ensure reports are accurate, performant, user-friendly, and aligned with enterprise reporting standards.

Support the rationalisation and modernisation of existing reporting solutions as part of the organisation's data platform transformation. Data Analysis & SQL Analyse complex datasets to identify trends, patterns, anomalies, and business insights. Develop complex SQL queries to extract, transform, validate, and analyse data. Perform data profiling, reconciliation, and validation across source and target systems. Investigate data quality issues and collaborate with Data Engineers to identify and resolve root causes.

Develop analytical datasets required to support enterprise reporting and decision-making. Ensure analytical outputs are based on well-understood and appropriately governed data. Databricks & Lakehouse Analytics Work with curated data within the organisation's Databricks Lakehouse environment. Develop a practical understanding of the Lakehouse architecture and the role of Bronze, Silver, and Gold data layers. Consume and analyse data stored in Delta Lake and other supported data formats.

Collaborate with Data Engineers to define data requirements for reporting and analytics. Participate in the migration of legacy reporting…