Service Analyst 2 at Metra

DescriptionThe final salary will depend on the candidates 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.Clickhereto 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 Metras 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 agencys 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 Metras 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 agencys 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.RequirementsBachelors 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. Masters 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.Good presentation skills.Proficient in Microsoft Office Suite specifically Excel Word and PowerPoint.Ability to possess a high degree of attention to detail.Ability to read and comprehend technical material.Ability to work independently and in a team environment.Preferred:Proficiencies in Microsoft Power BI ArcGIS and Microsoft Access.Familiarity with the Chicago region railroads transit services and communities.Metra employees in an active review period under the current discipline policy or who have documented attendance or performance issues will not be considered and/or selected for this position.Please note: Regardless of any state laws that legalize marijuana Metra prohibits applicants and employees use or possession of marijuana (or marijuana paraphernalia) or having detectable amounts of marijuana in their bodies including synthetic and/or non-synthetic substances such as THC for any reason for preemployment screening purposes while on duty subject to duty on Metra property or in Metra work equipment and vehicles.Metra is committed to ensuring that our career website and recruiting process are accessible to all individuals. If you encounter difficulties or limitations in using or accessing our online application or if you require reasonable accommodations to complete this application participate in interviews complete any pre-employment testing or engage in any other aspect of the employee selection process please direct your inquiries to Metra is an Equal Opportunity/Affirmative Action Employer. It is our policy to fill vacant positions with qualified candidates without regard to race color sex religion national origin age gender identity disability or any protected categories assuming an individual can perform the essential functions of the job with or without accommodation.Required Experience:IC Key Skills Debugging,Computer Networking,ConnectWise,PKI,PowerShell,Windows,C#,Automotive Diagnostics,Medical Imaging,Azure,Technical Support,Troubleshooting Employment Type : Full Time Experience: years Vacancy: 1