Junior Administrative Analyst (1820)

About the Role

The City and County of San Francisco is seeking Junior Administrative Analysts to support various City departments. This is a citywide exam posting with continuous recruitment. Successful candidates will be placed on an eligible list for departmental hiring.

The role offers direct insights into the City's budget and operations across areas such as homelessness, environmental sustainability, transportation, public safety, and more.

Key Responsibilities

Junior Administrative Analysts support departments on a variety of teams, with duties varying based on specialization:

• Policy Analysis:
• Analyze performance data to identify operational challenges.
• Develop policy recommendations.
• Assist in preparing policy memos and hearing materials.
• Track relevant local, state, and federal legislation and regulations.
• Budget Analysis:
• Develop budget proposals and financial models.
• Track City revenues and expenditures.
• Perform account reconciliation.
• Present analysis to stakeholders.
• Review and export large datasets into reports.
• Compile budget requests and prepare budget reports and calendars.
• Respond to budget requests and provide thought partnership.
• Contracts Analysis:
• Assist in managing contract processes throughout the full procurement cycle.
• Collaborate with departments on contract monitoring and execution.
• Support informal and formal bid processes.
• Review department compliance with contracts.
• Assist in creating contract documents.
• Provide thought partnership on contracts.
• Data Analysis:
• Support data and programmatic analysis using analytical programs.
• Develop findings and actionable recommendations.
• Conduct data queries from databases and spreadsheets.
• Perform data analysis.
• Create data visualizations and maps.
• Develop streamlined dashboards using PowerBI, Tableau, or other dashboarding technologies.
• Finance Analysis:
• Assist with fiscal accounting, budget analysis, and reporting.
• Support billing, revenue collection, and debt management.
• Analyze the overall financial condition of a department.
• Interpret City contracting guidance and inform recommendations.
• Prepare financial statements and reports.
• Calculate debt capacity and explore financing alternatives.
• Utilize City financial systems.
• Grants Analysis:
• Assist with analytical work related to grants management and compliance.
• Review and analyze internal and external budget requests.
• Learn grant policies and compliance standards.
• Assist with application and reporting processes for grant opportunities.

Note: Current City policy requires on-site work with some flexibility for telecommute schedules.

Requirements & Tech Stack

• Possession of a baccalaureate degree from an accredited college or university.
• OR Substitution: Up to 2 years of the required education may be substituted 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 of qualifying experience is equivalent to 30 semester/45 quarter units).
• Candidates projected to graduate within six months of application submission will be considered.
• Access to a computer and reliable internet connection for the online examination.

Qualifications

• Passion for public service.
• Curiosity and open thinking.
• Enjoyment of analysis.

Selection Procedures

• Junior Administrative Analyst Core Exam: A 100% weighted, computer-administered online exam taken at a time and location of convenience.
• Score Banking: Exam scores are banked for three years.
• Eligible List: Candidates who pass the exam will be placed on an eligible list for 12 months.