IT Data Management – Entry level | Information Services Division | Olympia

State of Washington•Thurston County – Tumwater, WA

3d•Hybrid

About The Position

The Attorney General’s Office is recruiting for a permanent full time IT Data Management – Entry level in the Information Services Division. This position is located in Tumwater, Washington, and is not union-represented. The AGO provides a workplace that is understanding of work-life balance and promotes advancement by offering a wide variety of professional development and growth opportunities. The Information Services Division (ISD) provides strategic technology leadership, support and consulting for legal technologies and platforms. ISD leads the design, development, and delivery of all AGO technology systems and applications, including enterprise infrastructure, voice services and secure network environments. The division also maintains the operations of software and cloud platforms (private and public) to provide AGO staff access to their confidential work product and communications, ensuring solutions are tailored to the AGO’s unique legal and operational needs. ISD has multiple units that provide project management and business analysis service, electronic library services, custom software development, business intelligence, data management services, and eDiscovery litigation technical support. Through rigorous governance and cybersecurity controls, ISD ensures compliance with state governance policies/standards and that all technology services function properly and securely.

Requirements

Six (6) years of professional experience such as database administration, data analytics, dashboard development, developing software, analyzing, installing and/or maintaining computer software applications, hardware that use and rely on databases.
An Associate degree or higher in Computer Science, Engineering, Business, or related field, and at least four (4) years of experience such as database administration, data analytics, dashboard development, developing software, analyzing, installing and/or maintaining computer software applications that use and rely on databases.
Bachelor’s degree in Computer Science, Engineering, Business, or related field; and at least two (2) years of experience such as database administration, data analytics, dashboard development, developing software, analyzing, installing and/or maintaining computer software applications that use rely on databases.

Nice To Haves

Microsoft SQL Server administration
SQL Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
SQL Server Integration Services (SSIS)
SQL and Transact-SQL
ETL Technologies
SQL Server Management Studio
Microsoft Visual Studio
Analytic Dashboard Creation (Tableau, Power BI)
Agile software development methodologies
Restful APIs
Version Control Software (Team Foundation Server or equivalent)

Responsibilities

Perform SQL Server application installation, configuration, patching, upgrading, and tuning.
Provide data management operational support for all agency SQL Server applications and databases.
Perform SQL Server database administration, performance, and capacity monitoring.
Provide application performance recommendations related to SQL Server access.
Perform software updates in alignment with established security guidelines and policies.
Provide database authentication services, processes, and inter-application database security.
Provide system analysis, design, construction, testing, and implementation services for new database applications.
Provide advanced Excel/Pivot Table and/or other data access solutions.
Perform data conversions (CSV, Excel, etc.) into or out of SQL Server databases.
Assists in interagency data downloads and transformations that support agency applications.
Provide problem resolution and business continuity.
Prepare and maintain documentation for databases and applications.
Provide SQL coding reviews and recommendations for consistency, security, functionality, and efficiency.
Collaborate with and provide guidance to development teams during database design reviews.
Peer review and deploy custom developed SQL code.

Benefits

Medical/Dental/Vision for employees & dependent(s)
Vacation, Sick, and Other Leave
11 Paid Holidays per year
Public Employees Retirement System (PERS) plans
Life Insurance
Dependent Care Assistance
Flexible Spending Accounts
Public Service Loan Forgiveness
Tuition Waiver
Deferred Compensation
Employee Recognition Leave
Flexible schedules
part-time/hybrid telework options
A Wellness Program
an Infants in the Workplace Program
the Employee Assistance Program, which provides counseling, webinar, and other cost-free support resources
Numerous employee-driven affinity groups to foster community and connection, including Bereavement, Elder Care, Parenting, POC, LGBTQ+, Veterans and more.