Junior Administrative Analyst Multiple Departments Citywide; C00185

Overview

Junior Administrative Analyst (1820) - Multiple Departments Citywide (C00185). Apply using Smart Recruiters, the City and County of San Francisco's application portal. This recruitment is open continuously and has no closing date. The City and County of San Francisco is looking to hire multiple analysts to support city departments in problem-solving for homelessness, environmental sustainability, transportation, green spaces, public safety, and other key city services.

This role provides insight into how San Francisco’s 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 dynamic city with opportunities across economic growth, urban development, arts and entertainment, and social issues. Our employees help shape the future of the city while delivering services to a diverse population. The City offers benefits including competitive salaries, medical, dental, and vision insurance, retirement plans, long-term disability, life insurance, and generous paid time off. City policy requires on-site work with some flexibility for telecommute schedules.

Junior Administrative Analysts work at many City departments on teams with essential duties varying by specialization in data, grants, contracting, budget, finance, or legislation.

See below for examples of the range of duties by subject matter:

• Work in teams to analyze performance data to identify operational challenges and develop policy recommendations; assist in preparing materials for publication such as policy memos and hearing materials.
• Key duties include assisting with analysis, understanding department policy priorities, coordinating with elected officials, and tracking relevant local, state, and federal legislation and regulations that may impact the department.
• Example: a Junior Policy Analyst for the Office of the Treasurer & Tax Collector could focus on financial access and inclusion with a focus on community reinvestment.

• Develop budget proposals and financial models, track City revenues and expenditures, perform account reconciliation for budget period closing, and present analysis to stakeholders.
• Key duties include 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.
• Example: may work with the Human Services Agency’s $1 billion annual budget for safety net services for individuals, families, and the elderly.

• Assist in the management of contract processes for department procurement, collaborating with other key departments overseeing contract monitoring and execution.
• Key duties include supporting informal and formal bid processes, reviewing compliance with contracts, creating contract documents, and advising leadership and City vendors on contracts.
• Example: may assist with procurement and contract administration related to bond programs funding construction and modernization of SF public schools.

• Support data and programmatic analysis using analytical tools; develop findings and actionable recommendations to inform programmatic and policy decisions.
• Key duties include data queries from databases and spreadsheets, data analysis, creating data visualizations and maps for statutory reports, and developing dashboards using Power
  
  BI, Tableau, or similar tools.
• Example: work with the San Francisco Planning Department to update data inventory and enhance data governance in housing production, equity, and COVID-19 recovery.

• Assist with fiscal accounting, budget analysis and reporting, billing, revenue collection, and debt management.
• Key duties include analyzing departmental financial condition, interpreting contracting guidance, preparing financial statements, calculating debt capacity, and using City financial systems.
• Example: may work with the Department of Homelessness and Supportive Housing on financial analysis for housing programs.