Service Analyst 2

Job Description

The final salary will depend on the candidate’s qualifications. Those with 8 years or more of required experience can expect offers up to the midpoint of the salary range. Metra provides full pay ranges so candidates can consider their growth potential.

Click here to learn more about our benefits!Qualified veterans who meet the minimum requirements will receive outreach during the recruitment process in accordance with Federal and State laws, including the Illinois Veterans Preference Act. Meeting the minimum qualifications does not guarantee an interview or job offer. The most qualified candidate will be selected.

Metra is one of the largest and most complex commuter rail systems in North America, serving Cook, DuPage, Will, Lake, Kane, and McHenry Counties. The agency is linking communities in Northeastern Illinois by providing safe, reliable, and efficient commuter service.

Operations Planning & Project Management oversees the development of Metra’s train schedules and service plans; reviews data related to Metra service, ridership, and fares and manages the reporting of operations data to the Metra Board, federal agencies, and other internal and external groups; and is responsible for the agency’s adherence to Title VI of the Civil Rights Act and other equity standards in the provision of service. Reporting to the Senior Manager, Operations Planning, the Service Analyst 2 reviews, analyzes, and reports on data related to Metra’s service, ridership, and fares to keep senior staff informed of trends and support decision making; works to improve reporting products and business processes; and fulfills the agency’s federally mandated monthly ridership reporting requirements to the National Transit Database (NTD). The primary duties include: Ensure accurate and timely reporting for several recurring reports, including monthly and annual ridership trends for the Metra Board, monthly and annual reporting for National Transit Database (NTD), and various operations-related reports.

Extract operations data from multiple data warehouses and import to various reporting and analysis software programs including Microsoft Excel and Power BI. Recommend new reports and changes to existing methodologies to management that will improve trends analysis, business intelligence, and regular and ad hoc reporting. Work with the IT department to create new reports and improve the efficiency of existing reports.

Identify and troubleshoot data errors within data warehouse reports and internal records; work with internal departments and consultants to identify errors and potential issues with data sets, decide on a course of corrective action, and present alternatives to management; and monitor the implementation of corrective actions, escalating issues to management as needed. Promote safe work practices and maintain and foster a safe work environment.

Perform other related duties as assigned to meet the ongoing needs of the organization. Metra is a railroad employer subject to the provisions of the Railroad Retirement Tax Act, not the Social Security Administration. Requirements Bachelor’s degree or in lieu of degree any combination of education and experience that equals four (4) years in the collection and analysis of operational data.

Master’s degree preferred. In addition to #1 above, must have three years of transportation or related planning experience that includes quantitative analysis, data management, or survey research. Good knowledge of data collection and statistical analysis.

Good knowledge of transportation planning principles. Good knowledge of geographic information systems (GIS), programming/script/macro languages, and database management. Some knowledge of transportation policies and reporting procedures at the federal, state, and local levels.

Good analytical and organizational skills. Good verbal and written communications skills. Good math skills, specifically statistical analysis.

EWJD3