Partnership Operations Data Analyst, Senior Associate

Chicago, IL - USA

Monthly Salary: $ 77000 - 132300

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Location: ClevelandAtlanta Detroit Minneapolis Tampa

At EY were all in to shape your future with confidence.

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

Title:Data Analyst Senior Associate

The opportunity

The Data Analyst is a member of EYs 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 experienceinvolving data analysis.

Bachelors 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 interact daily with executive level partners.
Ability to work extra hours during reporting deadlines

Ideally youll also have

Experience in SQL Queries and Business Objects
Ability to create Excel macros
Experience managing and leading projects involving sensitive and confidential data
Ability to work from a New York tri-state area office when needed

What we look for

We are looking for business professionals who are driven by data and motivated to solve complex problems with strong analytical and interpersonal skills.

What we offer you
At EY well develop you with future-focused skills and equip you with world-class experiences. Well empower you in a flexible environment and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learnmore.

We offer a comprehensive compensation and benefits package where youll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $64200 to $116400. The base salary range for New York City Metro Area Washington State and California (excluding Sacramento) is $77000 to $132300. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education experience knowledge skills and addition our Total Rewards package includes medical and dental coverage pension and 401(k) plans and a wide range of paid time off options.
Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external client serving roles to work together in person 40-60% of the time over the course of an engagement project or year.
Under our flexible vacation policy youll decide how much vacation time you need based on your own personal circumstances. Youll also be granted time off for designated EY Paid Holidays Winter/Summer breaks Personal/Family Care and other leaves of absence when needed to support your physical financial and emotional well-being.

Are you ready to shape your future with confidence Apply today.
EY accepts applications for this position on an on-going basis.

For those living in California please click here for additional information.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

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.

EY provides equal employment opportunities to applicants and employees without regard to race color religion age sex sexual orientation gender identity/expression pregnancy genetic informationnational origin protected veteran status disability status or any other legally protected basis including arrest and conviction records in accordance with applicable law.

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process please call 1-800-EY-HELP3 select Option 2 for candidate related inquiries then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EYs Talent Shared Services Team (TSS) or email the TSS at .

Required Experience:

Senior IC

Location: ClevelandAtlanta Detroit Minneapolis TampaAt EY were all in to shape your future with confidence.Well 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.Title:Data Analyst S...