Pricing Operations Analyst: AFAs, Billing & Data

Ropes & Gray LLP; New York (NY); Hybrid; USD 84,000 - 128,000; Full time

Job summary

Ropes & Gray LLP is seeking a Pricing Operations Analyst to manage AFAs, billing data, and pricing data within the 3E system. The role involves collaborating with clients and internal teams to implement pricing strategies and ensure accurate, timely invoices.

Candidates should have a finance or accounting background, strong Excel skills, and experience with SQL. This hybrid role supports on-site collaboration while allowing flexibility to meet deadlines in a fast-paced environment.

Qualifications

• Bachelor's degree or higher in accounting, finance or business administration.
• Experience with financial database software, particularly those used in the professional services industry is required. Knowledge of 3e a plus.
• Must have two or more years of experience with working with sensitive financial data and reporting within a law firm or service industry.
• Demonstrated expertise with MS Excel, including advanced features such as pivot tables, VLOOKUP functionality, filtering, graphs and advanced formulas.
• Demonstrated excellence in both written and verbal communication skills is required.
• Superior customer service focus and a demonstrated ability to work in challenging, time-sensitive and dynamic environment.
• Must be a team player with strong interpersonal skills and a commitment to a proactive, collaborative environment.
• Experience and interest in extracting and reporting of data using standard query language (SQL) is highly desired.
• Strong analytical and critical thinking skills.
• Requires a strong work ethic; ability to quickly adapt to shifting priorities, capable of carrying out routine, everyday tasks with limited direction/supervision.
• Ability to work outside of established business hours and adjust personal schedule to meet deadlines is required.

Responsibilities

• Troubleshoot fee execution issues through thoughtful data analysis and understanding of firm systems.
• Collaborate with internal and external clients on execution of fee agreements to meet multiple team goals.
• Understand alternative fee arrangement types and systems to advise and maintain best practices of executing agreed upon AFAs.
• Administration of approved alternative fee arrangements in our accounting system (3E) to ensure accurate and timely billing while meeting firm standards.
• Monitoring and triaging incoming requests and questions from centralized team mailbox.
• Design, build, and implement tools and process to better control and maintenance of AFAs.
• Review new matter openings and ensure approved pricing is applied in accounting system timely and accurately.
• Analyze firm portfolio of AFAs to drive decisions on firm approval of AFAs.
• Advise on opportunities to improve data and processes to reduce configuration time and prevent fee losses.
• Assist with the yearly price renewal process by reviewing current AFAs and auditing terms for accuracy.

Skills

Excel Pivot Tables

VLOOKUP

Data Analysis

SQL Knowledge

Communication Skills

Team Player

Time Management

Education

Bachelor's degree in accounting, finance or business administration

Tools

3E (Accounting system)

Job description

Ropes & Gray LLP is seeking a Pricing Operations Analyst to manage AFAs, billing data, and pricing data within the 3E system. The role involves collaborating with clients and internal teams to implement pricing strategies and ensure accurate, timely invoices.

Candidates should have a finance or accounting background, strong Excel skills, and experience with SQL. This hybrid role supports on-site collaboration while allowing flexibility to meet deadlines in a fast-paced environment.