Operations and Change Management Data Analyst Off-Cycle Internship (Jan Jun 27)
Job Summary
Line of Service
Internal Firm ServicesIndustry/Sector
Not ApplicableSpecialism
IFS - OperationsManagement Level
Intern/TraineeJob Description & Summary
At PwC we help clients build trust and reinvent so they can turn complexity into competitive advantage. Were a tech-forward people-empowered network with more than 370000 people in 149 countries. Across audit and assurance tax and legal deals and consulting we help clients build accelerate and sustain momentum. Find out more at .Our Firmwide Corporate Services unite to help build our competitive advantage with first class support internally. Spanning Administration Business Development Chairmans Office Compliance Finance Human Resources Learning and Development Legal Marketing and Communications Operations and Change Management and Technology we power our lines of services to make sure all of us have the right sources services and technology to be the best we can be.
Not all of us work directly with external clients. Some of our most talented people choose to harness their skills experience expertise and service excellence within PwC. The possibilities are endless and our business landscape is changing everyday.
As a Data Analyst Intern you will work closely with the IT team to model andquerythe organisations core SQL databasesupkeep the data dictionary and document and monitor connections to source systems. Key responsibilities include performing ETL processes using SQL Python or R and developing business intelligence dashboards in Power BI and Microsoft Fabric to surface insights for stakeholders across the firm.
This role sits at the heart of how the organisation makes decisions the data curated and visualised by the intern directly informs management strategy and operational priorities. The internship offers hands-on experience from data engineering to visualisationand develops an understanding of how clean well-presented data drivesreal businessoutcomes. The ideal candidate is curious detail-oriented and eager to translate raw data into clear actionable insights.
Key Responsibilities:
Data Infrastructure & Governance
Model objects within the organisations core SQL database to support analytical and reporting needs.
Maintain the data dictionary to ensureaccurate up-to-date documentation of data assets.
Document andmonitorconnections between the core database and upstreamand downstreamsource systems.
ETL & Automation
Perform ETL processes usingSQLPython or R to integrate data from internal and external sources.
Automate the retrieval of data from external sources (e.g. APIs)to reduce manual effort and improve timeliness.
Business Intelligence & Reporting
Develop business intelligence dashboards in Power BI andFabricto deliver actionable insights to stakeholders.
Translate analytical findings and detected anomalies into clear reports and dashboards that support data quality monitoring and remediation.
Data Quality & Anomaly Detection
Ensure data quality within the data mart by developing andmaintainingexception reports.
Apply predictive and statistical modelling techniques to detect data quality issues such as unexpected volume changes missing data patterns and outlier values.
Develop rule-based and model-driven anomaly detection checks using historical data as a baseline to flag deviations for review.
What were looking for:
Bachelors degree in computer science data science or a related field
Experience with data modelling and data dictionary management
Experience with ETL tools such asFabric SQL Python and R
Experience with business intelligence tools such asPowerBIor Tableau
Strong analytical and problem-solving skills
Excellent written and verbal communication skills
Application Notes
Pleaseindicateyour first-choice role and where applicable a second-choice role based on your skills interests and career aspirations.
Only shortlisted candidates will be notified due to the high volume of applications.
Kindly upload both your resume and academic transcript/degree audit in PDF format
There have been reports of scammers impersonating PwC HR professionals contacting individuals about fraudulent job opportunities using non-PwC domain email addresses and an overseas number. Please note that genuine communications from our HR team will only come from @ email addresses.
Education (if blank degree and/or field of study not specified)
Degrees/Field of Study required:Degrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
Optional Skills
Accepting Feedback Active Listening Communication Emotional Regulation Empathy Inclusion Intellectual Curiosity Optimism Teamwork Well BeingDesired Languages (If blank desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship
NoGovernment Clearance Required
NoJob Posting End Date
Required Experience:
Intern
About Company
At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 155 countries with over 284,000 people who are committed to delivering quality in assurance, advisory and tax services. Find out more and tell us what matters to you by vis ... View more