Exempt to Permanent – Junior Administrative Analyst (1820) – Citywide (E10151)

Company Description

• ***6/18/2025 NOTE: The job announcement has been reposted to allow for additional applications. The job ad will close no sooner than Friday, June 27, 2025 at 11:59 PM. If you already applied, there is no need to submit another application. If you have not applied, please do so as soon as possible.***

THIS IS A CITYWIDE RECRUITMENT FOR CURRENT CITY EMPLOYEES ONLY

This is an Exempt to Permanent position in accordance with Class-Based Test (CBT) Civil Service Rules. This recruitment is restricted to current exempt employees of the City and County of San Francisco, San Francisco Unified School District, or San Francisco City College, working within the 1820 Junior Administrative Analyst classification.

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.

• Application Opening: May 29, 2025
• Updated Application Deadline: This job will close no sooner than June 27, 2025
• Compensation Range: $77,896 to $94,718
• Recruitment ID: ETP-1820-E10151

Job Description

Junior Administrative Analyst assists with and performs professional level analytical work in a variety of functional areas, such as: development and administration of competitive bid processes and contractual agreements; grant administration and monitoring; budget development and administration; legislative analysis; development and evaluation of management/administrative policy; program evaluation and planning; quantitative and qualitative data analysis; or complex financial/fiscal analysis and reporting.

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.

Junior Budget Analysts work in teams to 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 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.

Junior Contracts Analysts work in teams to assist in the management of contract processes for their department throughout the full procurement process. They will collaborate and build relationships with other key departments overseeing contract monitoring and execution.

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.

Junior Data Analysts work in teams to support data and programmatic analysis using analytical programs. Using this information, analysts develop findings and actionable recommendations to inform programmatic and policy decisions.

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.

Junior Finance Analysts work in teams to assist with fiscal accounting, budget analysis and reporting, billing, revenue collection, and debt management.

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 th