Business Systems Analyst

JOB SUMMARY: Reviews, analyzes, and evaluates user needs to create systems solutions that support overall business strategies. Ensures proper installment of 3rd party software to include processes and training as well as set-up and custom reports. Tests the effectiveness of new and existing software. Manages the flow of information and adherence of vendors to IT project timelines. Assists with data extractions and business intelligence reporting.   ESSENTIAL FUNCTIONS: Trouble-shoots and supports users of all system software internally developed and externally purchased. Manages implementation of software purchases and updates. Develops Functional and Technical specifications of current and future process. Meets with technical teams. Reviews help desk logs and troubleshoots user issues. Responds to various inquiries from departments concerning software updates, performance, solutions to data issues and overall processes. Provides analysis and monitors dashboards Performs other duties as required. QUALIFICATIONS: Bachelor's Degree in Information Technology or related field required. Five (5) years of related experience required. Experience troubleshooting database processes and issues.  Experience with Procedural Language/Structured Query Language (PL/SQL) development. Experience troubleshooting software applications.  Experience working with 3rd party vendors. Two (2) years of related experience required. Experience implementing enterprise systems. Experience with project management duties and tools. Experience with Power BI data visualization software. KNOWLEDGE, SKILLS, AND ABILITIES: Knowledge of systems analysis procedures and best practices. Knowledge of Project management software. Knowledge of Microsoft Dynamics 365 ERP software. Knowledge of Crystal Reports, Tableau, and Power BI. Knowledge of Procedural/ Structured Query Language. Knowledge of ANSI Structured Query Language. Knowledge of troubleshooting database processes and issues. Knowledge of dashboard creation. Skilled in the use of computers, spreadsheet, and database software. Ability to learn Milwaukee County Transit System services and operations. Ability to troubleshoot and upgrade software. Ability to review and develop project plans. Ability to develop and test problem solutions. Ability to develop and manage project plans Ability to write detailed project specifications Ability to stay current on IT issues. Ability to develop and maintain effective and appropriate working relationships. Ability to communicate effectively, both verbally and in writing. Ability to work independently. PHYSICAL REQUIREMENTS AND ENVIRONMENTAL FACTORS: Work is frequently conducted in an office or similar indoor environment relatively free from unpleasant conditions or hazards. Physical requirements are those described as sedentary work exerting 10 pounds of force occasionally or a negligible amount of force frequently.