AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
All Filters
1733 Ernst & Young Jobs
Supervising Associate-Reporting and Data Analytics
Ernst & Young
posted 19hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Job Title Data Analyst - Delivery and Analytics
Function Finance
Sub-Function Reporting & Data Analytics - FP&A
Level Supervising Associate
Duration Permanent
The Reporting and Analytics (R&A) delivers key management and financial reporting across the firm. The successful applicant will work within the R&A s Delivery Team which maintains the reporting warehouse and associated processes. Activities range from end-to-end development and maintenance of the reports, writing SQL stored procedures for processes and reports, being a connection point between the Product Line Lead and the technical and Quality Assurance (QA) teams. The BDA translates functional requirements into detailed technical specifications, supporting the development cycle and drives functional validation until enhancements and resolved defects are ready to be moved into Production, acting as a to implementing changes in the design and architecture of our data warehouse. The DMI team has an important role working with and supporting the R&A report development team.
Additionally, the role provides support for data consumers, reviews regular data updates, conducts functional and data-related validations and sends out communications when necessary. Data consumers are mainly R&DA teams as well as some external consumers in other functions or organizational entities. The Backend product line is focused on sourcing and integrating different data sources, organizing them in a generic, business oriented and consumable data model and applying EY s business rules as well as managing and maintaining the core reporting structures and supporting tools. All Essentials tools, additional supplemental reports, analytics tools as well as some external recipients will be supported by this product line. Further integration and optimization of the reporting backend is planned, as well as moving it to a modern technology stack. The main responsibility is to manage the continuous enhancement and defect management of the backend based on requirements from the different data consumers or upstream changes as well as to ensure smooth operations and good & timely consumer support.
The Reporting and Data Analytics sub-function (R&DA) is a leading-edge organization providing powerful analytical solutions to evolve our ability to provide insights to the business. The R&DA ensures that EY is keeping pace with the many analytical and technological changes taking place in the business world, evolving our tools and the way we look at information, to best support the client serving as well as corporate responsibilities in a rapidly changing business world.
Your key responsibilities
- Turn data needs and business rules into requirements (user stories) including detailed acceptance criteria ensuring quality, consistency as well as generic and consumable solutions that all data consumers can benefit from
- Configure and maintain database servers and processes in liaison with IT teams
- Monitor Database health and performance and analyze and fine tuning of processes/SQL coding. Assist developers with query tuning and schema refinement
- Perform scheduled maintenance and support release deployment activities after hours
- Create SSIS packages Develop, maintain, schedule. Develop reports for the business team as well as for administrative purposes
- Analyze, solve, and correct issues in real time. Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Advanced skills and experience with Power BI Report Development (Pro License) and Proficient in Power BI Service Management.
- Strong understanding of Data Analysis Expressions (DAX).
- Advanced knowledge of ETL processes with Power Query.
- Experience in building complex Power BI dashboards and expert in visualization.
- Design and create SQL queries, interpret advance SQL queries and extract or manipulate data for reporting and analysis purposes.
- Advanced proficiency in MS Excel and Excel 365 complex functions
- Knowledge in Power Platform tool such as Power Apps, Power Automate and Power Pages.
- Validate enhancements as well as resolved defects from a functional and data accuracy point of view
- Collaborate closely with Product Line and Backend Product Line Leads and their teams to gather prioritized requirements and data issues, eliciting detailed information to assist the technical team in executing the planned tasks
- Work closely with QA team to define validation criteria and activities and helps prioritizing defects ensuring high quality of deliverables
- Support R&DA internal and external User Acceptance Test (UAT) activities
- Build a relationship with upstream data providers (primarily CDW) regarding data quality and batch SLAs as well as interfaces to planning tools
- Work hand in hand with the product line teams and align timelines and dependencies with their roadmap
- Stay up to date on technical innovation, new product offerings of our key vendors and regularly collect feedback from data consumers
Skills and attributes for success
- Experience in project management - agile/scrum project management would be beneficial
- Good communication with the ability to flex between functional and technical conversations
- Ability to effectively communicate and influence IT teams to solve data problems and support functional design
- Understanding of EY s key source systems (e.g. Mercury, Dynamics, P&B, GRP), CDW and data flows as well as IT s key processes and rules
- Understanding of the EY s financial business rules, KPIs and know/learn how these concepts are applied technically and what the key dependencies are
- Experience with requirement documentation
- Adept in data and root cause analysis as well as data validation using SQL, Power BI and Excel tools
- Skilled in creating and supplying data samples or mockups using Excel and SQL scripts to meet business needs, address incidents, and handle various data-related assignments
- Solution oriented and problem solving skills
- Ability to adapt and change positively in response to changing business priorities
- Ability to work independently with a mindset to stay ahead of the technical team needs
- Detail oriented, analytical, structural work approach as well as emphasis on quality and consistency
- Fluent English skills
- Project management experience or familiarity working in larger, multidisciplinary teams
- Technical oriented personality with experience in querying data and working closely with functional as well as technical teams at the same time
- Global and inclusive mindset
- Customer service, solution and quality-oriented person
- Flexibility in approaching different user groups/profiles
- Ability to prioritize workload and deliver outputs within strict deadlines
- Some experience in a reporting and analysis role within EY would be an advantage
- Capability to effectively work in a virtual environment across multiple time zones
- Ability to work autonomously based on direction and supervision from a senior BA
- Some understanding of data sources, structures, data model as well as technical solutions and all business rules applied
- Appreciation and respect of varying cultures - both corporate and geographical
- Team player
Experience
To qualify for the role you must have
- 5 or more years of experience in a finance or technical department
- Some relevant business experience within EY would be beneficial
- High motivation to learn from your experienced colleagues
What we offer
The R&DA sub-function is a dynamic and truly global delivery network. We support customers in all EY locations and across many functions and Service Lines. R&DA colleagues are in various locations across the Globe with concentration in US, UK, Germany, France, Poland and India. From accountants and programmers to people with consulting, change management or data scientist background, we offer a wide variety of fulfilling career opportunities that span various disciplines. In the R&DA, you will collaborate with EY teams on exciting projects and work with well-known brands and technologies.
- Continuous learning You ll develop the mindset and skills to navigate whatever comes next.
- Success as defined by you We ll provide the tools and flexibility, so you can make a meaningful impact, your way.
- Transformative leadership We ll give you the insights, coaching and confidence to be the leader the world needs.
- Diverse and inclusive culture You ll be embraced for who you are and empowered to use your voice to help others find theirs.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Supervising Associate roles with real interview advice
Top Ernst & Young Supervising Associate Interview Questions
Q1. 1. What is Virtual DOM? How does it work & Its algorithm? 2. React component life cycle in detail? 3. Higher-order components? 4. Basic ... read more
asked in
Senior Consultant interview
Q2. Covid Vaccination Distribution Problem As the Government ramps up vaccination drives to combat the second wave of Covid-19, you are tasked ... read more
asked in
React Developer interview
Q3. Risk management experience and audit work experience?
asked in
Senior Consultant interview
What people at Ernst & Young are saying
Rating based on 40 Supervising Associate
reviews
Anonymous · IT & Information Security
in Kochi
Likes
Flexible work hours , company ethics , decent salary growth, professionals to work with, opportunities for self development and learning, job security , cross training and development if you wish.
- Salary - Excellent
+6 more
Dislikes
Not much exposure to higher management. Strict compliance and access policies. After a point of time you won't be able to see future path.
Supervising Associate salary at Ernst & Young
reported by
419
employees
with 7-15
years exp.
₹10
L/yr - ₹42.1
L/yr
9%
more
than the average Supervising Associate Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10.8k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Ernst & Young Benefits
View more benefits
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Amazon
Compare
Wipro
Compare
Capgemini
Compare
IBM
Compare
Compare
Microsoft Corporation
Compare
Infosys
Compare
KPMG India
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Similar Jobs for you
Ernst & Young Kochi Office Locations
Kochi Office
Ernst & Young, 9th Floor, ABAD Nucleus,, NH - 49, Maradu
Kochi
Kerala 682304
Kerala 682304
Kochi Office
5th Floor, Software Development Block
Athulya IT Complex, Infopark
Kusmagiri
Kakkanad
Kochi
Kochi
682030
682030
TC-CS-Cyber Detection and Response-Cyber Threat Intelligence-Staff
0-6 Yrs
Kochi
Share an Interview