Senior Data Analyst

Maintaining efficiency and economy in operations management requires flexibility in job assignments.

While each employee shall have a primary responsibility for the job in which that employee has been hired or later promoted to, each employee may be expected to perform other jobs from time to time.

SUMMARY: MTS relies heavily on performance metrics when developing and evaluating transportation services in the San Diego region.

A vast amount of data is generated by various sources, including on-board transit management systems, fare collection databases, transportation software applications, and communications equipment.

This position will be responsible for assisting in the accurate collection of data from multiple sources, managing our data set, developing reports and troubleshooting data issues.

The Data Analyst will work closely with internal departments including Information Technology, Bus and Rail Operations, Finance and Marketing.

This position is also responsible for the collection and accurate reporting of data to outside entities including other government agencies, auditors and community organizations.

EXAMPLES OF DUTIES: Essential Functions Works with management to prioritize business and information needs.

Supports the enterprise data warehouse in identifying improvements.

Prepares and submits reports required for agency, local, state, and federal agencies Periodic oral and written reports to the Board and executive management.

Supervises and evaluates the work of junior Data Analyst staff.

Duties May Include, But Are Not Limited To, The Following: Data Administration Works with the Information Technology Department to provide quality assurance of imported data.

Assists with development of specifications for new data-generating systems.

Evaluates changes and updates to data production sources.

Filters and “cleans” data by reviewing reports and performance indicators to identify source data problems.

Identifies, analyzes and interprets trends or patterns in complex data sets.

Administers validation requirements of data collection systems.

Data Reporting Assists with managing and designing the reporting environment.

Generates reports from single or multiple systems.

Collects and reports on data for internal and external purposes, including, but not limited to: Annual, monthly, and weekly National Transit Database reporting.

Annual and quarterly Performance Monitoring Reports.

Federal, local, and state audits.

Other Assists Information Technology Department with data collection and reporting for the data warehouse.

Oversees junior Data Analyst staff, including assigning and reviewing work and evaluating performance.

Performs other duties as assigned.

QUALIFICATIONS: Knowledge, Skills and Abilities Knowledge of or ability to learn MTS policies and regulations; ability to read, understand and apply MTS policies, regulations and union labor contracts; ability to write letters, memoranda and reports using clear, concise and grammatically correct English; ability to speak clearly, distinctly and effectively in person-to-person, small group, or presentation situations using tact and diplomacy; ability to coordinate and initiate actions necessary to implement decisions and delegate responsibilities to appropriate personnel; ability to establish and maintain priorities in order to complete assignments by deadlines without detailed instructions; skill in verifying the accuracy and completeness of forms and reports; knowledge of the Microsoft Office 365 suite and the ability to learn and use other software that MTS might have or acquire; experience with Power BI or any data analytics tool; ability to learn metrics and data points specific to the transit industry and MTS; ability to analyze existing tools and databases and provide software solution recommendations; strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy; adept at queries, report writing and presenting findings; critical thinking skills to review numbers, trends and data in order to draw conclusions.

Physical Requirements The successful candidate must be able to fulfill the physical demands of the job such as walking, stooping, sitting, bending, reaching for overhead files and occasional lifting (must be able to lift up to 15 pounds). Must be able to operate a motor vehicle and perform tasks involving manual dexterity, such as use of a computer and 10-key.

Work will at times require more than 8 hours per day or an irregular work week to perform the essential duties of the position.

Duties will be performed primarily in an office type environment and may require travel to external locations and agencies.

Experience/Education/Certificates/License(s) Possess a bachelor’s degree from an accredited college or university in math, statistics, information systems, computer science or another related field.

Working experience as a data analyst.

Knowledge of and experience with reporting packages and databases and data analytic tools such as Power BI; SQL programming is a plus.

Must possess and maintain a valid California driver’s license.

GENERAL: Must satisfactorily pass all applicable examinations including, but not limited to, a pre-employment physical, drug screen and background check.

SALARY GRADE: #8 ($56,557 - $115,023) Hiring Range: $73,000 - $91,000 DISCLAIMER: The above-described job elements are intended to indicate the general nature and levels of work being performed by employees assigned to the job.

They are not intended to be an exhaustive list of duties, responsibilities and skills required of employees so classified.

Management retains the discretion to add to or change the duties of the position at any time.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

Full-Time