Workforce Data Analyst

Job Description:

Workforce Data Analyst

Description

Marketing Statement

Ride BART to a satisfying career that lets you both: 1) make a difference to Bay Area residents, and 2) enjoy excellent pay, benefits, and employment stability. BART is looking for people who like to be challenged, work in a fast-paced environment, and have a passion for connecting riders to work, school and other places they need to go. BART offers a competitive salary, comprehensive health benefits, paid time off, and the CalPERS retirement program.

Job Summary

Pay Rate

Non-Rep Pay Grade N04

$110,193.00/annually - $166,944.00/annually

The initial annual salary for this assignment is negotiable between $110,193.00 - $138,568.50, commensurate with education and experience.

Reports To
Manager of Absence Management

Current Assignment

BART's Absence Management Division is looking for a highly motivated and skilled Data Analyst to join our dynamic team of Human Resources and Data Analytics professionals. This role involves identifying key absence data to produce meaningful reports and insights, supporting the continuous improvement of time and attendance processes, and collaborating with stakeholders on attendance data analysis, visualizations, and presentations essential for maintaining the safe and reliable operation of the BART system and ensuring the delivery of world-class transit services to the Bay Area.

The incumbent will work independently on enhancing and streamlining attendance data analytics, collaborating with cross-functional teams to resolve employee time and attendance issues, and managing time reporting discrepancies.

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

• Track absenteeism rates over time to identify patterns and areas of opportunity.
• Strong written and verbal communication skills and the ability to clearly communicate complex topics in an accessible and easy way to understand.
• Strong analytical and problem-solving skills.
• Work with complex data and perform routine statistical analyses on absence data.
• Ability to leverage various computer systems and applications in conducting analyses, including strong Microsoft Excel formulas and functions skills. Familiarity with Power BI, and other automation programs.
• Analyze absence trends and time reporting inconsistencies.
• Develop procedures for tracking absence costs in correlation to overtime and other expenses driven by absenteeism.
• The ability to clearly communicate findings and strategy recommendations to management in verbal, written, and other visual forms.

Selection Process
Applications will be screened to assure that minimum qualifications are met. Those applicants who meet minimum qualifications will then be referred to the hiring department for the completion of further selection processes.

The selection process for this position may include a skills/performance demonstration, a written examination, and a panel and/or individual interview.

The successful candidate must have an employment history demonstrating reliability and dependability; provide copies of certificates, diplomas or other documents as required by law, including those establishing his/her right to work in the U. S; pass a pre-employment medical examination which may include a drug and alcohol screen, and which is specific to the essential job functions and requirements. Pre-employment processing will also include a background check. (Does not apply to current full-time District employees unless specific job requires additional evaluations).Application Process

Application Process
External applicants may only apply online, at www.bart.gov/jobs. Applicants needing assistance with the online application process may receive additional information by calling (510) 464-6112.

Current employees are strongly encouraged to apply online, either at www.bart.gov/jobs , or on Employee Connect. Current employees may also apply using a BART paper application by delivering the completed form to the Human Resources Department, or by mailing it to P.O. Box 12688, Oakland, CA 94604-2688.

All applicants are asked to complete the application in full, indicating dates of employment, all positions held, hours worked, and a full description of duties. Online applicants are invited to electronically attach a resume to the application form to provide supplemental information but should not consider the resume a substitute for the application form itself.

Examples of Duties

Collects, cleans, validates, and analyzes workforce data from multiple sources to ensure accuracy and integrity.

Develops reports, dashboards, and visualizations to communicate trends and support strategic business operations decisions.

Performs in-depth analysis of workforce data including but not limited to absenteeism, leave usage, turnover, compensation, and recruiting outcomes.

Utilizes advanced spreadsheet features such as pivot tables, data transformation and preparation tools, nested functions, and macros to develop detailed and informative analyses.

Supports functional areas such as absence management, benefits, classification and compensation, human resources information systems, leave management, and workforce development with relevant analytics and reports.

Partners with internal stakeholders including Payroll, Time and Accounting Administration, Office of the Chief Information Officer, and Human Resources staff to resolve data discrepancies and help streamline data flow between systems.

Tracks and analyzes leave data and prepares periodic absence trend reports.

Prepares compliance-focused reports and data files for internal audits, public records requests, and records requests from regulatory agencies.

Collaborates with other departments to translate data to actionable recommendations and improved business practices.

Ensures security and confidentiality of sensitive employee information in all data handling activities.

Develops and maintains documentation for recurring reports, processes, and data governance.

Participates in system implementations, upgrades, and testing activities for human resources systems and databases, as assigned.



Minimum Qualifications

Education :

Bachelor’s degree in business administration, computer science, data analytics, statistics, information systems, or a related field from an accredited college or university.

Experience :

The equivalent of two (2) years of full-time professional experience performing data analysis for business operations, financial reporting, workforce reporting, or a similar function.

