Data Reporting Analyst

Simpson Thacher & Bartlett LLP•New York, NY

22h•$100,000 - $120,000•Hybrid

About The Position

The Data Reporting Analyst is responsible for the creation and distribution of regularly scheduled financial reports (e.g. billing, revenue, and statistical) within the Firm. This includes both scheduled and ad hoc reporting, with the goal of increased transparency and usability throughout the Firm. The Data Reporting Analyst will be required to work across all levels of Firm personnel and collaborate across administrative groups (within Accounting and outside of the department).

Requirements

Bachelor’s degree required
3 to 5 years of financial reporting experience in legal or related field required
Experience with Microsoft SSRS Report builder, SQL, Microsoft Power BI Desktop and/or other financial dashboards
Ability to effectively present information visually, verbally and in writing, tailored to a specific audience
Basic math skills: add, subtract, multiply, and divide
Working knowledge of MS Excel and other commonly used office software

Nice To Haves

Degree in Finance or Accounting preferred
Experience with 3E or other legal billing systems preferred

Responsibilities

Design and distribute monthly, quarterly and annual billing related financial reports centering on, but not limited to, billing, revenue, and various financial statistics.
Assist management with the creation and distribution of report requests as needed.
Ability to manage a large volume of reporting requests and reporting schedules.
Develop and modify reports using 3E, Microsoft SSRS Report Builder, Ideate Dashboard, Microsoft Power BI Desktop, and other reporting software.
Assist with periodic reporting to Firm management for use in the annual compensation review processes.
Design and distribute ad hoc and subscription based reporting for the Billing and Collection department, partner, clients and other stakeholders as requested
Review presentation and functionality of reports and make recommendations for improvement.
Assist with special projects, system upgrades, and testing as needed.
Ability to think critically and adapt existing tools to solve problems
Perform other duties as assigned.