Sql analyst Jobs in Lynn, MA

Pricing Analyst

The Pricing Analyst, in collaboration with and in support of the firm's strategic initiatives, provides support to the generation of revenue through analyzing historical data and performance to advise on profitable arrangements and rate structures. You will work closely with Pricing Leadership and Sr. Analysts, Business Development, Marketing, Legal Project Management, Billing Operations, and Staff Leadership. You will resolve complex data & reports to develop a story & advise on forward options.

This position can sit in our Phoenix, Atlanta, Austin, Baltimore, Boston, Chicago, Dallas, Houston, Los Angeles, Miami, Minneapolis, Northern Virginia, New York City, Philadelphia, Raleigh, San Diego, Seattle, Short Hills, Washington D.C., and Wilmington offices and offers a hybrid work schedule.

Responsibilities

• Work with Business Development/Pitch team, Pricing team and Service Delivery leadership to develop rate proposals, fee estimates and pricing options in response to client RFP's and ad-hoc requests.
• Work directly with Billing/Rates, Pricing team and firm attorneys to identify rate renewal opportunities, develop proposals, receive Practice Group approval and communicate/submit per the relevant deadline(s).
• Coordinate with Pricing leadership and Sr Pricing Analysts to contribute to financial models for assessing financial impact and profitability of pricing proposals. Assist in the development of creative, workable pricing solutions in response to client demands, including alternative fee arrangements.
• Perform historical analytics of matters in coordination with Pricing leadership and Sr Pricing Analysts to identify key risks and drivers of fee magnitude to build robust pricing models for broader implementation.
• Work with Billing/Rates, New Business Intake and other firm staff to ensure billing system setup and documentation of clients/matters captures intended pricing arrangements, rates, and other relevant client notes.
• Compiles and communicates relevant progress, wins, risks to Pricing/Firm Leadership in a timely manner.
• Work on special projects in support of the Firm's strategic initiatives.
• Performs other duties and ad-hoc analyses as assigned or required to meet Firm goals and objectives.

Desired Skills

Must have strong problem solving, planning and organizational skills. Must be an innovative and strategic thinker. Ability to manage multiple projects, take initiative and work effectively in a fast-paced environment. Must have ability to self-direct and build collaborative relationship across the firm. Solid analytical skills required along with exceptional attention to detail. Must be a self-starter.

Proficient in summarizing and charting large data sets. Advanced MS Word & Excel experience, to include experience using VLOOKUP and PivotTable functions. Previous experience in a law firm or other professional services firm desirable.

Minimum Education

• Bachelor's Degree in Finance, Accounting or similar field.

Minimum Years of Experience

• 3 years' directly related experience, preferably in financial analysis, billing, accounting or similar type work.

Essential Job Expectations

• Effectively communicate, verbally and in writing, with clients, lawyers, business professionals, and third parties.
• Produce deliverables, answer phone calls, and reply to correspondence in an efficient and responsive manner.
• Provide timely, accurate, and quality work product.
• Successfully meet deadlines, expectations, and perform work duties as required.
• Foster positive work relationships.
• Comply with all firm policies and practices.
• Engage in both physical and sedentary activity, such as (a) working at a computer for extended periods of time, including on-screen reading and typing; (b) participating in digital/virtual conference calls; (c) participating in meetings as needed.
• Ability to work under pressure and manage competing demands in a fast-paced environment.
• Perform all other duties, tasks or projects as assigned.

Our employees are expected to embrace and uphold our firm values as a part of our DLA Piper culture. We are committed to excellence in how we represent our clients and develop our people.

Physical Demands

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, including the human body. 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.

Work Environment

The individual selected for this position may have the opportunity for a hybrid work arrangement comprised of remote and in-office work, the requirement for which will be determined in coordination with the hiring manager or supervisor and may be modified in the firm's discretion in the future.

Disclaimer

The purpose of this job description is to provide a concise statement of the work elements and to organize and present the information in a standardized way. It is not intended to describe all the elements of the work that may be performed by every individual in this classification, nor should it serve as the sole criteria for personnel decisions and actions. The job duties, requirements, and expectations for this position may be modified at the Firm's discretion at any time. This job description does not change the at-will nature of employment.

Application Process

Applicants must apply directly online instead of sending application materials via email.

Accommodation

Reasonable accommodations may be made upon request to permit individuals with a disability to perform the essential functions and responsibilities of the position or to participate in the job selection process. If you have a request for an accommodation during the application process, please contact careers@us.dlapiper.com.

Agency applications will not be considered.

No immigration sponsorship is available for this position. The firm's expected hiring range for this position is $80,348 $117,111 per year depending on the candidate's geographic market location.

The compensation offered for employment will also be dependent on other factors including the candidate's experience, skills, educational and professional background, and overall qualifications. We offer a comprehensive package of benefits including medical/dental/vision insurance, and 401(k).

DLA Piper is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.