Partnership Operations Data Analyst, Senior Associate

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.

 

Partnership Operations Data Analyst – Senior Associate

 

The opportunity

The Partnership Operations Data Analyst is a member of EY’s Partnership Reporting Team, responsible for conducting the executive level partner/principal earnings distribution process for US and Global EY Partners.

 

As a Senior Associate on our team, you will be responsible for overseeing financial reporting and analysis on partner data, such as headcount, organization, and compensation results. Your role will require frequent interaction with executive partners of the firm. You will maintain our partnership database by manipulating, loading, and validating data from various internal environments for the eventual use in year-end reporting of partner earnings data to the executive board. By analyzing data, you will uncover issues, determine root causes, and recommend corrections to management. You will also create and test complex reports to meet user specifications.

 

Your key responsibilities

• Manage and organize partner earnings and organizational changes.

• Assist in developing enhancements, functionality, testing and administration of the Partnership Allocation Recommendation System (PARS).
• Assist in adhoc reporting and Partner Earnings process
• Help create earnings forecast (utilizing data from other areas within finance) to determine the earnings pool allocated to partners.
• Identify any ongoing issues that affect financial reporting.
• Prepare results of analytical review and communicate findings verbally or via email to executive leaders of the firm.
• Interpret requests for ad hoc reports or financial information and consult with internal and external EY personnel to verify or provide information.
• Communicate with external contacts and internal personnel, to resolve open issues.
• Consult and train other members of the staff on reporting and analysis tools, as appropriate.

• Become familiar with Partner and firm data structures and databases and begin to develop proficiency in analyzing data elements.

• Analyze operating results to determine overall practice profitability. Understand how changes in the firm and/or structure will impact reporting and operating results
• Assist in the development and/or updating of complex financial models in Excel. Analyze data results and communicate them to management
• Manipulate PowerPoint presentations for management. Prepare information to be included in external reporting.
• Prepare complex financial reporting for internal client management.

• Responsible for maintaining back up files and ensure file organization.
• Develop and enhance new and existing procedures to ensure efficiencies.

 

Skills and attributes for success 

This role will require you to leverage your technical expertise and communication skills to solve complex problems and articulate solutions. You will constantly communicate verbally and in writing, with various team members and leaders throughout the organization in a concise and clear way. You will be expected to exhibit a can-do attitude, approach changes with an open mind, and demonstrate initiative, commitment, and drive. 

 

To qualify for the role, you must have

• Minimum 2-3 years of related business, information systems or related experience involving data analysis.

• Bachelor's degree in Business, Information Systems, or related degree or equivalent work experience

• Advanced knowledge of MS Excel to include strong experience with formulas, V lookup and Pivot tables
• Knowledge of MS Access with experience using queries to extract data
• Basic knowledge of PowerPoint
• Strong analytical and problem-solving skills and delegation skills
• Strong leadership skills
• Demonstrated poise and confidence when interacting with top management
• Excellent written and verbal communication skills to in