Data and Analytics Manager at PricewaterhouseCoopers (PwC)

Job Description & Summary
A career in our Oracle Risk Assurance practice, within Information Technology Risk Assurance will allow you to develop and apply strategies that help clients leverage enterprise technologies so they can get a higher return on their investment, mitigate risks, streamline processes, and find operational inefficiencies. The work revolves around creative problem solving and applying innovative technologies to enable strategies that increase the value of the applications that run our client’s business, mitigate risk and find operational inefficiencies.

Our focus is on creating effective and efficient design for the most important business, security and compliance processes for our clients. We touch on aspects of application security, areas prone to fraud and financial misstatement, and streamline processes that are part of our client’s core business so they can get a higher return on this key investment. Using innovative, and proprietary technologies, we help to bridge the gap between business stakeholders, compliance functions and Information Technology teams to assist in understanding how to embrace new ways of working, while limiting their financial and operational risk profile. We use knowledge of financial system design, risk mitigation, business process design, data integrity, security and use of data analytics.


To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be a purpose-led and values-driven leader at every level. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As a Manager, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:
 

• Develop new skills outside of comfort zone.
• Act to resolve issues which prevent the team working effectively.
• Coach others, recognise their strengths, and encourage them to take ownership of their personal development.
• Analyse complex ideas or proposals and build a range of meaningful recommendations.
• Use multiple sources of information including broader stakeholder views to develop solutions and recommendations.
• Address sub-standard work or work that does not meet firm's/client's expectations.
• Use data and insights to inform conclusions and support decision-making.
• Develop a point of view on key global trends, and how they impact clients.
• Manage a variety of viewpoints to build consensus and create positive outcomes for all parties.
• Simplify complex messages, highlighting and summarising key points.
• Uphold the firm's code of ethics and business conduct.
  
   

JOB PURPOSE

At PwC, we are significantly growing our Data & Analytics (D&A) practice to meet new market demands and opportunities. We value the fact that most cutting edge market solution depend on a strong Data Analytics and Data Science capability.
Within D&A practice we have specialists in all sectors pioneering in developing solutions for client problems through the use of data analytics, tools and platforms. The team’s core proposition is to develop innovative products and services which combine the latest technologies with PwC’s deep subject matter expertise and industry knowledge.


A.  JOB PROFILE

PRINCIPAL ACCOUNTABILITIES

Job Requirements:

We are looking for motivated, enthusiastic individuals to join our team. People with the right blend of hands-on data, programming and consulting experience, a passion for innovation and an understanding of the markets in which we work. As a manager in our practice you’ll have the opportunity to develop your career whilst driving the growth of our business. As part of a market-leading D&A team, you’ll be helping new and existing clients deliver technology and data solutions to streamline their data management processes, gather insights and deliver engaging reporting tools and data visualizations as well as supporting core assurance teams. This will be on specialised projects as well as Internal and External Audit Engagements.

Job Responsibilities:

• This role involves designing CAATs to respond to audit risks, assisting in managing resources, determining data requirements, executing the data analysis and CAATs, as well as drafting and reporting of findings in written format.
• Develop analytics for all areas of the audit process (risk assessment, controls testing and outcomes testing)
• You must be able to interface with several stakeholder groups including our consulting partners, auditors, clients, and team members in other lines of service.
• Familiarity with approaches of applying data and analytics to solve questions of business strategy for clients.
• Storytelling – building storyboards and other presentations targeted at senior business audience. Could be in PowerPoint or other presentation media (videos, interactive presentations, etc)
• Ability to be able to create competitive analyses for potential products, drive appropriate approaches and develop preliminary business cases – refining them all as emergent information arises.
• Articulate and passionate verbal communicator – comfortable communicating with all of our stakeholders (partners, consultants & clients).

Knowledge and Experience

Some knowledge or experience in each of the five areas below is valuable.

• Data Storage Technologies (i.e. SQL, Oracle, NoSQL, Hadoop, MSFT Access, etc.)
• Data Manipulation and Analysis Languages (i.e. Python, R, SAS, DAX etc.)
• Data Manipulation and Analysis Software (i.e Alteryx, IDEA, ACL, Excel (Advanced))
• Visualization Technologies (i.e. D3/HTML Visualizations, Tableau/QlikView/PowerBI/etc.)
• Intermediate understanding of Auditing and Accounting concepts (i.e Risk and controls, audit process and accounting/finance data reports)
• Experience on performing data analysis on SAP, PeopleSoft, Sage systems, JD Edwards and other ERP systems would be beneficial.
• 4+ years of broad technology expertise in web-based systems architecture, service-based architecture, enterprise application architecture as well as experience managing expectations when balancing alternatives against business and financial constraints
• 4+ years of progressive hands-on technical experience as well as 3+ years of full life-cycle software development experience including leading multi discipline development teams.
• Ability to grasp a range of functional and non-functional requirements to understand the application scope to define the right architecture including solution components and the interactions
• Experience with data architecture, data modelling and relational databases.
• Experience with Hadoop, NoSQL and other Big Data technologies will be considered a plus.
• Experience of working in a consulting or assurance firm will be advantageous

Core Competencies:
Business Acumen

• Seek opportunities to add value to client account planning
• Promote new ideas and services by applying knowledge of the industry/sector to create client value
• Learn about my clients’ businesses and how they operate in the industry/marketplace
• Identify opportunities for efficiencies and take action to implement them
• Propose innovative solutions to problems

Technical capabilities

• Consult others when managing client requests that are in conflict with standards, practices and regulation
• Address sub-standard work or work which does not meet the firm’s/client’s expectations
• Build my knowledge of the firm’s service offerings related to my area of expertise
• Seek new learning opportunities to stay technical and relevant
• Follow risk management and compliance procedures
• Draw on the firm’s subject matter experts to support my work
• Use the firm’s knowledge and research tools to support the sharing of information

Global Acumen

• Show my cultural dexterity by modifying my behaviour to the environment
• Apply what I learn from personal experiences of global exposure
• Maintain a fresh perspective on global and cross-cultural issues
• Develop a perspective on key global trends, including globalisation, and how they impact on client challenges
• Expand my existing network of relationships, beyond my immediate circle
• Create opportunities for cross team collaboration by sharing my relationships
• Seek and take opportunities which expose me to other businesses, industries and markets
• Share knowledge and insight widely

Relationship

• Provide a compelling point of view to positively influence an outcome
• React positively and provide well-reasoned and self-assured responses, even when challenged
• Focus on building trusted relationships
• Manage the expectations of my clients, seeking and acting on client feedback
• Effectively engage appropriate stakeholders to support my work
• Communicate confidently in a clear, concise and articulate manner – verbally and in written form
• Actively listen and confirm my understanding by asking appropriate questions
• Use straightforward communication, in a structured way, when influencing others
• Communicate with empathy

 PERSON PROFILE
MINIMUM QUALIFICATIONS
EXPERIENCE KEY KNOWLEDGE & SKILLS

• Bachelor's Degree in Computer Science, Internal Audit, Accounting, Information Technology, Business, Engineering or any related field

There following certifications will be advantageous:

•  CISA
• CIA
•  DAMA’s CDMP
•  Alteryx Certification
• Microsoft Azure
• Minimum 3 years of progressively more responsible related work experience in data analysis, data science and business intelligence
• Involvement in app development, big data and cloud implementation projects (advantageous)
• Excellent written and communication skills
• Ability to establish and maintain interpersonal relationships
• Ability to co-ordinate the work activities of others
• Ability to resolve conflicts
• Good negotiation skills