Data Analytics Associate: SQL, Power BI & ETL Focus

PwC; Singapore; On-site; SGD 56,000 - 89,000; Full time

Job summary

PwC Singapore is seeking a Business Analyst to support data-driven decision making by building reliable data models, ensuring data quality, and delivering analytics through dashboards and automated workflows. The role collaborates with Business and IT teams to model data in the core SQL database, maintain the data dictionary, and connect to source databases.

You will develop BI dashboards with PowerBI and perform ETL using Python, SQL, or R, contributing to accurate management reporting and

Qualifications

• Bachelor's degree in computer science, data science, or a related field.
• 1-2 years of experience with SQL and Python.
• Experience with data modelling and data dictionary management.
• Experience with ETL tools such as Python, SQL or R.
• Experience with business intelligence tools such as PowerBI.
• Strong analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Responsibilities

• Model and maintain objects in the organisation’s core SQL database to support reliable reporting and analytics
• Maintain the data dictionary
• Document, monitor, and troubleshoot data connections between source systems and the core SQL database
• Develop and maintain exception reports to identify, investigate, and resolve data quality issues in the database and source systems
• Automate information retrieval from external sources to reduce manual effort and improve system reliability
• Develop business intelligence dashboards using PowerBI
• Perform ETL using Python or SQL

Skills

SQL

Python

Data modelling

Data dictionary

PowerBI

ETL

Analytical skills

Communication

Education

Bachelor's degree in computer science/data science or related field

Tools

PowerBI

Job description

PwC Singapore is seeking a Business Analyst to support data-driven decision making by building reliable data models, ensuring data quality, and delivering analytics through dashboards and automated workflows. The role collaborates with Business and IT teams to model data in the core SQL database, maintain the data dictionary, and connect to source databases.

You will develop BI dashboards with PowerBI and perform ETL using Python, SQL, or R, contributing to accurate management reporting and