Systems Analyst

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.

• 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.

• 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.

• 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.