Business Analyst, Associate

PricewaterhouseCoopers GHRS Pte Ltd; 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

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

Required Skills

• 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

Optional Skills

• 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

Travel Requirements

0%

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.