Job Description

At EY, we're all in to shape your future with confidence.
We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Join EY and help to build a better working world.
ES- Finance FP&A: Reporting and Data Analytics Centre of Excellence
The opportunity
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

What we look for

• 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
EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations - Argentina, China, India, Philippines, Poland, Mexico, Sri Lanka and Spain - and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We'll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.

• 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.

EY | Building a better working world
EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.
Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.
EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

Skills Required