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

DataSF; San Francisco (CA); On-site; USD 50,000 - 90,000; Full time

Job summary

Join a dynamic team as a Junior Administrative Analyst in San Francisco, where you will play a pivotal role in supporting various city departments. This position offers a unique opportunity to engage directly with the city's $14 billion budget, contributing to essential services that impact the community. You will work collaboratively to analyze data, develop policy recommendations, and assist in budget management, all while gaining valuable insights into city operations. If you are passionate about public service and eager to make a difference, this role is perfect for you. Embrace the chance to grow your career while serving the vibrant city of San Francisco.

Qualifications

• Possession of a baccalaureate degree from an accredited college or university.
• Experience in budget analysis, financial analysis, or data analysis is preferred.

Responsibilities

• Assist in analyzing performance data to identify operational challenges.
• Support budget proposals, financial models, and contract management.

Skills

Data Analysis

Budget Analysis

Legislative Analysis

Contract Management

Grant Management

Education

Baccalaureate Degree

Tools

PowerBI

Tableau

Excel

Job description

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

Are you interested in supporting City departments problem-solve for homelessness, environmental sustainability, transportation, green spaces, public safety, and other key city services? If you are passionate about making a difference at the local level, are a curious and open thinker, and enjoy analysis, this job may be the right fit. The City and County of San Francisco is looking to hire multiple analysts to be part of the City workforce of nearly 40,000 staff and growing. This is a unique opportunity to get direct insights into how San Francisco’s $14 billion budget is used to provide high-quality services for residents, workers, and visitors. We are looking for candidates with a passion for public service.

Junior Administrative Analysts work at many City departments on a wide variety of teams, with essential duties varying depending on whether the role focuses on data, grants, contracting, budget, finance, and/or legislation.

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

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 a 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 the fiscal year, calculating debt capacity and exploring financing alternatives, and using City financial systems.

Junior Grants Analysts work in teams to assist in analytical work related to grants management and compliance.

• Key duties include reviewing and analyzing internal and external budget requests, learning about grant policies and compliance standards of different grantors, assisting with application and reporting processes for grant opportunities with department program staff.

How to qualify

Education:
Possession of a baccalaureate degree from an accredited college or university.

Substitution:
May substitute up to 2 years of the required 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 will be considered equivalent to 30 semester/45 quarter units.

Note:
Candidates who are projected to graduate with a baccalaureate degree from an accredited college or university within six months of their application submission will be invited to participate in the recruitment process. Candidates in this situation who successfully pass the examination will be placed on the eligible list and may participate in the final selection process. Such candidates may be given an offer of employment contingent upon submitting documentation of a degree prior to appointment.

What else should I know?

SELECTION PROCEDURES

Junior Administrative Analyst Core Exam (Weight: 100%)
Candidates self-certifying meeting the Minimum Qualifications will be invited to participate in the online Junior Administrative Analyst Core Exam. Candidates will be sent a web link via email that will allow them to take the online Junior Administrative Analyst Core Exam that is designed to measure knowledge, skills, and/or abilities in job-related areas which have been identified as critical for positions in the Junior Administrative Analyst classification.

This computer-administered test can be taken at home or at a time and location of one’s convenience, but only within the time period specified on the test notification. Candidates must have access to a computer and reliable internet connection to participate in this exam.

Additional Information Regarding Employment with the City and County of San Francisco

CONDITION OF EMPLOYMENT: All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.