Business Systems Analyst
Education and Experience:
Bachelor’s Degree from an accredited college, university, or technical school in Technical Business Management, Management Information Systems, Computer Science or a related field. Two or more years of programming experience or any equivalent combination of education, training, and experience which provides the required knowledge, skills, and abilities. Experience using ERP systems or equivalent with an understanding of systems implementation and design. Understanding of Database management. Ability to write queries for extracting or managing data within MS SQL databases. Querying MS SQL Server using Transact-SQL for SQL Server. Data modeling, building analysis and reporting solutions using MS SQL with tools such as Crystal Reports and SSRS.
Licenses and Certifications:
Must possess a valid state driver's license and satisfactory motor vehicle record.
Oral and written communication ability equivalent to that normally acquired through a college, university, or technical school education is required. Ability to communicate with users, coworkers, management, and city officials regarding the operations and technical abilities of various software so that those individuals have a lay person’s understanding of the software and business process. Current and advanced methods and techniques of data processing, computer programming, and business processes/analysis. Capabilities and functions of computers, databases, and their related platforms. Under-standing and experience applying the SDLC.
Excellent programming skills and the ability to understand the logic and processes of programming changes. Logical, analytical, and investigative mind to troubleshoot problem areas or evaluate solutions with vendors and end-users coupled with creative abilities to problem solving and programming. Excellent organizational, time and project management skills. Interpersonal skills necessary to be courteous of fellow employees while performing routine duties which involve providing technical assistance to the business systems users as needed. Need to be fluent and comfortable in the technical and non-technical aspects of the job and interacting with a team of both technical and non-technical personnel. Analytical skills necessary to apply technical knowledge to practical use in analyzing applications/business processes, and design system and program specifications for a variety of applications; develop solutions and recommend courses of action. Preparing clear, de-tailed programs, programming, and process documentation for efficient operations. Interpersonal skills necessary to effectively interact with various departments, citizens, vendors, and management. Self-development skills to keep up-to-date with fast-changing trends and technological advancements and their impact in a municipal environment.
Mental and Physical Abilities:
Ability to maintain regular, predictable and punctual attendance. Recognize and pursue corrective action on programming and business process problems. Analytical abilities are required to interpret data, recognize discrepancies contained in data, and correct or determine the cause of discrepancies, and work towards a solution where possible. Ability to read, understand and apply the technical aspects of the operation, management, and support of business systems. Mental/visual effort required due to sustained periods of concentration, working under pressure of deadlines, and continual interruptions in concentration from staff requiring assistance. Ability to understand and apply complex oral and written instructions. Ability to do self-study while on the job to learn new technologies and functionality of systems.
DUTIES AND RESPONSIBILITIES:
Designs, develops, tests, and debugs programs; evaluates code and workflows, reviews or writes scripts, queries, and can make modifications necessary to maintain existing programs as state and federal law, city code, ordinances, policies, or processes change. Develops programs for on-line processing, and Electronic Data Interchange (EDI) between agencies. Provides sup-port, completes maintenance, and assists vendors if necessary with third party applications that relate to or interface with the ERP suite for the City. Designs and develops “bolt on” programs and application inter-faces as needed to support city business and interfaces to the ERP software suite. Meets and confers with users/stakeholders to determine their programming and software needs; develops programs and system designs based on these requests following the Systems Development Life Cycle (SDLC). Develops test data to test programs in order to ensure their accuracy; debugs programs utilizing a variety of tools and techniques; implements programs in a controlled manner into business production. Prepares and provides technical documentation necessary for the utilization and maintenance of systems, processes, or programs; provides users with instructions in the use of the program or system and how it functions with the business process. Evaluates software modification and development specifications for accuracy and functionality. Troubleshoots existing applications as users identify possible problems within the program and/or process. Evaluates and understands current business processes within the various departments and divisions and makes suggestions for changes to keep those processes current and functioning efficiently. Works closely with other IT staff to ensure security of confidential data, financial data, transactions, and the like are meeting compliance as data is stored and/or transferred when working on projects or in daily operations. The Analyst have responsibility to understand and convey information to IT security and network personnel of details that may require their assistance to provide access to data, protection, or the sharing thereof for City business and operations.
Examples of Other Major Responsibilities:
Develops various routine and technical reports as requested. Creates implementation procedures for new programs/processes or changes when necessary; assists in troubleshooting operations problems. Working understanding of database design, interface, and reporting including legacy databases, Microsoft SQL, Transact SQL, or SQL Server. Analyses and meets with soft-ware vendors to clarify or resolve discrepancies or problems found in the specifications. Participates in team meetings with IT support staff to discuss progress and issues identified or resolved, report progress on weekly basis to the Operations Manager. Performs other related work as required by the manager or supervisor.
MATERIALS AND EQUIPMENT USED:
Personal Computer or Laptop Computer
Disk, tape, Solid-state drives
MS SQL Server tools for query and Transact-SQL
Microsoft SSRS, Crystal Reports
Works in a normal office environment where there are little or no physical discomforts associated with changes in weather or discomforts associated with noise, dust, dirt and the like. Hours are 40 hours per week with expected possible after hours or weekend work during ex-tensive projects. Work time is most spent working at a computer typing, using a telephone or headset, and possibly calculations.
Selected applicant must pass background investigation, physical examination, and drug screen.