Substitution :

Additional experience may be substituted for the required education on a year-for-year basis.

Knowledge and Skills

Knowledge of :

• Mathematical and statistical methods and data analysis techniques
• Theories, principles, and practices of research, data processing, and statistical analysis
• Advanced spreadsheet functionality, including pivot tables, functions, formulas, conditional formatting, dashboards, and macros
• Applicable information systems, databases, and data governance principles
• Current data visualization software and tools that are commonly used
• Methods for ensuring data privacy, confidentiality, and information security
• Public sector HR operations, labor agreements, and/or civil service rules depending on area of assignment
• Related federal, state, and local laws, codes, and regulations
  
  

Skill in :

• Working with large datasets and multiple data sources
• Collecting, maintaining, managing, analyzing, interpreting, and disseminating data and information from a wide variety of ongoing data-streams from internal and external sources
• Designing data collection instruments and developing methodologies to collect data
• Analyzing and interpreting complex datasets
• Making sense of complex, high-quantity, and sometimes contradictory information to effectively solve problems
• Utilizing commonly used spreadsheet applications and data visualization tools to communicate findings
• Cleaning and validating data from multiple sources
• Automating routine reports and tasks using macros, functions, and/or formulas
• Documenting and maintaining procedures and analytical models
• Utilizing current software commonly used for statistical analysis, word processing, presentations, and emails
• Interpreting, applying, and ensuring compliance with applicable policies, procedures, laws, and regulations
• Solving problems independently and collaboratively
• Analyzing problems, identifying alternative solutions, assessing consequences of proposed actions, and implementing recommendations
• Operating office equipment and technology tools, including desktop computers, laptop computers, printers, and presentation equipment
• Presenting technical data clearly to non-technical stakeholders
• Communicating effectively verbally and in writing
• Presenting information, proposals, and recommendations clearly and persuasively
• Establishing and maintaining effective working relationships with all internal and external contacts
• Maintaining discretion and confidentiality in all data-related activities
  
  

Working Conditions
Environmental Conditions :

Office environment; exposure to computers.

Physical Conditions :

May require maintaining physical condition necessary for walking, standing or sitting for prolonged periods of time.

Equal Employment Opportunity GroupBox1

The San Francisco Bay Area Rapid Transit District is an equal opportunity employer. Applicants shall not be discriminated against because of race, color, sex, sexual orientation, gender identity, gender expression, age (40 and above), religion, national origin (including language use restrictions), disability (mental and physical, including HIV and AIDS), ancestry, marital status, military status, veteran status, medical condition (cancer/genetic characteristics and information), or any protected category prohibited by local, state or federal laws.

The BART Human Resources Department will make reasonable efforts in the examination process to accommodate persons with disabilities or for religious reasons. Please advise the Human Resources Department of any special needs in advance of the examination by emailing at least 5 days before your examination date at employment@bart.gov .

Qualified veterans may be eligible to obtain additional veteran's credit in the selection process for this recruitment (effective Jan. 1, 2013). To obtain the credit, veterans must attach to the application a DD214 discharge document or proof of disability and complete/submit the Veteran's Preference Application no later than the closing date of the posting. For more information about this credit please go to the Veteran's Preference Policy and Application link at www.bart.gov/jobs .

The San Francisco Bay Area Rapid Transit District (BART) prides itself in offering best in class benefits packages to employees of the District. Currently, the following benefits may be available to employees in this job classification.

Highlights

• Medical Coverage (or $350/month if opted out)
• Dental Coverage
• Vision Insurance (Basic and Enhanced Plans Available)
• Retirement Plan through the CA Public Employees’ Retirement System (CalPERS)
  • 2% @ 55 (Classic Members)
  • 2% @ 62 (PEPRA Members)
  • 3% at 50 (Safety Members - Classic)
  • 2.7% @ 57 (Safety Members - PEPRA)
  • Reciprocity available for existing members of many other public retirement systems (see BART website and/or CalPERS website for details)
• Money Purchase Pension Plan (in-lieu of participating in Social Security tax)
  • 6.65% employer contribution up to annual maximum of $1,868.65
• Deferred Compensation & Roth 457
• Sick Leave Accruals (12 days per year)
• Vacation Accruals (3-6 weeks based on time worked w/ the District)
• Holidays: 9 observed holidays and 5 floating holidays
• Life Insurance w/ ability to obtain additional coverage
• Accidental Death and Dismemberment (AD&D) Insurance
• Survivor Benefits through BART
• Short-Term Disability Insurance
• Long-Term Disability Insurance
• Flexible Spending Accounts: Health and Dependent Care
• Commuter Benefits
• Free BART Passes for BART employees and eligible family members.

Closing Date/Time: 11/7/2025 11:57 PM Pacific

Salary:

$110,193.00 - $166,944.00 Annually