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

City and County of San Francisco•San Francisco, CA

6d•Hybrid

About The Position

Junior Administrative Analysts work in many City departments on teams focused on areas such as data, grants, contracting, budget, finance, and legislation. The specific duties vary by department and assignment. The position supports City services and programs through analysis, recommendations, reporting, and administrative work. Current City policy requires on-site work, with some flexibility for telecommute schedules. Policy assignments may analyze performance data, identify operational challenges, develop policy recommendations, prepare policy memos and hearing materials, and track relevant legislation and regulations. Budget assignments may develop budget proposals and financial models, monitor revenues and expenditures, reconcile accounts, compile budget requests, prepare reports and calendars, and respond to requests. Contract assignments may support procurement and bid processes, review contract compliance, prepare contract documents, and assist with contract monitoring and execution. Data assignments may query databases and spreadsheets, analyze data, create visualizations and maps, and develop dashboards. Finance assignments may support fiscal accounting, budget analysis and reporting, billing, revenue collection, and debt management, including preparing financial reports and using City financial systems. Grants assignments may review budget requests, learn grant policies and compliance standards, and assist with grant applications and reporting. Incumbents may be required to perform the full range of duties in the class specification.

Requirements

Possession of a baccalaureate degree from an accredited college or university, or an allowable substitution of up to two years of 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 is considered equivalent to 30 semester or 45 quarter units.
Candidates projected to earn a baccalaureate degree within six months of application submission may participate in recruitment; an employment offer may be contingent on submitting degree documentation before appointment.
Access to a computer and reliable internet connection to take the online examination.

Responsibilities

Analyze performance data, identify operational challenges, and develop policy recommendations.
Assist with preparing policy memos, hearing materials, and other materials for publication.
Track local, state, and federal legislation and regulations that may affect a department.
Develop budget proposals and financial models; track revenues and expenditures; and perform account reconciliation.
Review and export datasets into reports, compile budget requests, prepare budget reports and calendars, and respond to budget requests.
Support informal and formal bid processes, review contract compliance, prepare contract documents, and assist with contract monitoring and execution.
Query and analyze data from databases and spreadsheets; create visualizations, maps, and dashboards.
Assist with fiscal accounting, budget analysis and reporting, billing, revenue collection, debt management, and use of City financial systems.
Analyze departmental financial condition, prepare financial statements and reports, and explore financing alternatives.
Review and analyze grant budget requests, learn grant policies and compliance standards, and assist with grant applications and reporting.
Collaborate with department teams, other City departments, leadership, vendors, and internal and external partners.