Business Analyst, Associate

Internal Firm Services

Not Applicable

IFS - Operations

Associate

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 

 

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}

0%

No

No