Operations and Change Management - Data Analyst Off-Cycle Internship (Jan - Jun 27)

PwC

Singapore

On-site

SGD 17,000 - 23,000

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

PwC Singapore is seeking a Data Analyst Intern to join our IT team. You will model objects in the core SQL database, maintain the data dictionary and monitor connections to source systems.

You will perform ETL using SQL, Python or R and develop BI dashboards in Power BI and Fabric to surface insights for stakeholders across the firm. The internship offers hands-on experience from data engineering to visualization and an understanding of how clean data drives business outcomes.

Qualifications

Bachelor’s degree in computer science, data science, or a related field.
Experience with data modelling and data dictionary management.
Experience with ETL tools such as Fabric, SQL, Python and R.
Experience with business intelligence tools such as PowerBI or Tableau.
Strong analytical and problem‑solving skills.
Excellent written and verbal communication skills.

Responsibilities

Data Infrastructure & Governance: Model objects within the organisation’s core SQL database to support analytical and reporting needs; Maintain the data dictionary; Document and monitor connections between the core database and upstream/downstream source systems.
ETL & Automation: Perform ETL processes using SQL, Python, or R to integrate data from internal and external sources; Automate retrieval of data from external sources.
Business Intelligence & Reporting: Develop BI dashboards in Power BI and Fabric to deliver actionable insights; Translate findings into clear reports and dashboards.
Data Quality & Anomaly Detection: Ensure data quality in the data mart; Develop exception reports; Apply predictive/statistical modelling to detect quality issues; Develop anomaly checks.

Skills

Data modelling

Data dictionary management

Analytical skills

Communication skills

Problem solving

Education

Bachelor's degree in computer science or data science

Tools

Fabric

SQL

Python

Power BI

Tableau

Job description

Line of Service

Internal Firm Services

Industry/Sector

Not Applicable

Specialism

IFS - Operations

Management Level

Intern/Trainee

Job Description & Summary

At PwC, we help clients build trust and reinvent so they can turn complexity into competitive advantage. We’re a tech-forward, people-empowered network with more than 370,000 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 www.pwc.com.

Our Firmwide Corporate Services unite to help build our competitive advantage with first class support internally. Spanning Administration, Business Development, Chairman’s 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 and query the organisation’s core SQL databases, upkeep 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 visualisation and develops an understanding of how clean, well‑presented data drives real business outcomes. 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 organisation’s core SQL database to support analytical and reporting needs.
Maintain the data dictionary to ensure accurate, up-to-date documentation of data assets.
Document and monitor connections between the core database and upstream and downstream source systems.

ETL & Automation

Perform ETL processes using SQL, Python, 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 and Fabric to 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 and maintaining exception 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 we’re looking for: