Classification and Compensation Analyst (1280) - Department of Human Resources

City and County of San Francisco; California (MO); On-site; USD 121,000 - 170,000; Full time

Job summary

City and County of San Francisco seeks a detail‑oriented analyst to support labor negotiations. The role provides costing support for a management bargaining team, including evaluating union proposals, performing salary surveys and drafting contract language.

The position requires strong Excel skills, database querying, sharp math and analytics, and the capacity to handle high‑pressure, late nights and weekend work during negotiations.

Qualifications

• Bachelor’s degree in a related field; experience in civil service is a plus.
• Strong Excel, statistical and analytical capabilities.
• Ability to query databases and analyze data for decision making.
• Attention to detail and ability to work with tight timelines.

Responsibilities

• Costing and evaluating the merits of union and City proposals.
• Performing salary surveys.
• Drafting and interpreting contract language.
• Analyzing information and succinctly summarizing using charts and matrices.

Skills

Excel

Databases

Math

Analytical skills

Multitasking

Attention to detail

Education

Bachelor's Degree

Master's degree preferred

Tools

Microsoft Excel

SQL / Database queries

Job description

Specific information regarding this recruitment process are listed below:

• Application Opening: Monday, August 24, 2026
• Application Deadline: Open until filled, the first application cutoff will be August 31, 2026.
• Compensation: $120,796 - $169,858 annually
• Appointment Type: Temporary Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.
• Duration of appointment: This position is supporting the upcoming round of labor contract negotiations. Position is expected to start around November 2026 and is expected to conclude around June 2027.
• Work schedule: This position works regularly in-person, onsite at Department of Human Resources offices at 1 South Van Ness Ave in San Francisco and requires some late nights and work on the weekends.

This position supports the City in its labor negotiations with over 30 unions and more than 35,000 employees such as custodians, sheriffs, engineers, electricians, and nurses and is an excellent opportunity to gain exposure to labor law, labor negotiations and working for the City and County of San Francisco. This position provides costing support for a management bargaining team led by a chief negotiator and consisting of a Deputy City Attorney, Employee Relations Division representatives, department representatives and with coordination with the Mayor’s Budget Office and the Office of the Controller.

Specific Duties to be performed:

• Costing and evaluating the merits of union and City proposals.
• Performing salary surveys.
• Drafting and interpreting contract language.
• Analyzing information and succinctly summarizing using charts and matrixes.

We’re looking for someone with:

• Strong experience with Excel.
• Ability to use and query databases.
• Strong math, statistics and analytical skills.
• Ability to multi-task and shift directions rapidly.
• Can operate effectively with a very low margin of error.

This position will require some late nights and work on the weekends for a few weeks towards the end of the negotiating process in the Spring. Labor negotiations can sometimes get quite heated so an ability to handle stressful situations is needed.

Education and Substitution:

• Possession of a Bachelor's Degree from an accredited college or university. Course work in the social/behavioral sciences or in public/business administration is preferred.
• Professional personnel experience performing duties equivalent to those of City class 1280 Employee Relations Representative must substitute for the required education on a year-for-year basis. (One year of experience will be considered equivalent to 30 semester or 45 quarter units of college coursework.) Experience in City classes other than 1280 must be documented in accordance with Civil Service Commission Rule 109 in order to be treated as qualifying.

Desirable Qualification:

• Experience working in a Civil Service system
• Experience using Microsoft Excel to analyze information and create charts and matrixes
• Experience with database queries
• A master’s degree in public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other closely related fields of study is preferred.

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

Verification of Education and Experience:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/information-about-hiring-process#verification

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement
• Seniority Credit in Promotional Exams

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.