Data Analyst, Associate

Line of Service
Internal Firm Services

Industry/Sector
Not Applicable

Specialism
IFS - Operations

Management Level
Senior 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.


The Data Analyst is responsible for working with the Business teams and IT team to model the data in the organisation's core SQL database, maintain the data dictionary, document and monitor the connections to the source databases. The Data Analyst will develop business intelligence dashboards using PowerBI and Google Lookers. The Data Analyst will also be responsible for performing ETL using Alteryx, Python, or R.

The data that the Data Analyst will work with is the backbone of the organisation. This data is the basis for the firm’s management decisions. The Data Analyst will help to ensure that the data is accurate and up-to-date, and that it is presented clearly to support the management decisions.


How will you value-add?

• Model the objects in the organisation's core SQL database
  
• Maintain the data dictionary
  
• Document and monitor the connections to the source databases
  
• Ensure data quality in the data mart through the development and maintenance of exception reports
  
• Automate information retrieval from external sources
  
• Develop business intelligence dashboards using PowerBI and Google Lookers
  
• Perform ETL using Alteryx, Python, or R
  
  

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

Desired Languages (If blank, desired languages not specified)

Travel Requirements
0%

Available for Work Visa Sponsorship?
No

Government Clearance Required?
No

Job Posting End Date