0-2 Years Experience2+ Years Experience2020 Batch2021 Batch2022 Batch2023 BatchAnalystLatest JobsOtherPrivate Jobs

PWc is Hiring for Data Analyst Salary 6 Lakh | Apply Now

PWC is Hiring 2020-2024 Batch Pass outs Students

About Company

PricewaterhouseCoopers International Limited is a multinational professional services brand of firms, operating as partnerships under the PwC brand. It is the second-largest professional services network in the world and is considered one of the Big Four accounting firms, along with Deloitte, EY, and KPMG

PWC Data Analyst Recruitment Details

Company PWC
Post Data Analyst
Degree Bachelor’s Degree
Branch All Branch
Batch 2020/2021/2022/2023 Batch
CTC Rs 6 LPA (Expected)
Location Bangalore

Job Description

The primary objective of this position is to prepare and submit accurate and timely internal and client deliverables such as Accounts Receivable Analysis, Comprehensive Reports, Flash Reports, Invoices, and Ad-Hoc Requests using various reporting tools such as Power BI, SSRS, Excel, PowerPoint, and others. Utilize advanced knowledge in SQL Server databases and SQL scripts to update databases and create tables, views, and procedures as well as automate ETL processes via Alteryx. Assist as needed with client data loads, import summary reports, new client setup, and pre-project revenue analysis for potential clients.

 

The primary objective of this position is to prepare and submit accurate and timely internal and client deliverables such as Accounts Receivable Analysis, Comprehensive Reports, Flash Reports, Invoices, and Ad-Hoc Requests using various reporting tools such as Power BI, SSRS, Excel, PowerPoint, and others. Utilize advanced knowledge in SQL Server databases and SQL scripts to update databases and create tables, views, and procedures as well as automate ETL processes via Alteryx. Assist as needed with client data loads, import summary reports, new client setup, and pre-project revenue analysis for potential clients.

 

ESSENTIAL FUNCTIONS:

 

  • Prepares and submits accurate and timely client deliverables (Accounts Receivable Analysis, Bi-Weekly Reports, Ad-Hoc Reports)
  • Demonstrates specialized knowledge in MS Office Suite with a particular emphasis on Excel and PowerPoint including experience with charts, formulas, pivot tables, etc.
  • Demonstrates advanced knowledge and skills in SQL Server relational databases, including the ability to update and maintain databases, as well as create tables, views, and procedures using SSMS T-SQL scripts.
  • May supplement the activities of a Data Analyst I by retrieving and reviewing raw files from various file transfer methods (FTP, email, SharePoint)
  • May supplement the activities of a Data Analyst I by scrubbing raw files for pertinent information, transforming and importing data into database tables
  • Organizes large volumes of data to effectively meet critical deadlines
  • May supplement the activities of a Data Analyst I by producing daily/weekly reports as requested
  • May support the Data Analyst Manager and Senior Data Analysts on new client setups by analyzing raw data and creating database tables
  • Assists the Business Operations team in providing pre-project revenue analysis with rapid turnaround for potential clients
  • Assists the Senior Data Analyst in analyzing data to identify and communicate trends to the Operations team for all client engagements
  • Maintains multiple client projects in progress simultaneously
  • Manages Protected Health Information (PHI) on a daily basis without compromising security and integrity
  • Participates in educational programs to stay abreast of trends of the industry and changes in technology
  • Possesses the ability to communicate professionally (in all forms) with clients via email, phone, in person, etc.
  • Consistently meets or exceeds all established department standards including quality, attendance, and deadlines
  • Attends team and office meetings and scheduled events as needed
  • Possesses a cooperative and positive attitude toward clients, management, and coworkers by responding in a polite and professional manner and being a valuable team player
  • Adheres to HIPAA privacy and security standards
  • Embraces change with a positive attitude
  • Performs other duties as assigned

Who Can Apply

QUALIFICATIONS:

 

Education / Experience: 

  • BS in Computer Science or related field, or an equivalent amount of related work experience is required
  • 2.5 years of experience with SQL Server relational databases using a SQL scripting language is required
  • Expert knowledge of MS Office suite, especially PowerPoint and Excel is required
  • Experience with reporting tools such as Tableau and/or Power BI is required
  • Experience in data analysis is required
  • Experience with integration tools such as Dell Boomi and/or Informatica preferred
  • Experience with data extraction tools such as Datawatch Monarch preferred
  • Experience with ETL automation tools such as Alteryx
  • Healthcare and/or insurance industry experience preferred
  • Basic accounting and statistics knowledge preferred
  • Must have the ability to troubleshoot difficult situations and figure out a reasonable resolution
  • Ability to pay attention to details and “think outside the box”
  • Self-starter, proactive and ability to maintain focus with minimal supervision
  • Possess organizational skills and the ability to handle multiple projects with strict deadlines simultaneously
  • Strong written and oral communication skills
  • Proficient in computer and internet usage
  • Ability to establish and maintain effective working relationships that will foster teamwork

 

Working Conditions: 

  • Will work in high volume work environment that may require overtime as necessary
  • May sit for long periods of time 
  • Primarily works inside throughout the year, but some travel to client locations may be required 
  • Typing and reading on a computer
  • Communicating in person, through e-mail, telephone, and written correspondence 
  • Standing, stooping, pushing, reaching and pulling may be required

Additional Information:

  • Shift timings: Flexible to work in night shifts (US Time zone)
  • Experience Level: 2 – 4 years
  • Mode of working: Work from office
  • Line of Service: Advisory
  • Designation: Associate
  • Location: Bangalore

Other Jobs :- Click Here

2024 Batch Passouts Jobs :- Click Here

Internships :- Click Here

Govt Jobs :- Click Here

Placement Materials

TCS Study Material :- Coming Soon

Wipro Study Material :- Coming Soon

Infosys Study Material :- Coming Soon

Accenture Study Material :- Coming Soon

Apptitude Study Material :- Coming Soon

Selection Process

Round 1

In first round there will Aptitude Round where question related to check capabilities of the candidate through variety of questions like

  • Verbal reasoning questions. …
  • Verbal comprehension questions. …
  • English language questions. …
  • Questions testing abstract reasoning.

Round 2

The second round is generally a Technical Round in which all the technical related question were asked to candidate according to job role. In this generally the interviewer checks candidate technical ability the depth and breadth of candidaate knowledge

Round 3

Round 3 is a HR round in some cases TR and HR round are occur concurrently. This round is conducted by Human Resource Professional who ensures that you are the right candidate for the role


Join Whatsapp Group


Reward Ad: Please wait 5 seconds…


If You want to Know how to Apply for this Job Click Here


Click here

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button