Supervising Associate - Finance - Reporting And Data Analytics

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