Career Opportunity

Senior Administrative Analyst - SF Municipal Transportation Agency (1823) Multiple Divisions/Units

Recruitment: REF17666I

Published: January 03, 2023

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

About:

Who We Are:

The SFMTA, a department of the City and County of San Francisco, oversees Muni (the historic Municipal Railway), parking and traffic, bicycling, walking and taxis. Over one million people get around San Francisco and rely on us to ensure safe and reliable travel.

Our Vision: Excellent transportation choices for San Francisco.

Our Mission: We connect San Francisco through a safe, equitable, and sustainable transportation system.

Application Opening:  December 12, 2022.
Application Deadline:  Applicants are encouraged to apply as soon as possible as this announcement may close any time after 11:59 PM on January 9, 2023.
Annual Salary: $110,630 - $134,446
Recruitment ID: T00055

Role description

The San Francisco Municipal Transportation Agency (SFMTA) currently has vacancies in class 1823 Senior Administrative Analyst in various units within SFMTA.  Incumbents in these positions under general direction plans, organizes, leads and/or participates in complex, sensitive, and detailed analytical work in the areas of budget, financial/fiscal, economic, legislative and administrative policy and/or contract administration. 

Positions can be in any of the following, but not limited to, divisions/units within SFMTA.

Transit: As part of the Workforce Group in Transit Administration, the Senior Administrative Analyst plans, organizes, and conducts important, difficult, and sensitive analytical work that has substantive impact on Transit operations in the areas of workforce and organizational development. The Senior Administrative Analyst may function as Division Representative to coordinate on personnel and operational matters including interviewing, hiring, training, and progressive disciplinary processes. The Senior Administrative Analyst will make recommendations to solve complex HR challenges in identifying new opportunities using a combination of analytical skills, project management, and HR expertise. In addition, this position will work closely with the Transit Administration Budgeting unit to determine position allocations for each unit in Transit as well as position inventory management.

Streets: The Streets Division is responsible for designing, directing and managing all transportation planning and engineering functions within San Francisco, including placement of signs, signals, traffic striping, parking meters, curb markings and delivering bicycle, pedestrian, and traffic calming projects.  The mission of the Streets Division is to promote the safe and efficient multi-modal movement of people and goods and inviting streets and sidewalks for all who walk and use a bicycle throughout the City.  The Streets Division employs Senior Administrative Analysts in several subdivisions including Capital Programs & Construction (CP&C), Livable Streets, Operations, Parking & Curb Management, Parking Enforcement, Transportation Engineering, Security, Investigations & Enforcement (SIE), and Streets Administration.

Finance and Information Technology (FIT): As part of the Technology Business Operations team, this position will support various function in the Finance and Information Technology Division. This role may serve as the Finance and Information Technology’s Division Representative to support division’s recruitment effort and any human resource related issues, improve internal business processes, manage technology purchasing requests and service contracts in support of the Agency’s technology infrastructure, including professional services, hardware and equipment procurement needs, support technology capital and operating project delivery, including schedule, budget, and resource management, as well as, supporting the day-to-day business operations and initiatives of the Technology Division.

Office of Racial Equity and Belonging (OREB): The Office of Racial Equity & Belonging (OREB) directs and develops strategies for advancing racial equity, mobility justice and intersecting equity needs in all areas of SFMTA operations. OREB consists of four (4) sections: 1) Equitable Communications, 2) Equitable Services & Systems, 3) Equitable Workforce & Workplace, and 4) Policy, Process & Practice Improvement.

The office directs planning, implementation, and evaluation the SFMTA Racial Equity Action Plan and other collaborative projects to support the agency’s equity commitments. Core functions across on OREB sections include:

• Agencywide Policy, Process & Practice Improvement
• Culturally Specific Interventions to Optimize Racial Equity in MTA Systems
• Equity Analyses & Establishment of Equity Standards & Priorities
• Monitoring, Evaluation & Accountability Systems for Agencywide Equity Commitments

