Business Analyst, Associate

PwC; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

PwC Singapore is seeking a Business Analyst to join the Internal Firm Services team. You will model data in the core SQL database, maintain the data dictionary, and monitor data connections across source systems.

The role involves developing BI dashboards with PowerBI and performing ETL using Python, SQL or R to support data-driven decision making. This position emphasises collaboration with Business and IT teams to ensure data quality, reliability, and timely delivery of analytics that guide

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.

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

Analytical thinking

Problem solving

Communication skills

Education

Bachelor's degree in computer science or data science

Tools

PowerBI

Python

SQL

R

Job description

Line of Service

Internal Firm Services

Industry/Sector

Not Applicable

Specialism

IFS - Operations

Management Level

Associate

Job Description & Summary

We believe that challenges are better solved together. That's why you'll join a diverse, global community of solvers - an unexpected mix of people that come together to build trust in society and solve important problems. With us, you are encouraged to lead with your heart and values, and where your unique skills are developed and put to work in unexpected and exciting ways, superpowered by technology.

Firmwide Corporate Services

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.

This role supports the organisation’s data-driven decision-making by maintaining reliable data models, strengthening data quality controls, and delivering clear analytics through dashboards and automated data workflows.

The Business Analyst works with Business and IT teams to model data in the organisation’s core SQL database, maintain the data dictionary, and document and monitor connections to source databases. The role also develops business intelligence dashboards using Power BI and performs ETL using Python, R, or SQL.

The data managed by the Business Analyst is core to the organisation’s operations and supports management decision-making. The Business Analyst helps ensure this data is accurate, up to date, and presented clearly so stakeholders can make informed decisions with confidence.

Key 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

About you

• 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

Education (if blank, degree and/or field of study not specified)

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

• Accepting Feedback
• Accepting Feedback
• Active Listening
• Agile Methodology
• AI Fluency
• AI-Human Collaboration
• Business Case Development
• Business Process Improvement
• Change Control Processes
• Communication
• Costing
• Digital Tooling
• Emotional Regulation
• Empathy
• Inclusion
• Intellectual Curiosity
• IT Project Lifecycle
• Kanban (Project Management)
• Optimism
• Plan of Action and Milestones (POA&M)
• Process Mapping
• Process Standardization
• Program Management
• Project Budgeting
• Project Coordination {+ 21 more}

Desired Languages

(If blank, desired languages not specified)

Travel Requirements

0%

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No