jobiwork
City and County of San Francisco
From company careers site

Junior Administrative Analyst (1820) - Multiple Departments Citywide (C00185)

Location
San Francisco, CA, United States
Work mode
On-site
Employment type
Full-time

About the job

Company Description THIS IS A CITYWIDE EXAM POSTING. Your application to this posting is an application to take a citywide exam. This recruitment is open continuously and has no closing date. If you pass the exam, you will be emailed your score and ranking on the eligible candidate list. When a department has an open position with this job classification they will use this eligible list to hire for that position. Departments will contact candidates from this list to gauge interest in their specific roles. Learn more about the City’s hiring process here: https://careers.sf.gov/knowledge/process/ Are you interested in supporting City departments problem-solve for homelessness, environmental sustainability, transportation, green spaces, public safety, and other key city services? If you are passionate about making a difference at the local level, are a curious and open thinker, and enjoy analysis, this job may be the right fit. The City and County of San Francisco is looking to hire multiple analysts to be part of the City workforce of nearly 40,000 staff and growing. This is a unique opportunity to get direct insights into how San Francisco’s $14 billion budget is used to provide high-quality services for residents, workers, and visitors. We are looking for candidates with a passion for public service. San Francisco is a vibrant and dynamic city, on the forefront of economic growth & innovation, urban development, arts & entertainment, as well as social issues & change. This rich tapestry of culture and ideas is sustained by our City's commitment to heighten the quality of life for the diverse population of San Franciscans and residents of the greater Bay Area. Our employees play an important role not only in making our City what it is today, but also in shaping the future of San Francisco. In addition to establishing a career with purpose and opportunity for professional growth, the City offers excellent benefits that include: competitive salaries; medical, dental, and vision insurance; defined benefit retirement plan; deferred compensation plan; long-term disability insurance; life insurance; and a generous paid time off package. Come explore first-hand the many opportunities that the City and County of San Francisco has to offer.

Job Description Junior Administrative Analysts work at many City departments on a wide variety of teams, with essential duties varying depending on whether the role focuses on data, grants, contracting, budget, finance, and/or legislation. Current City policy requires on-site work with some flexibility for telecommute schedules. See below for examples of the range of duties by subject matter: Junior Policy Analysts work in teams to analyze performance data to identify operational challenges and develop policy recommendations as well as assist preparation of materials for publication such as policy memos and hearing materials.

• Key duties include assisting with analysis, building an understanding of department policy priorities and working with elected officials, and keeping track of relevant local, state, and federal legislation and regulations that may impact the department.

  • Key duties include assisting with analysis, building an understanding of department policy priorities and working with elected officials, and keeping track of relevant local, state, and federal legislation and regulations that may impact the department.
  • Providing a real-world example, a Junior Policy Analyst for the Office of the Treasurer & Tax Collector could involve working to improve financial access and inclusion, with a focus on community reinvestment.

• Key duties include reviewing and exporting large datasets into reports, compiling budget requests, preparing budget reports and calendars, responding to budget requests and providing customer-service and thought partnership to internal and external partners.

  • Key duties include reviewing and exporting large datasets into reports, compiling budget requests, preparing budget reports and calendars, responding to budget requests and providing customer-service and thought partnership to internal and external partners.
  • Providing a real-world example, a Junior Budget Analyst may have the opportunity to learn about the Human Services Agency’s $1 Billion annual budget providing a comprehensive safety net services for individuals, families, and the elderly.

• Key duties include supporting the facilitation of informal and formal bid processes, reviewing department compliance with new and existing contracts, assisting in the creation of important contract documents, and being a valuable thought partner on contracts to department leadership and City vendors.

  • Key duties include supporting the facilitation of informal and formal bid processes, reviewing department compliance with new and existing contracts, assisting in the creation of important contract documents, and being a valuable thought partner on contracts to department leadership and City vendors.
  • Providing a real-world example, a Junior Contracts Analyst could assist with procurement and contract administration related to bond programs that fund construction and modernization of San Francisco public schools.

• Key duties include conducting data queries from variety of databases and disparate spreadsheets, then performing data analysis. Additional duties could be creating data visualizations and maps for statutory reports, as well as developing streamlined dashboards using PowerBI, Tableau, or other dashboarding technologies.

  • Key duties include conducting data queries from variety of databases and disparate spreadsheets, then performing data analysis. Additional duties could be creating data visualizations and maps for statutory reports, as well as developing streamlined dashboards using PowerBI, Tableau, or other dashboarding technologies.
  • Providing a real-world example, a Junior Data Analyst might work with the San Francisco Planning Department to update the department’s data inventory and enhance data governance protocols in key areas including housing production, racial and social equity, and COVID-19 recovery.

