Skip to main content



The health and safety of our colleagues and candidates for employment are our highest priority. Accordingly, Citi continues to monitor the COVID-19 situation closely. We have implemented precautionary measures across our firm globally, including conducting all candidate interviews virtually on a temporary basis until further notice where needed.

Citi - Client Advisory Analyst

Job Req ID 22548663 Location(s) New York, New York Job Category Private Client Coverage
Apply Now

iti’s Law Firm Group (LFG) is looking to fill a Client Advisory Analyst-programmer role in the Client Advisory Group. Citi Law Firm Group Advisory Services team reports legal industry trends and forecasts via various publications, client presentations, and client engagements. In addition, Advisory Services team has been producing industry leading analyses for law firms around the world. Through firms participating in surveys, the Advisory Services team studies firm’s performance in relation to nominated peers, enabling law firm leaders to make informed strategic decisions.

The Advisory Analysts provide analytical support to the Client Advisors, and are responsible for administering the surveys, maintaining the databases, and creating the collateral that is then shared with LFG’s clients. The Advisory Analyst is an integral part of the production of over 200 tailored comparative client presentations throughout the year. The analyst is also expected to interface with LFG clients to administer and collect financial data, respond to client requests and analysis and maintain and mine database of survey results. The ideal candidate will have a strong interest in the legal industry, an analytical mind, and a very high attention to detail.

The Client Advisory Analyst-programmer will work with the senior client analyst and technology team to improve the survey site and look for innovative ways to improve the client experience. The qualified candidate should be proficient is VB/VBA, specific to working with MS products with the aim to produce adaptive solutions to unforeseen problems and newly formed objectives. The applicant should have robust analytical skills and be highly familiar with database construction.


  • 2-5 years relevant experience
  • Licensing: Series 7, 63 and 65 or 66
  • Demonstrated interest in finance and law, analytical skills Proficiency and aptitude in utilizing MS Office, specifically Microsoft Excel, Access, and PowerPoint


  • Bachelor's/University degree or equivalent experience

Preferred Qualifications:

  • Proficiency as a developer and/or power user; specifically, 2-3 years of experience scripting in VBA for any of the following applications:
    • MS Access
    • MS Excel
    • MS Outlook
    • SharePoint
    • SQL
  • Prospective Applicant should:
    • Be able to develop desktop solutions in XLSX Macros or MS Access databases and/or combine the two as dependent upon the issue/request
    • Have a deep understanding of process with regards to dataflow in terms daily office requirements
    • Have strong data analysis acumen when addressing calculative obstacles
    • Be able to clearly communicate technical subject matter to all levels of associates and senior staff.
  • Recurring activities are comprised of:
    • MS Database maintenance
    • Building ADHOC questionnaires through MS Excel
    • General understanding of our reporting system LPAR (LFG Peer Group Analysis & Reporting) and survey site, CWS (Client Web Services)
      • Communicating with the support staff for LPAR / CWS
      • Addressing issues that may occur on the LPAR/CWS interface
      • Logging/Reporting issues when discovered for LPAR based reports or CWS based surveys


Job Family Group:

Private Client Coverage


Job Family:

Law Firm Advisory Services


Time Type:

Full time


Primary Location:

New York New York United States


Primary Location Salary Range:

$80,220.00 - $111,920.00


Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View the "EEO is the Law" poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting


Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.

Apply Now
  • Join our team
    of 220,000+
    strong diverse employees

  • Socially minded employees volunteering in communities across 90 countries

  • Meaningful career opportunities thanks to a physical presence in over 95 markets

We foster a culture that embraces all individuals and encourages diverse perspectives, where you can make an impact and grow your career. At Citi, we value colleagues that demonstrate high professional standards, a strong sense of integrity and generosity, intellectual curiosity, and rigor. We recognize the importance of owning your career, with the commitment that if you do, we promise to meet you more than half way.

Saved Jobs

You have no saved jobs

Previously Viewed Jobs

You have no viewed jobs