DESCRIPTION Under general supervision of the Information Technology (IT) Supervisor, this position will assist in providing technology consulting, systems implementation, and technology support services to County departments. The Business Analyst/Application Developer is primarily responsible for Business Analysis, Project Management, Programming Analysis and Coding, SQL Database Development and Maintenance and Vendor Management for IT projects and user requests. Other responsibilities include maintain application infrastructure; maintain development environment; perform troubleshooting; establish and follow software development processes, policies, and standards; perform application software operations procedures; participate in professional staff development; provide technical and user documentation for staff training. Maintains requests from users via the IT department help desk system. This position requires independent, hands-on work to assure customer satisfaction. DUTIES / RESPONSIBILITIES ESSENTIAL FUNCTIONS: Performs business analysis and project management. Leads, facilities, and manages IT Projects and tasks while effectively collaborating with other Business Analysts/Application Developers (BA/AD)and stakeholders. Researches and provides recommendations for technology solutions based on best practices, optimized performance, cost. Plans and manages application solution projects through business analysis, application development, software purchases, upgrades, and vendor management. Provides guidance during projects and decides appropriate procedures for projects. Meets with other BA/AD, management, IT Staff, users, and vendors to include their input on solutions. Keeps all stakeholders informed of progress on a regular/timely basis. Programming Analysis and Coding. Creates technical specification and designs and codes reports, ETLs, entry screens, inquiry screens, etc. Decides on programming techniques which meet design specifications and legal requirements. Tests new and changed programs. Coordinates with other BA/AD on implementation. Creates user and developer documentation. Performs coding as needed for additional projects managed by other BA/AD. Performs SQL Database Development and Maintenance. Designs database solutions using tables, stored procedures, functions, views, and indexes. Administers and supports maintenance plans and scheduled jobs. Performs monitoring, analysis, and administrator duties to ensure high database performance. Works with software vendors on purchase, installation, upgrades, and support of purchased software. Provides support to users for purchased software and serves as vendor liaison. Builds and maintains vendor relations for superior customer service. Utilizes all available resources for vendor software management, including on-line resources, conferences, training opportunities, webinars, phone, etc. Understands and maintains Cloud infrastructure, networking, and platform technologies. Determines the solutions and provides support while proactively monitoring the solution to maintain its integrity. Maintains requests from users via the IT department help desk system. Utilizes the IT department help desk system to communicate with users and log status updates and problem resolution details. Updates assigned help desk requests on a regular and timely basis. Maintains Application Infrastructure. Determines setup and operation of application infrastructure. Ensures application data integrity. Proactively monitors application performance and researches and recommends tools for monitoring. Researches County-wide effects of application changes and decides on best method of application implementation, upgrades, and maintenance. Develops and implements application security policies and processes. Works together with Network Administrator on maintaining application server and network environment Maintains Development Environment. Uses all available resources to research and maintain the development environment, including upgrades, updates, fixes, and performance enhancements. Develops and coordinates development environment change plans with other IT Staff. Troubleshoots application software, hardware, or database related problems. Evaluates alternative solutions, and coordinates with other resources to produce solutions. Works with software vendors and all available resources to respond to and implement solutions. Documents problems and resolutions. Establishes and follows Software Development Processes, Policies, and Standards. With other developers and IT staff, develops, documents, implements, maintains, and follows programming and documentation standards, policies, and procedures. Promotes a diverse, culturally competent, and respectful workplace. Interacts positively with internal and external customers. Communicates and interacts effectively and respectfully with employees, supervisors, individuals from other organizations, and customers. Performs the Physical and Mental Demands of the Position. Attends Work During Regularly Scheduled Hours. ADDITIONAL FUNCTIONS: Performs Application Software Operations Procedures. Performs weekly, monthly, quarterly, and year-end operations procedures as needed. Participates in Professional Staff Development. Participates in training and education opportunities to maintain and improve proficiency. Attends and participates in professional organizations. Associates with agencies and departments within Blue Earth County, as well as other county and state government, to learn about governmental operations and maintaining professionalism. Provides Training to Employees. Develops and implements training materials, trains personnel on computer procedures, provides ongoing support and acts as a technical resource for vendors. Performs Other Related Functions as Apparent or Assigned. QUALIFICATIONS MINIMUM QUALIFICATIONS: Bachelor’s degree in the field of computer science or information systems, and Two (2) years equivalent work experience OR Equivalent combination of education and experience necessary to perform the essential functions of the position including work in SQL, App Development, and/or Report writing. PREFERRED QUALIFICATIONS: Fluent in understanding and speaking languages other than English such as: Spanish, Somali, Chinese, Sudanese, or Arabic. Experience with the following software development tools: .NET technologies, Visual Studio, SQL Server 2008+ Tools/Services, SSRS. Experience with the following software: SSIS, JavaScript, JQuery, SharePoint, HTML, CSS, JSON, Python, Powershell, GIS or Document Imaging and Management Systems. Experience building and supporting ETL modules. Experience with government Property Tax and Finance/Payroll systems. CONDITIONS OF EMPLOYMENT: Must comply with all federal and state laws and organizational and departmental policies and regulations. Must possess a valid driver’s license and be able to drive in the State of Minnesota. Must successfully pass a background check. Must comply with data practices policies and standards relative to not public data. Any access to not public data should be strictly limited to accessing the data that are necessary to fulfill the employment responsibility. While data are being accessed, incumbent should take reasonable measures to ensure the not public data are not accessed by individuals without a work reason. Once the work reason to access the data is reasonably finished the not public data must be properly stored according to county policy and the Minnesota Statutes. HOURS OF WORK Monday through Friday from 8:00 a.m. to 5:00 p.m. Must be able to work extended hours, evening, weekend, and holidays as necessary.
Salary: $72,571.20 - $101,670.40 a year
Employment Type: Full-time
Qualifications
[]