Senior Administrative Analyst (1823) - Multiple Departments Citywide (C00187)

About the role

The City and County of San Francisco is seeking multiple Senior Administrative Analysts to join its workforce of nearly 40,000 staff members. This role offers direct insights into how the city’s $14 billion budget supports high-quality services for residents, workers, and visitors. Ideal candidates are passionate about public service, enjoy analysis, and are curious and open thinkers.

Responsibilities

• Lead and perform in-depth research and analysis on special projects or high-profile public issues.
• Develop policy recommendations and prepare materials for publication, such as policy memos and hearing materials, using analytical tools.
• Understand department policy priorities and work with stakeholders, tracking relevant local, state, and federal legislation and regulations that may impact the department.
• Spearhead comprehensive policy analysis and research efforts, including issue identification, report preparation, and expert recommendation generation.
• Continuously track local, state, and federal legislation, offering informed advice to senior management on compliance and financial impacts of new regulations.
• Develop, implement, and manage required reporting systems, ensuring seamless compliance with legislative reporting mandates.
• Coordinate, develop, manage, and monitor departmental budget proposals, ranging from moderately complex to highly complex.
• Prepare meticulously detailed budget line-item narratives, comprehensive analyses, and well-justified recommendations, providing essential information for annual and supplemental budget requests.
• Analyze budget expenditures and revenues, identifying critical trends to inform decision-making.
• Produce insightful financial and statistical reports that contribute to informed financial management and strategy.
• Support the management of contract processes for their department throughout the full procurement process.
• Collaborate and build relationships with other key departments, overseeing contract monitoring and execution like the Contract Monitoring Division (CMD) and the City Attorney’s Office.
• Lead the oversight of contract processes, including facilitating informal and formal bid processes, throughout the entire procurement cycle, to ensure successful contract execution.
• Offer valuable insights as a trusted thought partner on contract-related matters, driving effective and compliant contract operations.
• Provide a real-world example, assisting with procurement and contract administration related to bond programs that fund construction and modernization of San Francisco public schools.
• Conduct data and programmatic analysis using analytical programs, leading data analysis efforts by utilizing analytical programs to derive meaningful findings and actionable recommendations, contributing to informed decision-making.
• Create data visualizations, maps, and streamlined dashboards using PowerBI, Tableau, or other dashboarding technologies, while preparing comprehensive reports that include financial and policy recommendations grounded in relevant data, ensuring clear and informed communication.
• Provide a real-world example, working with the San Francisco Planning Department to update the department’s data inventory and enhance data governance protocols in key areas including housing production, racial and social equity, and COVID-19 recovery.
• Assist with fiscal accounting, budget analysis and reporting, billing, revenue collection, and debt management.
• Analyze 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.
• Plan and perform economic and/or financial analyses including forecasting, revenue and/or expense projections, analyzing capital requirements, calculation of debt capacity, evaluation of financing alternatives.
• Conduct rate analysis, modeling and cost/benefit analysis, including preparation of audit schedules and financial statements.
• Work with the Department of Homelessness and Supportive Housing to learn about and provide financial analysis on programs funding robust supporting housing programs to formerly homeless individuals.
• Lead analytical work related to grants management and compliance, serving as a central point of coordination and liaison for activities associated with the application and management of multiple-source capital projects and grants.
• Monitor detailed and complex budgets, ensuring expenditures remain within budget, and shifting funds within guidelines.
• Coordinate the preparation of city-wide single audit report.
• Administer, and coordinate application and reporting processes for grant opportunities with department program staff.

Qualifications

• Education: Possession of a baccalaureate degree from an accredited college or university.
• Experience: Three (3) years full-time equivalent experience performing professional-level analytical work.
• Substitution: Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the 182X Class series may be substituted for the required one (1) year of experience. Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years).