Financial Data Specialist

Wiley Rein LLP; Washington (District of Columbia); On-site; USD 65,000 - 80,000; Full time

Benefits offered by this job

Flexible work program

Job summary

Wiley Rein LLP in Washington, DC is seeking a Financial Data Specialist to lead the month-end close and perform financial analysis for Alternative Fee Arrangements and pricing requests. The role supports the Director of Pricing and Analytics and collaborates with the Accounting team on ad hoc projects.

The position offers a flexible work program and requires strong Excel, SQL, and financial modeling skills to optimize pricing strategies and reporting.

Qualifications

• College coursework in Accounting, Finance or Business Administration desired.
• 2+ years of prior experience as financial analyst in a law firm preferred.
• Experience with SQL, Power BI, or Python is a plus.

Responsibilities

• Lead month end close and run month end reporting.
• Perform financial analyses for AFA requests and pricing.
• Assist with pricing functions, including RFP submissions.
• Develop and run SQL queries for daily finance reporting.
• Support training and presentations for finance team.
• Coordinate finance group meetings and model pricing scenarios.

Skills

Advanced Excel

Financial analysis

SQL

Power BI

Python

Communication

Confidentiality

Education

College coursework in Accounting/Finance

Tools

SQL

Power BI

Python

MS Excel

Job description

Wiley, a leading Washington, DC law firm, has an opening for a Financial Data Specialist postion to support our Accounting and Finace Department. The Financial Data Specialist will focus on two areas of expertise: being the lead on the month end close process, as well as performing financial analysis for Alternative Fee Arrangement and other pricing requests. This role will also assist in compiling data as needed for various firm projects and will assist the Director of Pricing and Analytics in ad hoc requests and special projects.

This position is eligible to participate in the firm’s flexible work program.

RESPONSIBILITIES/ESSENTIAL FUNCTIONS:

• Work with other Accounting team members in performing month end close
• Run and update month end reporting
• Run financial analyses and support attorneys in their Alternative Fee Arrangement (AFA) requests
• Assist with other pricing functions, including RFP submissions
• Function as new technology implementation assistant for various finance and pricing tools
• Scout legal finance industry tech news and tools for best practices
• Investigate and analyze monthly trends in Key Statistics to Director and CFO
• Author SQL queries for all aspects of daily finance reporting
• Assist with finance training and presentations
• Coordinate Practice Group and other finance group meetings
• Support financial modeling, cost management, and process improvements
• Develop pricing models, including ROI and risk analysis
• Complete ad hoc attorney financial requests and analysis for the P&A team as needed

KNOWLEDGE, SKILLS, AND ABILITIES:

• Ability to communicate professionally and effectively, both in oral and written form
• Ability to multi-task, prioritize/coordinate deadlines, and track progress of tasks
• Ability to organize workflow and use time efficiently
• Ability to demonstrate attention to detail and accuracy
• Must maintain confidentiality of work-related information and materials
• Must establish and maintain effective working relationships in or out of a team environment
• Resourceful problem solving and ability to create and implement effective procedures
• Advanced PC skills are required, including expert proficiency with Microsoft Excel, Word, PowerPoint, as well as financial analysis and modeling
• Understands and adopts the organizational structure
• Possesses the attitude of collaboration and sharing
• Possesses willingness to learn and adopt new methodologies
• Operates office equipment including personal computer with keyboard
• Database and accounting system experience are a strong plus
• Flexibility and willingness to respond to issues during and outside of core business hours

EDUCATION AND EXPERIENCE:

• College coursework in Accounting, Finance or Business Administration highly desired
• 2+ years of prior experience as a financial analyst or in a law firm preferred
• Experience with SQL, Power BI, or Python a plus

WORK ENVIRONMENT AND PHYSICAL DEMANDS:

• An on-site presence is an essential function of this position; remote work may be permitted in accordance with the firm’s flexible work policy and based on business needs
• Position operates in a professional office environment which is usually quiet to moderate
• Position routinely uses standard office equipment such as computers, photocopiers, and file cabinets
• Position requires that the employee be able to multi-task in a fast-paced work environment
• This position is primarily a sedentary position; however, some duties and responsibilities may require the employee to lift boxes, open file cabinets, bend or stand, reach with arms and hands, climb or balance, and occasionally move about to access office equipment
• May require employee to carry or lift items weighing up to 10 pounds

OTHER DUTIES AND EXPECTATIONS:

• Meets the department’s expectations to retrieve, read and/or respond to firm and client-related e-mail messages during and outside of core business and scheduled work hours by connecting a personal mobile device (smartphone or tablet with a data plan) to the firm’s network
• This description outlines the basic requirements of this position; it is not intended to be a complete description as other duties may be assigned

The base salary for this position is expected to be between $65,000 to $80,000 annually. Actual salary will be determined based on skills, experience (to the extent relevant) and other job-related factors, consistent with applicable law.

Wiley’s comprehensive benefits package includes medical and prescription drug plan coverage, dental, vision, flexible spending and health savings accounts, life insurance, 401(k) retirement plan with firm discretionary contribution, generous paid time off (PTO) package plus ten firm paid holidays, access to state of the art on-site fitness facilities and locker rooms and wellness programming, paid parental leave and subsidized backup child/elder care, and more.

*Wiley is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and employees without regard to race, color, religion, sex, pregnancy, national origin, age, physical and mental disability, marital status, sexual orientation, gender identity or expression, genetic information, military and veteran status, personal appearance, family responsibilities, political affiliation, matriculation status, credit information, status as a victim or family member of a victim of domestic violence, a sexual offense or stalking, homeless status, or any other characteristic protected by applicable law.

**This Organization Participates in E-Verify. This employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee’s Form I-9 to confirm work authorization. Employers may not use E-Verify to pre-screen job applicants and may not limit or influence the choice of documents you present for use on the Form I-9.