Data Systems Analyst

State of Montana•Helena, MT

23h•Onsite

About The Position

This position provides database design, development, content management and administration support for MBCC’s database hosting services and to assist with deployment of state standard database technology, Euna Grants Management System, Juvenile Detention Data and Reporting System, Board Member Web Access System, and MBCC’s web environment using Cascade, a web-based content management system. The duties typically involve creating and configuring production content for databases using established procedures, database development, backup and recovery strategies, technical support, and software patch management and maintenance of relational database systems for mission-critical operations. This includes configuring database content parameters; modifying database content environments through coding, testing, and implementation; and running test programs to validate functionality and correct errors. Duties also include planning and implementing database content security measures, managing user access and permissions, and ensuring data security protocols are in place and functioning. The position involves making strategic decisions about database design, maintenance and tuning, as well as diagnosing and troubleshooting complex content issues, monitoring database performance, and performing performance tuning. The Data Systems Analyst also installs content upgrades and patches and supports user needs by extracting data and responding to content requests using existing tools. As agency priorities dictate, the Data Systems Analyst must be able to carry out any assignment in the section with minimal retraining and may be assigned responsibility for project components.

Requirements

A Bachelor’s degree in a computer science related field.
Two years’ experience working in a variety of database environments.
Knowledge of system content performance optimization and management techniques.
Knowledge of principles and practices of information systems analysis, design, implementation, maintenance, and security related functions.
Ability to provide exceptional customer service and enjoy working in a team environment.
Ability to build trust and credibility in constructing effective working relationships with a variety of individuals.
Ability to manage varying deadlines and multiple projects; responding positively to changes in direction, priorities, responsibilities or assignment.
Ability to keep large projects, involving multiple parties, moving forward and delivered on time.
Ability to provide guidance and instructions to other agency staff.
Ability to evaluate program requirements relative to systems development.
Ability to conduct research.
Ability to exercise sound judgment in solving programs and make decisions where few precedents exist.
Commitment to stay up-to-date in the IT profession.
Ability to organize a dynamic workload and meet established deadlines.
Successful completion of a criminal background check.
Employment eligibility confirmed via E-Verify.

Nice To Haves

Specific experience in Relational database management systems (RDMS) such MS SQL Server or Oracle.
Experience in database administration, content management, automation, business rule enforcement, web design and development, and performance optimization techniques.
Experience with 508 compliance measures and implementation strategies.

Responsibilities

Provide database design, development, content management and administration support for MBCC’s database hosting services.
Assist with deployment of state standard database technology, Euna Grants Management System, Juvenile Detention Data and Reporting System, Board Member Web Access System, and MBCC’s web environment using Cascade, a web-based content management system.
Create and configure production content for databases using established procedures.
Perform database development, backup and recovery strategies, technical support, and software patch management and maintenance of relational database systems for mission-critical operations.
Configure database content parameters.
Modify database content environments through coding, testing, and implementation.
Run test programs to validate functionality and correct errors.
Plan and implement database content security measures.
Manage user access and permissions.
Ensure data security protocols are in place and functioning.
Make strategic decisions about database design, maintenance and tuning.
Diagnose and troubleshoot complex content issues.
Monitor database performance and perform performance tuning.
Install content upgrades and patches.
Support user needs by extracting data and responding to content requests using existing tools.
Carry out any assignment in the section with minimal retraining as agency priorities dictate.
May be assigned responsibility for project components.