Line of Service
Internal Firm Services
Industry/Sector
Not Applicable
Specialism
Managed Services
Management Level
Senior Associate
& Summary
A career in our Advisory Acceleration Centre is the natural extension of PwC's leading class global delivery capabilities. We provide premium, cost effective, high quality services that support process quality and delivery capability in support for client engagements.
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 Senior Associate, 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:
Use feedback and reflection to develop self awareness, personal strengths and address development areas.
Delegate to others to provide stretch opportunities, coaching them to deliver results.
Demonstrate critical thinking and the ability to bring order to unstructured problems.
Use a broad range of tools and techniques to extract insights from current industry or sector trends.
Review your work and that of others for quality, accuracy and relevance.
Know how and when to use tools available for a given situation and can explain the reasons for this choice.
Seek and embrace opportunities which give exposure to different situations, environments and perspectives.
Use straightforward communication, in a structured way, when influencing and connecting with others.
Able to read situations and modify behavior to build quality relationships.
Uphold the firm's code of ethics and business conduct.
Working in multiple disciplines of data management and reporting
ranging from data aggregation and structuring to data modelling and
visualization to generate relevant insights.
Job Description
Main purpose of the job and
key background information
Activities to be performed :
Creation of high end and complex BI dashboards in
Power BI and Tableau with backend data layering in
Alteryx and SQL database
Using Alteryx extensively for creation of customised and
complex data ETL workflows
Working with SQL Server 2005/2008 R2/2012 tools
Such as Management Studio, Query Analyzer, SQL
Profiler, SQL Agent, SSIS and SSRS.
Extract Transform Load ETL development using SQL
Server 2005
Developing complex queries using sub queries and
multiple joins.
Data comprehension and processing of reports, data input in the
reports based on agreed delivery schedule
Aggregation of data from different sources and representation
based on client requirements
Creation of customised dashboards and leadership reports
Coordination and communication with the client teams
Tracking of work request delivery to the clients/requestors
Review of deliverables for data accuracy, representation and
formatting
Maintenance of process documents, checklists and error logs
Documentation/design of processes and design of review
checklists
Developing and updating training materials and documents
Conduct training of processes as and when required
Requirements
These should include
essential & desirable
requirements such as:
Level of experience
Education/qualification
s
Industry experience
Technical capability
Key personal attribute
Expertise and experience in developing complex BI
dashboards using Tableau and Power BI
Core competency in advanced ETL flow development in
Alteryx
Core competency and experience in Data Analysis,
Structuring and Query Development in SQL
Hands on with MS-SQL Server 2012/2008 R2/2008/2005,
SQL Server Enterprise Manager, Transact-SQL T-SQL , MS
SQL Server Reporting Services SSRS
Ability to analyse and anticipate client requests, interpret asks and
act according to expectations
Excellent reasoning and analytical ability
Capable of designing new approaches which enhance quality and
productivity
Effective verbal and written communications skills
Self-motivated and capable of working both independently and in a
team
Self-starter with ability to multi-task and constantly reprioritize
Good interpersonal skills
Leadership skills
Education/qualifications:
B.Com/ M.Com/B Tech/M Tech/ M Sc (Maths/ Stats) or equivalent
from a premier institute
Must have 3-4 years of on the job experience of working in
Insights/ Data Visualisation/ ETL profile
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
Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not Specified
Available for Work Visa Sponsorship?
No
Government Clearance Required?
No
Job Posting End Date