Business Systems Analyst

Department Information Technology Location Village Hall Position Type FT Employee Salary Date 2024.08.22 Description The Village of Hoffman Estates is looking for energetic, customer service oriented individuals who have a passion for technology, exceptional communication skills and a very good sense of humor to join our INFORMATION TECHNOLOGY team! As part of the team you will: Maintain, update, configure, and patch enterprise applications and provide end user support on basic, intermediate, and advanced application support requests, reports, and expand current software functionality Provide administrative and technical support for a number of current and future village-wide enterprise resource and collaboration applications such as Microsoft TEAMS, OneNote, SharePoint, DevOps, Laserfiche and Adobe Creative Cloud Conduct training for staff at all levels of proficiency on the use of the various enterprise systems Present/explain concepts and ideas clearly and effectively Work on new projects – including planning, requirements analysis, systems design, implementation, integration, reports development, testing, documentation, training, and go-live activities Have experience with report writing tools such as Crystal Reports, COGNOS, SQL Server Reporting Services Have working knowledge of Microsoft Active Directory, AZURE, and MSSQL Stay up to date with current and changing technical software and hardware advances, requirements and trends Have a high aptitude for learning new technologies Work well under pressure EDUCATION, EXPERIENCE AND COMPUTER SKILLS Any combination of education and IT experience may be considered The Village is considering candidates for Business Systems Analyst level I or II, depending on candidate skills and experience. BUSINESS SYSTEMS ANALYST I Associates Degree in a computer related field is preferred Two – four years experience in database modeling, report writing and SQL Five + years experience as a Business Systems Analyst in lieu of degree Valid Class D Illinois Driver’s License Specialized Applications Experience: Enterprise applications including but not limited to customer relationship, enterprise resource planning, document management, and enterprise asset management. BUSINESS SYSTEMS ANALYST II Two – four years experience in database modeling, report writing and SQL Associates Degree in a computer related field is preferred Seven + years experience as a Business Systems Analyst in lieu of degree Valid Class D Illinois Driver’s License Specialized Applications Experience: Enterprise applications including but not limited to customer relationship, enterprise resource planning, document management, and enterprise asset management. HOURS AND SCHEDULE 40 hours per week, Monday – Friday 8:00 a.m.-5:00 p.m. COMPENSATION Salary DOQ Business Systems Analyst I 2024 Range of $38.2040/hr - $55.3356/hr ($79,464-$115,096 annually) Business Systems Analyst II 2024 Range of $40.1142/hr - $58.1014/hr ($83,437- $120,851 annually) The Village of Hoffman Estates has a competitive benefit package which includes: health, dental, vision, and life insurance, medical and dependent care flexible spending accounts, a retirement pension plan through the Illinois Municipal Retirement Fund, paid holidays, paid vacation, sick leave, tuition reimbursement, onsite work out facility, and more. All positions require a pre-employment Village-paid background investigation and drug screen upon job offer. Posting Date: 8/22/2024 Closing Date: 9/30/2024 or Until Filled ABOUT THE DEPARTMENT The Information Technology Department is an internal service department that supports over 400 computer users Village-wide, with a focus on technology planning and maintenance for Village operations. The Information Technology Department is divided into two divisions: Technical and Network Support: responsible for network communications, hardware and software, training and support. Business Applications: fund accounting, human resources, benefits and payroll, licensing, utility billing, community development, and revenue applications. The Village's computer network is spread out across each municipal building with a combination of fiber optics and FCC Licensed microwave wireless. ABOUT THE COMMUNITY The Village of Hoffman Estates, Illinois, founded in 1959, is located in suburban Cook County, approximately 30 miles from the City of Chicago. With a population of over 50,000, Hoffman Estates is a full-service community. The mission of the Village of Hoffman Estates is to continually improve the quality of life for our residents and business community by providing responsive and efficient municipal services. Hoffman Estates’ strategic location along the Golden Corridor of Interstate 90 provides excellent access to all major attractions within the Chicagoland region and the Midwest. Over 26,000 people are employed by the more than 800 businesses operating in Hoffman Estates. Recently ranked one of the best places to live in Illinois, the Village of Hoffman Estates offers high-quality schools, parks, entertainment and recreational opportunities, as well as a variety of housing options. The Village of Hoffman Estates is an Equal Opportunity Employer and complies with all applicable Federal, State and local laws regarding employment. See full job description below: Essential Job Functions and Responsibilities Maintaining; updating; configuring; and patching enterprise applications and providing end user support on basic; intermediate; and advanced application support requests; reports; and expand current software functionality. Provide administrative and technical support for a number of current and future village wide enterprise software applications including but not limited to Central Square Enterprise Resource Planning/Financial System (PLUS); Laser Fiche Document Management System; GovQA Citizen Request Management and FOIA solutions; Microsoft Teams; OneNote etc. Conducts instruction/training for at all levels of proficiency and usage of the various enterprise systems. Manages all details of the training environment including equipment set-up; refresh procedures and the physical and learning needs of the participants. Work on new projects and be involved with planning; requirements analysis; systems design; implementation; integration; reports development; testing; documentation; training; and go-live activities. Pursues current and changing technical software and hardware advances and requirements as well as computer industry standards and trends through professional publications; conferences; workshops and seminars. Pursues teaching advances and methods to further the utilization of technology as a tool to enhance workplace efficiency. Maintains a working relationship with the enterprise application vendors as the liaison to effectively respond to and correct issues Participates and Contributes to various vendor user groups. Collaborates in a team environment including but not limited to; participation in team and inter/intra departmental meetings and projects. Operates and properly maintains all tools and equipment needed to perform the essential job functions and responsibilities listed above while adhering to all safety rules and practices. Required Competencies To perform this job successfully; an individual must be able to perform each essential job function satisfactorily. The required competencies listed below are representative of the knowledge; skills; and/or abilities required for successful job performance. Experience supporting an Enterprise Resource Planning suite; preferably Central Square PLUS and Community products Experience with report writing tools such as Crystal Reports; COGNOS; SQL Server Reporting Services Experience with administering and supporting enterprise resource and collaboration applications such as Microsoft TEAMS; OneNote; SharePoint; DevOps; Laserfiche and Adobe Creative Cloud. Working knowledge of Microsoft Active Directory; AZURE; and MSSQL. Analyze and work to solve simple to complex system and software problems Ability to encourage; train; mentor; provide leadership for technical staff. Ability to apply critical listening skills in a variety of contexts including supervisory and professional situations. Prioritize and troubleshoot software and hardware issues and resolve problems and good follow-through. Work independently using initiative and creativity as well as collaborate in a team environment. Analyze; develop; design and maintain databases Excellent interpersonal and teambuilding skills. Excellent communication skills; verbal and written Follow verbal and written instructions. Work independently and as a team. Set priorities and meet deadlines in a fast paced environment with frequent interruptions. Organize and manage projects and time. Multi task and maintain details. Work well under pressure. Familiarity with administrative principles and practices Spelling; grammar; and arithmetic Present concepts; ideas and components effectively. Software licensing regulations Distinguish trends in network; hardware and software problems. Differentiate as to when to alert appropriate technical staff of network; hardware and software problems. A high aptitude for learning new technologies is essential Education Level The designated education and experience levels best describe the minimum requirement needed to fulfill the essential job functions. However; any combination of equivalent education or experience may be considered. Associate's degree (A.A.) from two-year college or technical school Degree or coursework should be in: computer related field. Experience Level Two to four years related experience: Proficiency in database modeling; report writing and SQL Four to ten years related experience: Minimum of five years’ experience as a Business Systems Analyst in lieu of degree Computer Skills Entry and processing of data Word Processing data Spreadsheet software Database software Specialized applications: Enterprise applications including but not limited to Customer Relationship; Enterprise Resource Planning; Document Management; Enterprise Asset Management Communication Skills Ability to read; research; and analyze general business periodicals; professional journals; technical reports; finance documents or government laws and regulations. Ability to write reports; business correspondence; manuals and draft policies and procedures. Ability to effectively make presentations and respond to questions from groups of managers; customers; citizens; or other agencies. Ability to read; analyze and interpret professional; scientific; or technical manuals; procedures; plans; schematics; maps; blueprints; licenses; and/or legal documents. Ability to respond to inquiries from managers; customers; business community or regulatory agencies. Ability to draft responses to complex or technical issues and/or effectively present technical concepts or information to managers; customers; or other agencies in concise understandable terms. Licenses/Certificates Class D Illinois Driver's License Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job with or without reasonable accommodations. None of the time: climbs or balances; twists or turns; tastes or smells; lifts or move 20 to 50 pounds (moderate); and lifts or move 50 to 100 pounds (heavy) . Less than 1/3 amount of time: stands; walks; reaches with hands and arms above shoulder; stoops; kneels; crouches; bends; or crawls; pulls; pushes; or carries; operates a motor vehicle or heavy equipment; and lifts or move 10 to 20 pounds (light). 1/3 to 2/3 amount of time: sits; uses hands to grasp; finger; handle; or feel; lifts or move 0 to 10 pounds (sedentary). More than 2/3 amount of time: uses fingers in a repetitive motion; talks or hears. Vision Demands The vision demands described here including the ability to adjust focus; close vision; sharpness of vision; depth perception; peripheral vision; distance vision; hand-eye coordination or as otherwise specified by the Board of Fire and Police Commissioners; are representative of those that must be met by an employee to successfully operate the tools and equipment needed to perform the essential functions of this job. Corrected vision of: 20/20. Environmental Conditions The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job with or without reasonable accommodations. None of the time: customary outdoor weather conditions including extreme cold; extreme heat; and wet or humid conditions; non-weather conditions (extreme cold; extreme heat; and wet or humid conditions); works near moving mechanical parts; works in high precarious places; underground; or confined spaces; flying debris or airborne particles; fire; smoke; fumes; gases; or noxious odors; toxic or caustic chemicals; aerosols; liquids; solvents or oils; works with explosives or risk of radiation; vibrations; extreme illumination; moderate noise level (raised voice levels); and high noise level (shouting/ear protection may be needed). Less than 1/3 of time: risk of electrical shock. More than 2/3 amount of time: customary indoor conditions; low noise level (normal voice tones). Other Related Duties Attends building departmental and Village meetings and serves as a member of various employee committees and task forces when required or assigned. Maintains and or contributes to department documentation including monthly reports I.T. policies and procedures. Interprets data as well as provides detailed reports on various system functions and resources when required. Assists in creating documentation detailing design and construction of all Village networks and their inter-connection for the purpose of architecting delivering and maintaining a reliable and stable technology infrastructure appropriate to support the core mission of the department. Makes suggestions to improve software systems and/or procedures. Professionally represents the Information Technology Department as a technical consultant on projects. Follows Village and departmental safety rules and practices. Performs other duties as required or assigned. Disclaimer The information listed above reflects minimum standards and illustrations of the various types of work that may be performed. The omission of specific job functions requirements or tasks does not exclude them form the job if the work is similar related or a logical extension of the work assigned. This job description does not constitute an employment agreement between the employer and employee Application Special Instructions Selection Process for This Position Includes: Interview Post Offer / Pre-employment Screening Includes: Federal & Nationwide Criminal Background Check Social Security & Driver's License Verification Drug Screen Exempt : No Type : FT Employee Department : Information Technology Location : 1