Community

Home >

Jobs >

GCR UK - Advanced Analyst

Karnataka, India (On-site)

GCR UK - Advanced Analyst

4 Months ago • 1-2 Years • Data Analyst • Undisclosed

About the job

6 skills required for this role

Add these skills to join the top 1% applicants for this job

python

sql

microsoft-excel

excel

pivot-tables

cross-functional

Job Description

This role involves data wrangling, cleansing, and optimizing data for analysis. You'll be using SQL, ETL tools, and advanced Excel skills to prepare data for various business applications. Strong analytical skills and experience in data manipulation are essential.

Must have:

Data Wrangling
Advanced Excel
SQL Proficiency
ETL Tools

Good to have:

VBA Knowledge
Python Experience
Accountancy/Finance
Data Visualization

Perks:

Global Scale
Inclusive Culture

About the job

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Job Description:

As a data specialist, you will be responsible for performing a variety of data handling tasks to ensure the accuracy, availability, and usability of data across the organization. You will work closely with cross-functional teams to gather, cleanse, optimize, organize, and transform data into standard formats that meet the needs of our systems and team members.

Experience / qualifications:

1-2 years of experience in data wrangling or a similar discipline.

Advanced proficiency in Microsoft Excel, encompassing functions, data queries, and pivot tables.

Exceptional analytical abilities and meticulous attention to detail.

Proficiency in SQL (Structured Query Language) and a working knowledge of various ETL (extract, transform and load) tools and techniques.

Capability to operate both independently and collaboratively.

Effective communication and interpersonal skills.

Knowledge of VBA and Python for data manipulation.

Prior experience in the accountancy/finance domain would be an added advantage.

Key responsibilities:

Utilize data wrangling techniques to clean and prepare data for analysis.

Gather data from multiple sources and ensure its quality and integrity.

Optimize and organize data to enhance data retrieval and processing.

Transform data into required formats for various business applications.

Develop and maintain SQL queries for data extraction, transformation, and loading (ETL).

Utilize ETL tools and techniques to work efficiently with large datasets.

Employ advanced Microsoft Excel functions, data queries, and pivot tables to analyze data.

Collaborate with team members to understand data requirements and deliver solutions.

Document data wrangling procedures and contribute to the development of best practices.

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%