Data Analytics Internship: ETL, Dashboards & Insights

PwC Singapore; Singapore; On-site; SGD 20,088 - 29,016; Full time

Job summary

PwC Singapore is seeking an Intern/Trainee in Internal Firm Services (IFS - Operations) to support data analytics and reporting initiatives. You will model objects in the core SQL database, maintain data dictionaries, and document data flows with internal teams across the firm.

You will perform ETL using SQL, Python, or R, build Power BI dashboards, and translate findings into clear reports. Strong analytical and communication skills are essential for this role in a fast-paced environment.

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 Power BI or Tableau.
• Strong analytical and problem‑solving skills.
• Excellent written and verbal communication skills.

Responsibilities

• 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.
• 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.
• Develop business intelligence dashboards in Power BI and Microsoft 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.
• 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.

Skills

Data modeling

Data dictionary management

Analytical skills

Problem solving

Written & verbal communication

Education

Bachelor's degree in Computer Science or Data Science or related field

Tools

Fabric

SQL

Python

R

Power BI

Tableau

Job description

PwC Singapore is seeking an Intern/Trainee in Internal Firm Services (IFS - Operations) to support data analytics and reporting initiatives. You will model objects in the core SQL database, maintain data dictionaries, and document data flows with internal teams across the firm.

You will perform ETL using SQL, Python, or R, build Power BI dashboards, and translate findings into clear reports. Strong analytical and communication skills are essential for this role in a fast-paced environment.