Workforce Data Analyst chez San Francisco Bay Area Rapid Transit District (BART), CA
San Francisco Bay Area Rapid Transit District (BART), CA · Oakland, États-Unis d'Amérique · Onsite
- Professional
- Bureau à Oakland
About the Department
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
This posting will close after receipt of 100 applications or on November 3, 2025; whichever comes first.
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.
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.
Position 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.
Other Qualifications
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
- 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.
