AC Transit
Statistical Data and Information Analyst
AC Transit, Oakland, California, United States, 94616
Salary :
$119,558.00 - $142,804.00 Annually
Location :
Downtown Oakland, CA
Job Type:
Regular Full Time
Job Number:
24-00091
Department:
Planning & Engineering
Division:
Business Sciences
Opening Date:
09/27/2024
Closing Date:
10/14/2024 11:59 PM Pacific
Summary
AC Transit is currently seeking candidates for the position of Statistical Data and Information Analyst. Under general supervision, this position, collects, maintains, synthesizes, and analyzes data from numerous sources; initiates studies; presents results to a wide variety of audiences; and acts as a resource to other departments for the development of methodologies and statistically valid reports.
This is an excellent opportunity to work for the largest bus agency in California, make a difference in our local community, and promote AC Transit as a great employer of the East Bay. In addition to working with some of the best in the business, AC Transit also has an excellent benefits package that includes pension, medical, dental and vision coverage, flexible spending, and 457 savings plan.Representative Functions
Collects, maintains, analyzes, and assists in the interpretation of service and performance data from a wide variety of internal District databases and software systems, as well as external sources.Conducts research; and designs and develops technical studies involving operational, performance, or financial data and information, in cooperation with various District departments.Designs and develops research designs and methodologies, data collection instruments, protocols for coding and tabulation, and reporting standards to ensure the accurate collection, analysis, and interpretation of data.Designs, develops, and presents reports and presentations that include narrative written analysis, statistical summaries, tables, and other graphic representations of data.Maintains, tests, and verifies the integrity of data by identifying and resolving problems with data files and software interfaces.Provides consulting services to other District departments; and consults with external organizations to gather data and information, and to provide data analysis and interpretation.Travels locally to other District facilities, and may supervise or perform field studies within the AC Transit District.May supervise and/or provide work direction to District personnel conducting surveys, or otherwise engaged in the collection and tabulation of data.Provides data, information, and analysis for the development of District policies, procedures, and standards.Provides analysis and interpretation of non-statistical information.Performs related duties as required.
Minimum Qualifications
Education : A Bachelor's degree in Statistics, Mathematics, Information Systems, Business Administration, Marketing Research, Economics, Industrial-Organizational Psychology, Social Sciences, or a similar field that included extensive coursework in statistical analysis.
Experience : Five (5) years of progressively responsible experience in the statistical analysis and interpretation of data and information; including verifiable experience with databases, as well as the reporting and presentation of data to a wide variety of audiences.
Special Requirement
:
Must be willing to: (1) work outside regular business hours as required by implementation of special projects, and emergencies; and (2) travel between the various District facilities as required.
Desirable Skills:
Previous experience as a Business Intelligence Analyst, Data Scientist, Business Analyst or Data AnalystPrevious experience with coding, R Python, GIS, data modeling, SPSS, or similar coding processesPrevious experience with SQL, Database Environments, pulling data, creating BI Dashboards, and telling the business story using data-driven insightsPrevious experience with Power BI, Tableau, and/or other Open Source tools
Additional Information
Physical Requirements:
(1) Must maintain the physical condition necessary to perform tasks in an office setting operating a personal computer, keyboards, and other peripheral equipment. (2) Must maintain the mobility necessary to perform fieldwork at locations within the AC Transit District.
THIS POSITION IS A UNION POSITION, REPRESENTED BY AFSCME
The Selection Process:
The Human Resources department must receive a completed online application by the filling date. If this recruitment is "Continuous," it may be closed at any time without notice. Applications will be screened for job related qualifications, and those candidates who best meeting the qualifications listed on this Job Announcement will be invited to participate in an examination process that may include written, oral and/or performance segments. Current District employees must have satisfactory attendance and performance records. Finalists will be placed on an Eligibility List. When filling vacancies, the Human Resources Department will refer the top candidates to the hiring department for final screening and recommendation.
Vaccination Requirement for Candidates Seeking Employment:
Alameda-Contra Costa Transit District has implemented a requirement that requires all candidates for District employment to be fully vaccinated for COVID-19, including variants, prior to being employed by the District, subject to limited exceptions. AC Transit adopted this vaccination policy as an emergency public health response to mitigate the negative public health consequences associated with increased incidence and test positivity rates and the prevalence of new virus variants, including increased hospitalizations, intensive care unit admissions, and deaths.
As such, candidates seeking District employment will be required to: (1) be fully vaccinated (two weeks after completion of the entire recommended COVID-19 vaccination series) and (2) submit a copy of their COVID-19 vaccination card prior to their start date, unless a reasonable accommodation request for a medical or religious exemption has been approved.
Benefits:
The transit professionals who call AC Transit home represent the rich cultural diversity of the Bay Area. For more than 60 years, we have been an equal opportunity employer honoring religion, ethnic background, national origin, gender, gender expression, genetic information, disabilities, age, and veteran status. We are not only an inclusive employer but also offer a comprehensive benefits package rooted in choice, flexibility, and affordability. Most Benefits are effective the first of the month following your hire date. Employees and eligible dependents have access to the following benefits*:
Medical - Choice of two Health Maintenance Organizations (HMOs): Kaiser Permanente and Health Net. $10.00 office visit co-pays; $5.00 - $35.00 prescription co-pays.Dental - MetLife Preferred Provider Organization (PPO) $50 annual deductible per person/$150 per family; $3,000 per person annual maximum; preventative care covered at 100%; basic and major care covered at 90%; $4,000 lifetime maximum orthodontia covered at 50%.Vision - Vision Service Plan - $10.00 copay; eligible for an exam, lenses, frames or contact lenses every 12 months - based on the last date of service. $200 frame allowance or $120 allowance for contact lenses.Employer paid Basic Life InsuranceEmployee paid Voluntary Term Life InsuranceEmployee Assistance Program (EAP)Flexible Spending Accounts (FSA) for Health Care, Dependent Care, Parking, TransitAC Transit contributes up to $50.00/month towards an employee's FSA Transit costsFree AC Transit Bus PassFederal Credit UnionVacation and Sick Leave or Personal Time OffTen (10) paid holidays; 2 paid floating holidays; 1 paid birthday holidayTuition Reimbursement - up to $2500 per fiscal year on approved coursesWellness Program*AC Transit benefits are negotiated and subject to change based on collective bargaining agreements.
Pension:
All AC Transit employees participate in a lifetime defined benefit pension. All employees hired on or after January 1, 2020, may be in the District's Tier II pension plan covered by the Public Employees' Pension Reform Act of 2013 (PEPRA). As such, he/she may be required to contribute a small portion of annual income towards the cost of his/hers District pension.
ADA Compliant and Drug Free Workplace:
The Human Resources Department will make reasonable efforts in the recruitment/examination process to accommodate applicants with disabilities. If you have a need for an accommodation, please call Human Resources at (510) 891-4783.
The Alameda Contra Costa Transit District has established the goal of a 100 percent drug and alcohol-free workplace. Applicants will be required to undergo drug and alcohol testing prior to employment and those in safety sensitive positions will be subject to further drug and alcohol testing through their period of employment, including random drug and alcohol testing.
In accordance with federal requirements, all job applicants selected for appointments in a safety sensitive position are subject to pre-employment drug and alcohol testing. A final job applicant will be tested for five prohibited drugs: Cocaine, PCP, Amphetamines, Marijuana and Opiates. During employment, employees holding safety sensitive positions are subject to random, reasonable suspicion, post-accident, return-to-duty, and follow-up drug and alcohol testing. Additionally, in the event of an absence of more than 90 days from a safety sensitive position, pre-employment drug testing will be performed.
Equal Opportunity Employer
PEPRA:
All employees hired on or after January 1, 2020, will be in the District's Tier II pension plan covered by the Public Employees' Pension Reform Act of 2013 (PEPRA). As such, he/she may be required to contribute 7% or more of annual income towards the cost of his/hers District pension.
Medical, dental, orthodontic, vision, and prescription insurance coverage for employees and qualified dependents; plus regular retirement pension with a five (5) year vesting. Depending on length of service, up to six (6) weeks of vacation and up to twelve (12) days of sick leave per year. Holidays: eleven (11) per year. Free transportation on AC Transit system. Group Life Insurance.
01
Provide a brief example of a study you designed in a previous role, showcasing your expertise in advanced statistical methods, predictive analytics, and data practices.
02
Describe your experience building BI dashboards and reports for end-user analysis. Include any other relevant analytical tools you use (e.g., SQL, R, Python, GIS, SPSS)
03
Describe a written report you created to present a key study. Include the data and analysis you presented, the audience, and how you communicated the findings.
Required Question
$119,558.00 - $142,804.00 Annually
Location :
Downtown Oakland, CA
Job Type:
Regular Full Time
Job Number:
24-00091
Department:
Planning & Engineering
Division:
Business Sciences
Opening Date:
09/27/2024
Closing Date:
10/14/2024 11:59 PM Pacific
Summary
AC Transit is currently seeking candidates for the position of Statistical Data and Information Analyst. Under general supervision, this position, collects, maintains, synthesizes, and analyzes data from numerous sources; initiates studies; presents results to a wide variety of audiences; and acts as a resource to other departments for the development of methodologies and statistically valid reports.
This is an excellent opportunity to work for the largest bus agency in California, make a difference in our local community, and promote AC Transit as a great employer of the East Bay. In addition to working with some of the best in the business, AC Transit also has an excellent benefits package that includes pension, medical, dental and vision coverage, flexible spending, and 457 savings plan.Representative Functions
Collects, maintains, analyzes, and assists in the interpretation of service and performance data from a wide variety of internal District databases and software systems, as well as external sources.Conducts research; and designs and develops technical studies involving operational, performance, or financial data and information, in cooperation with various District departments.Designs and develops research designs and methodologies, data collection instruments, protocols for coding and tabulation, and reporting standards to ensure the accurate collection, analysis, and interpretation of data.Designs, develops, and presents reports and presentations that include narrative written analysis, statistical summaries, tables, and other graphic representations of data.Maintains, tests, and verifies the integrity of data by identifying and resolving problems with data files and software interfaces.Provides consulting services to other District departments; and consults with external organizations to gather data and information, and to provide data analysis and interpretation.Travels locally to other District facilities, and may supervise or perform field studies within the AC Transit District.May supervise and/or provide work direction to District personnel conducting surveys, or otherwise engaged in the collection and tabulation of data.Provides data, information, and analysis for the development of District policies, procedures, and standards.Provides analysis and interpretation of non-statistical information.Performs related duties as required.
Minimum Qualifications
Education : A Bachelor's degree in Statistics, Mathematics, Information Systems, Business Administration, Marketing Research, Economics, Industrial-Organizational Psychology, Social Sciences, or a similar field that included extensive coursework in statistical analysis.
Experience : Five (5) years of progressively responsible experience in the statistical analysis and interpretation of data and information; including verifiable experience with databases, as well as the reporting and presentation of data to a wide variety of audiences.
Special Requirement
:
Must be willing to: (1) work outside regular business hours as required by implementation of special projects, and emergencies; and (2) travel between the various District facilities as required.
Desirable Skills:
Previous experience as a Business Intelligence Analyst, Data Scientist, Business Analyst or Data AnalystPrevious experience with coding, R Python, GIS, data modeling, SPSS, or similar coding processesPrevious experience with SQL, Database Environments, pulling data, creating BI Dashboards, and telling the business story using data-driven insightsPrevious experience with Power BI, Tableau, and/or other Open Source tools
Additional Information
Physical Requirements:
(1) Must maintain the physical condition necessary to perform tasks in an office setting operating a personal computer, keyboards, and other peripheral equipment. (2) Must maintain the mobility necessary to perform fieldwork at locations within the AC Transit District.
THIS POSITION IS A UNION POSITION, REPRESENTED BY AFSCME
The Selection Process:
The Human Resources department must receive a completed online application by the filling date. If this recruitment is "Continuous," it may be closed at any time without notice. Applications will be screened for job related qualifications, and those candidates who best meeting the qualifications listed on this Job Announcement will be invited to participate in an examination process that may include written, oral and/or performance segments. Current District employees must have satisfactory attendance and performance records. Finalists will be placed on an Eligibility List. When filling vacancies, the Human Resources Department will refer the top candidates to the hiring department for final screening and recommendation.
Vaccination Requirement for Candidates Seeking Employment:
Alameda-Contra Costa Transit District has implemented a requirement that requires all candidates for District employment to be fully vaccinated for COVID-19, including variants, prior to being employed by the District, subject to limited exceptions. AC Transit adopted this vaccination policy as an emergency public health response to mitigate the negative public health consequences associated with increased incidence and test positivity rates and the prevalence of new virus variants, including increased hospitalizations, intensive care unit admissions, and deaths.
As such, candidates seeking District employment will be required to: (1) be fully vaccinated (two weeks after completion of the entire recommended COVID-19 vaccination series) and (2) submit a copy of their COVID-19 vaccination card prior to their start date, unless a reasonable accommodation request for a medical or religious exemption has been approved.
Benefits:
The transit professionals who call AC Transit home represent the rich cultural diversity of the Bay Area. For more than 60 years, we have been an equal opportunity employer honoring religion, ethnic background, national origin, gender, gender expression, genetic information, disabilities, age, and veteran status. We are not only an inclusive employer but also offer a comprehensive benefits package rooted in choice, flexibility, and affordability. Most Benefits are effective the first of the month following your hire date. Employees and eligible dependents have access to the following benefits*:
Medical - Choice of two Health Maintenance Organizations (HMOs): Kaiser Permanente and Health Net. $10.00 office visit co-pays; $5.00 - $35.00 prescription co-pays.Dental - MetLife Preferred Provider Organization (PPO) $50 annual deductible per person/$150 per family; $3,000 per person annual maximum; preventative care covered at 100%; basic and major care covered at 90%; $4,000 lifetime maximum orthodontia covered at 50%.Vision - Vision Service Plan - $10.00 copay; eligible for an exam, lenses, frames or contact lenses every 12 months - based on the last date of service. $200 frame allowance or $120 allowance for contact lenses.Employer paid Basic Life InsuranceEmployee paid Voluntary Term Life InsuranceEmployee Assistance Program (EAP)Flexible Spending Accounts (FSA) for Health Care, Dependent Care, Parking, TransitAC Transit contributes up to $50.00/month towards an employee's FSA Transit costsFree AC Transit Bus PassFederal Credit UnionVacation and Sick Leave or Personal Time OffTen (10) paid holidays; 2 paid floating holidays; 1 paid birthday holidayTuition Reimbursement - up to $2500 per fiscal year on approved coursesWellness Program*AC Transit benefits are negotiated and subject to change based on collective bargaining agreements.
Pension:
All AC Transit employees participate in a lifetime defined benefit pension. All employees hired on or after January 1, 2020, may be in the District's Tier II pension plan covered by the Public Employees' Pension Reform Act of 2013 (PEPRA). As such, he/she may be required to contribute a small portion of annual income towards the cost of his/hers District pension.
ADA Compliant and Drug Free Workplace:
The Human Resources Department will make reasonable efforts in the recruitment/examination process to accommodate applicants with disabilities. If you have a need for an accommodation, please call Human Resources at (510) 891-4783.
The Alameda Contra Costa Transit District has established the goal of a 100 percent drug and alcohol-free workplace. Applicants will be required to undergo drug and alcohol testing prior to employment and those in safety sensitive positions will be subject to further drug and alcohol testing through their period of employment, including random drug and alcohol testing.
In accordance with federal requirements, all job applicants selected for appointments in a safety sensitive position are subject to pre-employment drug and alcohol testing. A final job applicant will be tested for five prohibited drugs: Cocaine, PCP, Amphetamines, Marijuana and Opiates. During employment, employees holding safety sensitive positions are subject to random, reasonable suspicion, post-accident, return-to-duty, and follow-up drug and alcohol testing. Additionally, in the event of an absence of more than 90 days from a safety sensitive position, pre-employment drug testing will be performed.
Equal Opportunity Employer
PEPRA:
All employees hired on or after January 1, 2020, will be in the District's Tier II pension plan covered by the Public Employees' Pension Reform Act of 2013 (PEPRA). As such, he/she may be required to contribute 7% or more of annual income towards the cost of his/hers District pension.
Medical, dental, orthodontic, vision, and prescription insurance coverage for employees and qualified dependents; plus regular retirement pension with a five (5) year vesting. Depending on length of service, up to six (6) weeks of vacation and up to twelve (12) days of sick leave per year. Holidays: eleven (11) per year. Free transportation on AC Transit system. Group Life Insurance.
01
Provide a brief example of a study you designed in a previous role, showcasing your expertise in advanced statistical methods, predictive analytics, and data practices.
02
Describe your experience building BI dashboards and reports for end-user analysis. Include any other relevant analytical tools you use (e.g., SQL, R, Python, GIS, SPSS)
03
Describe a written report you created to present a key study. Include the data and analysis you presented, the audience, and how you communicated the findings.
Required Question