Location: Arlington Heights
Department: Service Analysis
Under the direction of the Section Manager, Service Analysis, is responsible for developing new reporting processes to increase the accuracy of Pace's data; managing route databases; querying multiple large data sets; analyzing information and data; creating, editing, and maintaining reports; evaluating automatic passenger counters; working with operating division staff to improve equipment accuracy; collaborating with both internal and external stakeholders to communicate corporate information; working on special projects; and performing other duties as assigned or required.
Must have a valid driver's license with a good driving record. Must have a Bachelor of Science degree or equivalent experience with emphasis on computer science. Must have a minimum of two years of progressively responsible experience in computer system database management, system analysis, or computer programming with a good work record. Must be able to write queries in SQL, be proficient in Microsoft Office Suite applications including Excel, Word, Outlook, PowerPoint, and Access, and have a solid working knowledge of Python, R, or similar programming language. Must have a working knowledge of a visualization tool such as Tableau, Power Bl, or similar, experience with spatial analysis software like Arc GIS is a plus. Must possess strong analytical and problem-solving skills, demonstrate strong interpersonal skills; be a team player and work harmoniously and effectively with others; and demonstrate excellent written and verbal communication skills. Must be able to work in a professional office environment with the majority of the working hours consisting of computer work, however, occasional field work within the Pace service area and outside of regular office hours is also required; and must be able to lift up to 10 pounds.