Systems Analyst

City of Billings; Billings (MT); On-site; USD 73,000 - 89,000; Full time

Job summary

The City of Billings is seeking a Systems Analyst to perform a variety of professional and technical duties involved in understanding and analyzing the needs of the departments/end-users.

This role includes project management, software selection and implementation, database health, and data integration to support analytics and reporting across departments. Monday–Friday, 8:00 a.m. to 5:00 p.m., on-site in Billings, MT. Equal opportunity employer.

Qualifications

• Four (4) year degree in Information Systems, Computer Science, and/or equivalent technology program.
• Two (2) years' work experience in project management, planning system implementations & integrations to existing systems, software systems/end-user support, software development, database management, and/or equivalent.
• Experience with Microsoft SQL Server including building application interfaces, data management, queries, scripting, and reporting.
• Must be able to pass a State and Federal criminal background check.

Responsibilities

• Provide project management services for IT initiatives.
• Select, implement, and support enterprise application software solutions.
• Perform application programming and testing, building, and supporting system integrations.
• Establish and maintain vendor/partner relationships and support security and hosting needs.
• Develop and support data interfaces for analytics and reporting.
• Train users and assist with system transitions and workflow procedures.

Skills

Project management

System integrations

Software development

Database management

End-user support

Troubleshooting

Vendor relations

Education

Bachelor's degree in Information Systems or Computer Science

Tools

Microsoft SQL Server

HTML

JavaScript

Visual Studio

Job description

The City of Billings is seeking a Systems Analyst to perform a variety of professional and technical duties involved in understanding and analyzing the needs of the departments/end-users.

Salary Range: $35.1246 - $42.6557 per hour. Salary reflects Step 1 and Step 5 of a 7-step pay scale. Salary at hiring will be dependent upon the applicant's education, experience, and training.

Work Schedule: Monday through Friday, 8:00 a.m. to 5:00 p.m.

Essential Duties And Responsibilities

• Provide project management services.
• Select, implement, and support enterprise application software solutions.
• Perform application programming.
• Perform testing, building, and supporting system integrations.
• Establish and maintain strong vendor/partner relationships.
• Troubleshoot existing information technology systems, hardware, mobile technology, and software.
• Works with departments to understand their needs and provide project management, assist with selection, and implementation services for new information technology solutions including, hardware, software, security, mobile technology, and hosting options.
• Installs new and existing information technology systems, hardware, and programs.
• Responsible for SQL Server database health management; creating program views, functions, and stored procedures; and writing optimized SQL queries for integration with other applications.
• Develops and supports application interfaces including data imports/exports to support data analytics, web services, reporting, GIS, and all data sharing requirements.
• Establish a strong understanding of the software systems and how each department utilizes solution(s) to meet their needs.
• Works closely with Network Team to address and support the security, hardware, supportive software, backup, disaster/recovery, and hosting needs of the solutions.
• May be part of a team of IT professionals who share 24/7 On-Call support for public safety.
• Leads departments in examining information technology needs and operations.
• Evaluates new and existing information technology systems.
• Provides Project Management including the development of upgrades, custom programs, or installation plans, which includes recommending costs, systems, hosting options, and work plans.
• Serves as liaison with internal and external information technology staff and contractors.
• Develops new procedures and manuals regarding system transition and usage.
• Identifies the need for custom software solutions to support the needs of each department. This may be stand-alone solutions and/or solutions that integrate into or share data with other software solutions.
• Provides guidance and technical services to support required import and export of data for the systems they support. Examples include determining data needed for moving to or from a software solution, building inquiry copies of data to support mapping & reporting needs, and interfaces to vendor web services.
• Performs systems upgrades & database management services.
• Reports problems to contractors and supervisory staff.
• Assists with overseeing overall system security and status.
• Ensure custom interfaces and programs are maintained and continue to function properly when system changes/updates are applied.
• Works with Departments to understand their reporting needs and provides solutions to meet those needs.
• Utilizes SQL Server functions and available reporting and application programming skills/tools to facilitate report development.
• Extracts and maintains data.
• Prepares reports in a workable and usable format.
• Trains users on the use and application of systems and hardware.
• Assists in the development of workflow procedures to guide end-users.
• Assists with training lower-level Information Technology staff.
• Performs other duties as assigned.

Required Qualifications & Skills

• Four (4) year degree in Information Systems, Computer Science, and/or equivalent technology progra .
• Two (2) years' work experience in project management, planning system implementations & integrations to existing systems, software systems/end-user support, software development, database management, and/or equivalent.
• Experience with Microsoft SQL Server including building application interfaces, data management, queries, scripting, and reporting.
• Must be able to pass a State and Federal criminal background check.

Preferred Qualifications & Skills

• IT Certifications related to Microsoft SQL Server, Project Management, Cloud Applications, and Help Desk.
• Experience with cloud computing including application support, reporting, & systems integrations.
• Experience with HTML, JavaScript, and/or Visual Studio.

Equal Opportunity Employer.