Senior Analyst, Workforce Analytics

Orrick Herrington & Sutcliffe LLP•New York, NY

2d•Hybrid

About The Position

Orrick is hiring a Senior Analyst, Workforce Analytics for its New York office. The role provides reporting, data management, visualization, and analytical support across the Firm’s HR programs and technology environment. It is responsible for accurate and timely workforce reporting, including business-critical and regulatory requirements, and for helping develop a more consistent and effective approach to people analytics. The Senior Analyst works with HR leaders, Firm leadership, attorneys, professional staff, and business stakeholders to analyze workforce information, identify trends and risks, and provide clear information that supports decision-making. The role goes beyond extracting and presenting data: it interprets findings, identifies the story behind the numbers, and communicates meaningful insights to appropriate audiences. The successful candidate will maintain a reliable, well-controlled workforce reporting function while helping improve how workforce information is analyzed, reported, and used. This requires strong technical skills, sound judgment, practical problem-solving, and the ability to communicate complex workforce data clearly.

Requirements

Bachelor’s degree in HR, business, analytics, information systems, data management, or a related field, or equivalent relevant experience.
At least five years of progressively responsible experience in HR reporting, workforce analytics, business intelligence, HRIS, or a related analytical function.
Experience supporting an enterprise HCM, payroll, or workforce management environment.
Strong SQL or comparable query skills and advanced Excel skills.
Experience developing reports and dashboards using Power BI or a comparable business intelligence platform.
Strong analytical and problem-solving skills, including the ability to interpret data, identify meaningful insights, and communicate the story behind the numbers.
Excellent organizational, written, verbal, and consultative skills, with the ability to manage competing priorities and recurring deadlines.
Sound judgment and discretion in handling confidential and sensitive workforce information.

Nice To Haves

PeopleSoft PSQuery, SQR, Component Interface, or similar reporting tools.
Power BI data modeling, DAX, Power Query, workspace governance, or row-level security.
Professional liability, state bar, regulatory, audit, payroll, benefits, or other law-firm reporting requirements.
HR technology transformation, report rationalization, data governance, or self-service reporting experience.
Experience preparing workforce analyses or presentations for senior leadership or Boards.
Experience in a law firm, professional services organization, or similarly complex professional environment.

Responsibilities

Manage recurring and ad hoc workforce reporting, ensuring accuracy, timeliness, confidentiality, and appropriate delivery.
Develop, maintain, and troubleshoot reports, data extracts, and dashboards using PeopleSoft HCM, UKG, SQL, Excel, Power BI, and other relevant systems.
Integrate and reconcile workforce information from multiple HR systems and investigate data discrepancies or reporting issues.
Lead or support professional liability insurance, state bar, regulatory, audit, client, and other Firm reporting and filing requirements, working with Risk Management and other stakeholders as appropriate.
Document report logic, data sources, definitions, processes, controls, and filing requirements to support continuity and auditability.
Analyze workforce data in areas including headcount, recruiting, turnover, mobility, leave, workforce composition, learning, performance, employee relations, immigration, compensation, and inclusion.
Interpret data to identify trends, patterns, risks, and underlying drivers, and translate findings into insights, recommendations, and clear narratives for HR and Firm leadership.
Prepare executive-ready reports, presentations, and analyses, including materials for senior leadership and the Board as appropriate.
Review and rationalize the Firm’s reporting portfolio, identifying opportunities to consolidate, automate, redesign, convert to dashboards, or retire reports.
Develop and maintain Power BI or comparable dashboards and support secure, well-governed self-service reporting.
Establish consistent reporting standards, metric definitions, data ownership, validation controls, and documentation.
Partner with HR, Risk Management, Finance, IT, and other Firm functions on reporting needs, HR technology implementations, system upgrades, integrations, and data conversions.
Advise report users and stakeholders on data definitions, appropriate use, confidentiality, and available reporting solutions.
Evaluate and use emerging technologies, including artificial intelligence, automation, and advanced analytics, to improve workforce reporting, data quality, self-service, and insight generation.

Benefits

Elective medical, dental, vision, and life insurance benefits.
Mental well-being programs.
Child, family, elder, and pet care benefits.
Short- and long-term disability benefits.
Parental leave benefits.
Health savings account contributions with applicable medical plans.
Flexible spending accounts.
401(k) program.
Paid Time Off program.
Paid holidays.
Potential annual discretionary merit bonus based on Firm and individual performance.