Data Analyst

About the Role

As an Associate in the Data Analyst role within Fair Employment Practices Compliance (FEPC), you will serve as part of a focused data analytics team that helps advance the Firm’s nondiscrimination and employment compliance objectives. This role will support data review, data preparation, data validation, analysis, reporting, and technical execution across employment-practice workstreams, with an emphasis on using data processing tools and systems to produce timely, accurate, complete, and clear work outputs.

Key Responsibilities

• Perform data review, validation, reconciliation, and quality checks across employment-related datasets to support EEO-related reviews, government and other external reporting, and employment-practice initiatives.
• Use Excel, Alteryx, SQL, and other data processing or reporting tools, in coordination with team standards, to collect, clean, transform, join, analyze, and document data from multiple systems and sources.
• Develop and maintain repeatable data workflows, control checks, templates, queries, documentation, and reporting routines that improve consistency, accuracy, efficiency, and auditability.
• Analyze and clearly present data and other information to identify significant trends, key issues, anomalies, risks, dependencies, and implications for compliance priorities and projects.
• Partner with IT Systems, Talent, Recruiting, Risk Management, and business stakeholders to understand source systems, data definitions, data lineage, reporting logic, and business requirements.
• Prepare data summaries, dashboards, reports, data review materials, stakeholder-ready presentations, and supporting documentation tailored to audience needs.
• Identify data quality issues, process gaps, system limitations, and opportunities for improvement; propose credible options and support resolution with appropriate stakeholders.
• Use relevant data, EY tools, approved AI tools, and other resources responsibly to improve work outcomes while maintaining accuracy, confidentiality, appropriate human review, and sound judgment.
• Maintain up-to-date knowledge of relevant data tools, reporting methods, employment compliance concepts, and EY processes, sharing key learnings appropriately with analytics team members and colleagues.
• Organize assigned analytical work to appropriately prioritize the needs of multiple internal and external stakeholders while producing complete, accurate, timely, and clear deliverables with limited supervision and in coordination with team priorities.

Requirements & Tech Stack

• Excel (including formulas, pivot tables, lookups, data validation, data modeling, and quality checks)
• Experience with macros or Power Query preferred
• Alteryx (preferred)
• SQL (preferred)
• Databases (preferred)
• Data warehouses (preferred)
• Reporting platforms (preferred)
• Other data processing and automation tools (preferred)
• Approved AI tools

Qualifications

• Bachelor’s degree, or equivalent work experience.
• Approximately 1-3 years related experience.
• Professional experience, preferably in data analytics, HR data analysis, compliance analytics, risk management, reporting operations, data systems, or related business support roles.
• Ability to analyze and clearly present data and information to identify trends, anomalies, key issues, risks, dependencies, and implications for project and compliance priorities.
• Experience developing repeatable workflows, control checks, documentation, reporting routines, data summaries, dashboards, and stakeholder-ready materials.
• Strong interpersonal and communication skills, including the ability to ask effective questions, listen carefully, build credibility with stakeholders, and translate technical information for nontechnical audiences.
• Strong data systems background, including the ability to understand data structures, source systems, joins, data lineage, field definitions, business rules, and reporting logic.
• Introductory knowledge of nondiscrimination, employment compliance, EEO-related requirements, government reporting, HR data, or related employment and labor requirements.
• Degree concentration in Information Systems, Data Analytics, Business Analytics, or Business Administration/Management is preferred.