• Key duties include analyzing the overall financial condition of a department, interpreting City contracting guidance and informing recommendations, preparing financial statements and reports to various funding agencies throughout the fiscal year, calculating debt capacity and exploring financing alternates, and using City financial systems.

  • Key duties include analyzing the overall financial condition of a department, interpreting City contracting guidance and informing recommendations, preparing financial statements and reports to various funding agencies throughout the fiscal year, calculating debt capacity and exploring financing alternates, and using City financial systems.
  • Providing a real-world example, a Junior Finance Analyst may work with the Department of Homelessness and Supportive Housing, learning about and providing financial analysis on programs funding robust supporting housing programs to formerly homeless individuals.

• Key duties include reviewing and analyzing internal and external budget requests, learning about grant policies and compliance standards of different grantors, assisting with application and reporting processes for grant opportunities with department program staff.

  • Key duties include reviewing and analyzing internal and external budget requests, learning about grant policies and compliance standards of different grantors, assisting with application and reporting processes for grant opportunities with department program staff.
  • Providing a real-world example, a Junior Grants Analyst might assist the San Francisco Planning Department in writing grants to bring in critical funding towards the growth and development of San Francisco.

Qualifications Education:

Possession of a baccalaureate degree from an accredited college or university Substitution:

May substitute up to 2 years of the required education with qualifying full-time, professional-level experience in budget analysis, financial analysis and reporting, legislative/policy analysis, data analysis, or contract/grant administration. One year (2,000 hours) of qualifying experience will be considered equivalent to 30 semester/45 quarter units Note:

Candidates who are projected to graduate with a baccalaureate degree from an accredited college or university within six months of their application submission will be invited to participate in the recruitment process. Candidates in this situation who successfully pass the examination will be placed on the eligible list, and may participate in the final selection process. Such candidates may be given an offer of employment contingent upon submitting documentation of a degree prior to appointment. Applicants will receive a confirmation email from notification@careers.sf.gov that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received. Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Review SF Careers Employment Applications for considerations taken when reviewing applications. Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://careers.sf.gov/knowledge/experience-education/ 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. NOTE: Use your personal email —school and work emails may become inaccessible

Additional Information SELECTION PROCEDURES Junior Administrative Analyst Core Exam (Weight: 100%)

Candidates self-certifying meeting the Minimum Qualifications will be invited to participate in the online Junior Administrative Analyst Core Exam. Candidates will be sent a web link via email that will allow them to take the online Junior Administrative Analyst Core Exam that is designed to measure knowledge, skills, and/or abilities in job-related areas which have been identified as critical for positions in the Junior Administrative Analyst classification. This computer-administered test can be taken at home or at a time and location of one’s convenience, but only within the time period specified on the test notification. Candidates must have access to a computer and reliable internet connection to participate in this exam. Score Banking: Scores attained on the Junior Administrative Analyst Core Exam will be 'banked' for three years, starting from the date of the examination. This means that, during this three-year time period, candidates need not take this test again. Rather, if another announcement you applied to and are deemed qualified for requires the Junior Administrative Analyst Core Exam and is held within one year of your Junior Administrative Analyst Core Exam date, your score will be automatically applied to that announcement. However, after one year, a candidate has the option to either (a) apply their test score to the other announcement or (b) re-take the test. Re-testing is permitted no sooner than one year from the date of the test and only in association with a candidate’s eligibility for another announcement to which the candidate has applied and is deemed qualified. If a candidate opts to re-test, the re-test score becomes the candidate’s official score since it is the most recent. If a significant modification is made to this exam in the future, the application of “banked” scores may no longer be appropriate. In such a rare circumstance, candidates with “banked” scores would be required to re-take the exam sooner than the three-year period specified above should they apply to another job opportunity where the modified exam is used. Eligible List/Score Report: A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the

From City and County of San Francisco's careers page (SmartRecruiters), checked 3 Nov 2026.

How to apply

  1. Select Apply on jobs.smartrecruiters.com. It opens City and County of San Francisco's own application form in a new tab, run on SmartRecruiters.
  2. Fill in the form and upload your résumé there. Jobiwork never sees your application.
  3. City and County of San Francisco will reply to you directly. No real employer asks you for money to apply.

Get new Data & Analytics jobs in San Francisco by email

Free account: job alerts, every search result and full descriptions. No phone number, no résumé upload.

Create job alert

Similar jobs

Companies hiring in San Francisco

All jobs in San Francisco →