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

City and County of San Francisco•San Francisco, CA

5d•Hybrid

About The Position

Junior Administrative Analysts work across multiple City departments on a range of teams. The specific duties vary depending on whether the position focuses on data, grants, contracting, budget, finance, or legislation. City policy requires on-site work, with some flexibility for telecommute schedules. The position supports City services and programs through analysis, reporting, policy and financial work, contract and grant administration, and collaboration with department staff and other stakeholders. Policy-focused analysts help evaluate performance data, identify operational challenges, develop policy recommendations, prepare materials for publication and hearings, understand department priorities, work with elected officials, and track relevant legislation and regulations. Budget-focused analysts help develop budget proposals and financial models, monitor revenues and expenditures, reconcile accounts, prepare reports and calendars, respond to budget requests, and work with internal and external partners. Contracts-focused analysts support procurement and contract processes, including bid facilitation, compliance review, document preparation, contract monitoring, and coordination with other departments, leadership, and vendors. Data-focused analysts conduct queries and analyses using databases and spreadsheets, develop findings and recommendations, and may create visualizations, maps, and dashboards. Finance-focused analysts support accounting, budget analysis and reporting, billing, revenue collection, and debt management, including preparing financial statements and working with City financial systems. Grants-focused analysts review budget requests, learn and apply grant policies and compliance standards, and assist with grant applications and reporting.

Requirements

Possession of a baccalaureate degree from an accredited college or university.
Up to two years of the required education may be substituted with qualifying full-time, professional-level experience in budget analysis, financial analysis and reporting, legislative or policy analysis, data analysis, or contract or grant administration.
One year (2,000 hours) of qualifying experience is equivalent to 30 semester or 45 quarter units.
Candidates projected to graduate with a baccalaureate degree from an accredited college or university within six months of application submission may participate in the recruitment process, subject to the stated degree-submission condition for appointment.
Candidates must have access to a computer and reliable internet connection to take the online exam.

Responsibilities

Analyze performance data to identify operational challenges and help develop policy recommendations.
Assist with policy analysis, publication materials, policy memos, and hearing materials.
Track local, state, and federal legislation and regulations that may affect a department.
Help develop budget proposals and financial models, and track revenues and expenditures.
Perform account reconciliation and prepare budget reports, calendars, and responses to budget requests.
Support informal and formal bid processes, contract compliance reviews, contract documentation, monitoring, and execution.
Query and analyze data from databases and spreadsheets, and develop findings and actionable recommendations.
Create data visualizations, maps, and dashboards when needed.
Assist with fiscal accounting, budget analysis and reporting, billing, revenue collection, and debt management.
Prepare financial statements and reports for funding agencies, analyze departmental financial conditions, and use City financial systems.
Review and analyze internal and external budget requests related to grants.
Assist with grant applications and reporting, and support grant policy and compliance work.