Senior Administrative Analyst, AFSCME (Transportation)

San Francisco Bay Area Rapid Transit District (BART); Oakland (CA); On-site; USD 128,000 - 156,000; Full time

Job summary

BART in Oakland is seeking a Senior Administrative Analyst to support the Transportation Department's administrative, operational, audit and financial functions. The role focuses on strategic planning, process improvement, data analysis, and cross‑functional collaboration to drive organizational effectiveness.

The ideal candidate will have strong Excel expertise, experience with complex analyses, and the ability to work with internal departments and external stakeholders to monitor commitments

Qualifications

• Experience supporting complex administrative, operational, financial and process improvement projects.
• Proficient in advanced Excel features (PivotTables, INDEX/MATCH, VLOOKUP/XLOOKUP).
• Ability to prepare complex statistical and financial reports for management.
• Strong collaboration with internal/external stakeholders on project commitments.
• Ability to review and maintain departmental procedures and documentation.

Responsibilities

• Support development and analysis of the annual budget and staffing/capital requests.
• Forecast funds for staffing, equipment and projects; prepare budget presentations.
• Assist with policy and procedural modifications and implementation plans.
• Implement new systems, monitor progress and advise management on updates.
• Coordinate organizational studies of administrative or operational processes.
• Develop and administer special administrative programs and analyze trends.
• Provide organizational development support and data-driven recommendations.
• Participate in special projects including budget analysis and feasibility studies.
• Train employees in administrative methods and procedures.
• Oversee office activities, procure supplies, and manage invoices.

Skills

Advanced Excel

Budget analysis

Data analysis

Cross-functional collaboration

Report writing

Education

Bachelor's degree in business administration, public administration, accounting, economics or related field

Job description

Pay Rate:
AFSCME Pay Grade A13
Annual Salary: $128,356.80/year (Step 1) - $156,020.80/year (Step 5)
Note: The negotiable salary offer will be commensurate with education and experience.

Reports To: Group Manager, Operations Support and Review

Days Off: Saturday/Sunday

Who May Apply: All current BART employees and Future BART employees

Current Assignment:

This announcement will be used to create an eligibility list to backfill future vacancies that may occur within the next twelve (12) months.

The Transportation Department is seeking a highly motivated, analytical, and collaborative professional to serve as a Senior Administrative Analyst supporting the department's administrative, operational, audit, and financial functions in a dynamic, fast-paced environment. This position offers the opportunity to play a key role in advancing organizational effectiveness through strategic planning, process improvement, data analysis, and cross-functional collaboration.

The ideal candidate is an innovative problem solver who thrives in a complex organization, enjoys developing new processes and organizational capabilities, and is committed to delivering high-quality analytical support that drives informed business and operational decisions. Experience working in a large public agency, government organization, or similarly complex corporate environment is highly desirable.

The most qualified candidates for this position will have highly developed competencies in the following areas, which will be reinforced in the related work experience and will be articulated during the selection process:

• Demonstrated experience in supporting complex administrative, operational, financial, and process improvement projects from planning through implementation.
• Experience using advanced Microsoft Excel features, including PivotTables and complex formulas such as INDEX/MATCH, VLOOKUP/XLOOKUP, or nested IF statements.
• Accomplished in preparing complex statistical, financial, operational, and analytical reports for management to support strategic planning, performance monitoring, and decision-making.
• Proficient in partnering with internal departments and external stakeholders to monitor project commitments, resolve issues, and ensure timely completion of assigned initiatives.
• Skilled in reviewing, editing, and maintaining departmental procedures, reports, and other technical documentation to ensure accuracy, clarity, and consistency.

Responsibilities

1. Performs a variety of complex administrative, operational, and analytical duties in support of department or division activities; coordinates project activities with District departments, divisions and external organizations.
2. Coordinates the development, analysis and formulation of the annual budget; develops guidelines and instruction on budget process and procedures; reviews requests for staffing and capital outlay; forecasts funds needed for staffing, equipment and various projects; prepares departmental budget presentations; plans, receives, pays, and improves invoices, generates budget reports; provides status updates to appropriate Manager or Managing Director.
3. Assists with the implementation of policy and procedural modifications; evaluates impact on divisions or departments; develops implementation plans; recommends and implements modifications.
4. Implements new systems, methods and procedures; monitors program progress in meeting goals and objectives; conducts updates with management staff to inform and advise on project progress; makes adjustments as necessary.
5. Coordinates and participates in District department or division organizational studies involving administrative or operational systems, procedures, functions, processes and techniques.
6. Develops, implements and administers special administrative programs; analyzes current and historical trends; prepares and presents reports.
7. Provides assistance in organizational development in assigned areas; identifies issues; collects data; analyzes alternatives and makes recommendations.
8. Participates in special projects including research of new programs and services, budget analysis and preparation, and feasibility analyses; prepares and presents reports.
9. Trains assigned employees in their area of work including administrative methods, procedures and techniques.
10. Oversees general office activities; procures supplies; approves invoices; develops personnel schedules; responds to inquiries; investigates complaints; provides general analytical support.
11. Represents assigned area at various meetings with other departments, divisions, outside agencies and contractors; communicates projects and activities with others as appropriate; prepares for and provides assistance with hosting and participating in transportation related meetings and events.
12. Responds to and resolves difficult and sensitive inquiries and complaints.

Education

A Bachelor’s degree in business administration, public administration, accounting, economics or a related field from an accredited college or university.

Experience

Three (3) years of (full-time equivalent) verifiable professional administrative, analytical and/or budgetary experience.

Substitution

Additional professional experience as outlined above may be substituted for the education on a year-for-year basis. A college degree is preferred.

Knowledge of

• Operationalcharacteristics,servicesandactivitiesofassignedprogramarea includingadministrative,financial,oroperationsfunctions.
• Principlesandpracticesofprogramdevelopmentandimplementation.
• Principlesandpracticesofbudgetpreparationandadministration.
• Methodsofadministrative,organizational,economic,andproceduralanalysis.
• Methodsandtechniquesofstatisticalandfinancialanalysis.
• Businesscomputerapplicationsforstatisticalanalysisanddatamanagement.
• Principlesandpracticesofprocurement,purchasing,andaccounting.
• Methodsandtechniquesusedtoconductavarietyofanalyticalstudies.
• Principles,practices,methodsandtechniquesofreportpreparation.
• Principlesandproceduresofrecordkeeping.
• Officeequipmentincludingcomputers,supportingwordprocessing,and spreadsheetapplications.
• RelatedFederal,stateandlocallaws,codesandregulations.

Skill in

• Performing complex analyticalduties.
• Preparing,administeringandmonitoringcapitalandoperatingbudgets.
• Maintainingaccuraterecordsandfiles.
• Preparingclearandconciseadministrative,budgetary,andfinancialreports.
• Collecting,evaluatingandinterpretingcomplexinformationanddata.
• Reviewingandanalyzingcomplextechnicaldocumentsandproposals.
• Analyzingcomplexproblems,identifyalternativesolutionsandrecommend conclusions.
• Workingindependentlyintheabsenceofsupervision.
• Interpretingandapplylaws,policies,rulesandregulations.
• Establishingandmaintainingeffectiveworkingrelationshipswiththosecontactedin the course ofwork.
• Communicating clearly and concisely, both orally and in writing.
• Operating office equipment including computers and supporting word processing and spreadsheet applications.