IT Data Management - Journey

State of Washington • Thurston County – Olympia, WA

13d • Hybrid

About The Position

The Washington State Patrol (WSP) is committed to being an Equal Opportunity Employer and fostering an environment where everyone is encouraged to be their authentic selves, communicate openly, and act with courage. The WSP is dedicated to promoting fair and equitable hiring, training, and promotional practices through innovative recruitment and retention strategies. The Information Technology Division (ITD) exists to leverage technology to enhance and sustain business processes, public safety infrastructure, and statewide emergency communications to facilitate the accomplishment of all agency goals. The Infrastructure Operations (IO) section within ITD supports the WSP enterprise computing infrastructure by providing agency-wide, in-depth technical system administration and support for all enterprise server hardware and associated software infrastructure, core enterprise applications, vital business applications and web servers, file and print servers, and all WSP data and databases, including processing and backups.

Requirements

• Associates or higher or military/DoD occupational/specialty school completion in Computer Science, Management Information Systems, Electrical Engineering, or a closely related field of IT engineering.
• Work experience may be substituted year-for-year
• 5 years of work experience in the data management industry using industry standards for SQL (T-SQL preferred) Database Operations, Structure and Maintenance.

Responsibilities

• Act as an agency subject matter expert for data analytics using Power BI, SQL, and SQL Reporting Services (SSRS) and provide report building expertise, deployment, and guidance to agency data research analysts and other personnel to enable data analysis and visualization of data.
• Create SQL data models and views from agency relational databases to provide business operations to perform data analytics and visualization.
• Use business requirements to design, normalize, develop, install, and implement agency relational databases and data warehouses.
• Execute SQL commands to maintain and support databases.
• Create, configure, and manage all assigned Power BI technical infrastructure environments, sites, and related application services regarding databases.
• Oversee, monitor, and maintain all database security, permissions, and connections based on the ITD security policy and best security practices and guidelines.
• Design or select, test, and implement system reliability while adhering to structured server best practices (ITIL/MOF-based) change management principles.
• Proactively monitor, maintain, enhance, upgrade, patch, troubleshoot, and repair the agency's DevOps environment.
• Design or select, test, and implement pipelines for automating extract, transform, and load (ETL) processes and other data manipulation processes.
• Assist with technical components of ensuring the agency's GIT environment is functioning optimally.
• Proactively monitor, maintain, enhance, upgrade, patch, troubleshoot, and repair server environments including hardware operating system, network, security, support software, applications, and related vendor software and tools, and builds or re-configures systems to meet new requirements.
• Utilize expert knowledge and system administration skills to ensure 99.9% uptime of vital WSP systems and applications.
• Make emergency notifications to other system administrators when appropriate.
• Set up alerts and enforce policies.
• Consult with other enterprise system administrators to enhance performance monitoring of other systems.
• Design and maintain specialized dashboards to enhance visibility into performance.
• Report to management and staff to provide information for better operational decisions.
• Coordinate with hardware and software vendors to assure operational standards.
• Patch the PowerBI report environment as needed.
• Perform research and evaluation of new enterprise technologies, processes, and upgrades to various database systems and infrastructure.

Benefits

• Flexible schedules
• Telework options for most positions
• Infants at Work Program
• Continuous growth and development opportunities
• Opportunities to serve your community and make an impact through meaningful work
• Employment opportunities that recognize military veterans and/or military spouse per Governor Executive Order 19-01
• Qualification for the Public Loan Forgiveness Program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree