Supervising Associate - Reporting and Data Analytics

The Opportunity

The Reporting and Data Analytics (R&DA) team delivers key management and financial reporting across the firm. The successful applicant will work within a team of developers to support and build reports using Power BI and SSRS. Reports are created either from pre-prepared datasets or by generating new datasets through SQL and Power Query processes.

The successful applicant will have exposure to the broader R&DA technical team, which is responsible for the underlying reporting environment, datasets, and regular data refresh processes. The new team member will also collaborate with the Product Line teams, who are the functional, customer-facing representatives within the R&DA. The Product Line teams will gather the initial customer requirements; your role will be to work together with them to interpret and refine those functional requirements into technical specifications and, ultimately, reporting applications.

Reports are built to standard in a source-controlled environment and follow a structured development cycle. Once in production, your role will also involve supporting and troubleshooting any issues that arise with the reports.

Your Key Responsibilities

• Deliver intuitive, polished reporting solutions using Power BI, MS Report Builder, Excel, and Power Platform.
• Manage ETL processes in SQL and Power Query to ensure data is efficiently processed and stored.
• Collaborate closely with Product Line and Backend Data teams to solve problems, understand dependencies, and manage timelines.
• Translate requirement documentation into accurate work estimates and deliver in line with those estimates.
• Investigate, manage, and resolve reporting and data issues raised via the ServiceNow platform.
• Ensure report access and data security align with EY and R&DA standards.
• Manage development cycle (DEV / UAT / PRD) as reports are developed, tested, and moved into production.

What We Look For: Skills and Attributes for Success

• Advanced skills and experience with Power BI report development and proficiency in Power BI Service management.
• Strong understanding of Data Analysis Expressions (DAX).
• Knowledge of ETL processes with Power Query.
• Create SQL queries to extract or manipulate data for reporting and analysis purposes.
• Communicate effectively with technical teams to resolve issues.
• Communicate effectively with Product Line teams to ensure the impacts of complex technical scenarios are understood.
• Proficient 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 mock-ups using Excel and SQL to solve problems, address incidents, and handle data-related assignments.
• Ability to positively adapt to change in response to shifting business priorities.
• Ability to work independently with a detail-oriented, analytical, and structured work approach.
• Capability to effectively work in a virtual environment across multiple time zones.
• Fluent English skills.
• Knowledge of Power Platform tools such as Power Apps, Power Automate, and Power Pages (preferred, but not essential).
• Experience in project management; agile/scrum project management not necessary but would be beneficial.
• Knowledge of Azure DevOps would be a bonus.
• Track record or working with Visual Studio would be beneficial but not essential.
• An understanding of EY’s financial business rules and KPIs would be very welcome.
• Experience in a reporting and analysis role within EY would be an advantage.
• Knowledge of code control methodologies would be a bonus.

Experience

• 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 located in various locations across the globe, with concentrations in the US, UK, Germany, France, Poland, and India. From accountants and programmers to professionals with consulting, change management, or data science backgrounds, 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.