Taxis, Access & Mobility Services (TAMS) Division: The Taxis, Access & Mobility Services (TAMS) Division, Permits and Administration Section, is responsible for managing various permit programs, including commuter shuttles, scooter share, taxis, along with enforcement of those modes plus bike share.  The Senior Administrative Analyst works as a part of the team, which includes planners, investigators, permit clerks, and other SFMTA staff in other divisions. The analyst conducts professional-level work in managing and analyzing the operations and compliance of the various permit programs, proposed policy and legislative changes, budgets/grants, contract administration. Major efforts include internal systems modernization, testing new innovation within the permit programs, serving as department representative to industry stakeholders, improving data analysis and reporting, and analyzing new policies and court decisions in relations to the unit.

Chief of Staff: Chief of Staff Office is responsible for coordinating the Agency's special projects, strategic planning, performance measurement, process improvements, and conducting general research and analysis. This position may support the team's efforts to analyze, transform, and visualize data for performance metrics, create and publish internal and public-facing dashboards, and prepare analyses to empower internal accountability-focused discussions. The position may coordinate policy development, organize teams, facilitate working groups, and conduct general research.

What You’ll Be Doing

 Essential Duties and Responsibilities: 

• 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:

The stated desirable qualifications may be used to identify candidates advancing to the interview process and/or to identify job finalist(s) at the end of the selection process when referred for hiring.

• Experience developing equity metrics/key performance indicators (KPIs), including racial equity metrics, transportation equity metrics, mobility justice metrics
• Program planning, service delivery or direct engagement experience with Native American/American Indian, Black/African American, Latina/o/x, Pacific Islander, Asian and/or marginalized populations.
• Knowledge of statistical and analytical methods, inclusive of qualitative and quantitative evaluation methods.
• Process improvement experience using SharePoint or other process automation systems
• Experience in public sector contracting and procurement (local, state or federal government)
• Experience in strategic planning and budget management for staffing needs.
• Advanced proficiency in utilizing Microsoft Office Suite (ie: Microsoft Word, Access, Teams, and Outlook), including advanced ability using Excel (i.e., spreadsheets, pivot tables, macros, and/or PowerQuery)
• Experience working with senior-level staff, including the ability to disseminate information and present/report out to management
• Proficient in managing multiple sources of data; ability to identify trends, design reports, and conduct audit and analysis of data.
• Experience working on Diversity, Equity & Inclusion (DEI) initiatives
• Knowledge of project management software, such as EcoSys, Primavera P6, and TimeControl.

What else should I know?

Verification: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

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.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Selection Procedures: This is a Position Based Test conducted in accordance with Civil Service Rule 111A. After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following: 

1. Minimum Qualification Supplemental Questionnaire (MQSQ); and
2. Written Core Exam
 

Minimum Qualification Supplemental Questionnaire (Weight - Qualifying): Candidates will be required to complete a MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possess the required minimum qualifications.

Written Core Exam (Weight: 100%): Candidates will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include but not be limited to: Ability to evaluate/analyze information/data and to exercise good judgment relative to that evaluation or analysis; Ability to communicate written information (includes ability to proofread) Knowledge of, and ability to apply, financial/fiscal principles (including the ability to use mathematical and statistical formulas); Ability to comprehend and understand written information; Ability to use various computer software programs; Ability to conduct research; Ability to establish and maintain cooperative and effective working relationships; Knowledge of, and the ability to apply, principles, practices and procedures involving office operations; This is a standardized examination and, therefore, test questions and test answers are not available for public inspection or review.

Exam Analyst Information: If you have any questions regarding the Exam Process, please contact the exam analyst, Pierre.Aguirre@sfmta.com. Please note: all your information will be kept confidential according to EEO guidelines. PA | PBT-1823-T00055 | CPE 

What Else Should I Know?

Certification Rule: The certification rule for the eligible list resulting from this examination will be Rule of Five (5) scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.

Eligible List/Score Report:  A confidential eligible list/score report of applicant names that have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list/score report, shall not be made public unless required by law. However, an eligible list/score report shall be made available for public inspection, upon request, once the eligible list/score report is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Director of Transportation or the Civil Service Commission.

The duration of the eligible list/score report resulting from this examination process will be of 12 months and may be extended with the approval of the Director of Transportation. 

Terms of Announcement and Appeal Rights:  

Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at Careers with Purpose | City and County of San Francisco (sf.gov).

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

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

• Information About The Hiring Process
• Multiple-Choice Test Preparation Manual 
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement
• SFMTA Employee Wellness Program
• Veterans Preference
• Seniority Credit in Promotional Exams  

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.