Generate a McCoy IQ challenge in 30 seconds.
See how candidates think and approach the work this role demands, before the phone screen. We'll build a video challenge from this posting, and you can edit or share it before it goes live.
Key details
Job Description
Line of Service
Internal Firm ServicesIndustry/Sector
Not ApplicableSpecialism
IFS - OperationsManagement Level
AssociateJob 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)
Degrees/Field of Study required:Degrees/Field of Study preferred: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?
NoGovernment Clearance Required?
NoJob Posting End Date
