What are the responsibilities and job description for the Data Reporting Analyst position at Simpson Thacher & Bartlett LLP?
Job Summary & Objectives
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 Financial 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).
Essential Job Duties & Responsibilities
Required
SKILLS AND EXPERIENCE
Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
The worker is not substantially exposed to adverse environmental conditions as in typical office or administrative work (normal light, air and space in the work environment)
Salary Information
NY Only: The estimated base salary range for this position is $80,000 to $95,000 at the time of posting.
The actual salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location in which the applicant lives and/or from which they will be performing the job. This role is exempt meaning it is not overtime pay eligible.
Privacy Notice
For information about how Simpson Thacher & Bartlett LLP collects and processes your personal information, please refer to our Privacy Notice available at https://www.stblaw.com/other/privacy-notice.
Simpson Thacher & Bartlett is committed to a collegial work environment in which all individuals are treated with respect and dignity. The Firm prohibits discrimination or harassment based upon race, color, religion, gender, gender identity or expression, age, national origin, citizenship status, disability, marital or partnership status, sexual orientation, veteran’s status or any other legally protected status. This Policy pertains to every aspect of an individual’s relationship with the Firm, including but not limited to recruitment, hiring, compensation, benefits, training and development, promotion, transfer, discipline, termination, and all other privileges, terms and conditions of employment.
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 Financial 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).
Essential Job Duties & 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.
Required
- Bachelor’s degree required
- Degree in Finance or Accounting preferred
SKILLS AND EXPERIENCE
- 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
- Experience with 3E or other legal billing systems preferred
Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
- Sitting: Remaining in the seated position, particularly for sustained periods of time
- Walking: Moving about on foot to accomplish tasks, particularly for long distances or moving from one work site to another
- Climbing: Ascending or descending ladders, stairs, ramps using feet and legs or hands and arms
- Lifting: Raising objects from a lower to a higher position or moving objects horizontally
- Carrying: Transporting an object, usually holding it in the hands or arms, or on the shoulder
- Pulling/Pushing: Using upper extremities to exert steady force upon an object so that the object moves toward or away from the force
- Bending/Stooping/Kneeling/Crouching: Bending body downward and forward by bending legs and spine, or by bending legs at knees
- Reaching: Extending hand(s) and arm(s) in any direction
The worker is not substantially exposed to adverse environmental conditions as in typical office or administrative work (normal light, air and space in the work environment)
Salary Information
NY Only: The estimated base salary range for this position is $80,000 to $95,000 at the time of posting.
The actual salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location in which the applicant lives and/or from which they will be performing the job. This role is exempt meaning it is not overtime pay eligible.
Privacy Notice
For information about how Simpson Thacher & Bartlett LLP collects and processes your personal information, please refer to our Privacy Notice available at https://www.stblaw.com/other/privacy-notice.
Simpson Thacher & Bartlett is committed to a collegial work environment in which all individuals are treated with respect and dignity. The Firm prohibits discrimination or harassment based upon race, color, religion, gender, gender identity or expression, age, national origin, citizenship status, disability, marital or partnership status, sexual orientation, veteran’s status or any other legally protected status. This Policy pertains to every aspect of an individual’s relationship with the Firm, including but not limited to recruitment, hiring, compensation, benefits, training and development, promotion, transfer, discipline, termination, and all other privileges, terms and conditions of employment.
Salary : $80,000 - $95,000
