Data Analyst- Supervising Associate -Secaucus, Hoboken, Jericho-Long Island, New York
Secaucus, NJ, US, 07094
Full Time Mid-level / Intermediate USD 75K - 155K
EY
EY provides consulting, assurance, tax and transaction services that help solve our client’s toughest challenges and build a better working world for all.Location: Secaucus, Hoboken, Long Island-Jericho, New York
Data Analyst – Supervising Associate
The opportunity
The Data Analyst is a member of EY’s Partnership Reporting Team, responsible for conducting the executive level partners earnings distribution process for US and Global EY Partners.
As a Supervising Associate, 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 Global 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 5 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 interact daily with executive level partners.
- Ability to work extra hours during reporting deadlines
Ideally, you’ll 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 We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The salary range for this job in most geographic locations in the US is $75,500 to $137,000. The salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $90,600 to $155,700. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options. Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll 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.- 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.
Tags: Consulting Data analysis Excel Finance SQL Testing
Perks/benefits: Career development Flex hours Flex vacation Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs