Career Opportunity

Senior Administrative Analyst, Treasure Island Development Authority (1823)

Recruitment: RTF0123368-01096251

Published: August 10, 2022

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

About:

Role description

Under the general direction, the 1823 Senior Administrative Analyst conducts complex analysis to support the financial administration of the Treasure Island Development Authority (TIDA).  TIDA is responsible for implementing the multibillion-dollar program to redevelop the former Naval Station Treasure Island, including the development of to 8,000 homes; over 500,000 square feet of retail and office space; 290 acres of new parks; geotechnical improvements; new streets and utility infrastructure; and other public improvements.  TIDA currently manages a $17M annual operations budget and a projected $1.18B Infrastructure Revitalization Financing District (IRFD) and $2.5B Community Facilities District (CFD) providing public financing to the development effort.  The position supports the administration and operations of TIDA and is responsible for budgeting, financial planning, accounting functions, and financial analysis.  The position will assist in implementing and enforcing development agreements, fixed asset and debt accounting, capital project and grant accounting, and internal and external audits of the organization.  The position will work as part of the finance team and be assigned to support financial analysis and reporting, financial reconciliation, audits, program evaluation, and special projects as assigned.

Essential Functions

• Develop program budgets, monitor and control expenditures, initiate accounting journal entries, prepare and reconcile financial statements, conduct audits, and create accounting processes and systems to ensure compliance with rigorous accounting standards.
• Develop and analyze complex spreadsheet models and relational databases using statistical methods such as regression, sensitivity analysis, and spatial analysis to provide summary data, dashboards, and reports and projections on expenditure, revenue, and outcome trends.
• Uses financial systems and related applications to support department and ensure efficient and accurate application of financial transactions.
• Assist in financial analysis and reporting; assist in the preparation of detailed and complex management reports for the Treasure Island Director, Treasure Island Development Authority, City Administrator and ADM managers, as well as the Controller’s and Mayor’s Offices
• Applies complex accounting methods and theories to record transactions in accordance with Generally Accepted Accounting Principles (GAAP) and Governmental Accounting Standard Board (GASB)
• Conduct policy analyses and strategic reviews to develop recommendations and implementation plans to promote high quality, efficient services, and synthesizes resulting work into streamlined presentations for multiple audiences.
• Conduct qualitative analyses, including literature reviews, survey design and administration, and facilitating focus groups and key informant interviews.
• Reviews relevant development agreements and documents to develop recommendations and implementation plans to promote efficiency and compliance with such agreements.
• Develop and monitor performance measures.
• Analyze and interpret existing, newly enacted, and proposed local, state, and federal legislation and regulations for financial and programmatic impacts on the agency.
• Communicate findings from research and analysis through concise reports and effective multi-media presentations to diverse audiences.
• Write competitive grant proposals.
• Work on special projects or other duties as assigned.

How to qualify

1.  Possession of a graduate degree (Master's degree or higher) from an accredited college or university and three (3) years of full-time equivalent experience performing professional level analytical work as described in Note A: OR

2.  Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major college coursework as described in Note B and two (2) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

3.  Possession of a baccalaureate degree from an accredited college or university and four (4) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

4.  Possession of a baccalaureate degree from an accredited college or university with major college coursework as described in Note B and three (3) years full-time equivalent performing professional level analytical work as described in Note A

SUBSTITUTION: Applicants may substitute up to two (2) years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2,000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

Notes on Qualifying Experience and Education

A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1823, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1822 is considered qualifying.

B. Coursework applicable to a baccalaureate or higher degree 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 Class 1823.

Desirable Qualifications

• Possess an advanced degree in public policy, public administration, business administration, economics, statistics, accounting, or a related field;
• Exceptional critical thinking and communication skills, including the ability to communicate complicated financial information in a simple, accessible manner;
• Analytical and programming skills using Excel, PowerBI, Access, ArcGIS, and statistical software packages such as Stata or R;
• Experience using the city’s financial systems, such as PeopleSoft Financials and BI, FAMIS, BPMS, etc.;
• Knowledge of accounting methods and standards (e.g. GASB, GAAP);
• Possession of a Certified Public Accountant (CPA) License;
• Knowledge of research methods and program evaluation;
• Diplomacy and a sense of humor.

Important: Your application MUST include a cover letter and resume.  To upload these items, please attach using the "additional attachments" function.

Verification: Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the announcement. Written verification must be submitted on employer’s official letterhead, specifying name of employee, dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456.

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco. 

What else should I know?

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

Compensation:  $110,630 - $134,446 annually

Applicants are encouraged to apply immediately as this recruitment may close at any time, but not before August 19, 2022.

Late or incomplete submissions will not be considered. Mailed, hand delivered or faxed documents/applications will not be accepted.

Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine candidates’ qualifications. Only those applicants who most closely meet the needs of the Agency will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview. Qualified applicants with disabilities requiring reasonable accommodation in the selection process must contact the Agency by phone at (415) 554-6000 or, if hearing impaired at (415) 554-6015 (TTY).

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. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.