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. This position uses an agile development methodology, innovation, and creativity to complete assignments. This position applies technical programming knowledge to evaluate and develop data driven solutions and interfaces, data transformation, data integrations with third-party platforms, report development and backup database administration services. The ideal candidate for this position will have demonstrable technical problem-solving skills, the interest and desire to understand complex business processes and data complexity and the desire to learn and grow.

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

Experience within the past three (3) years with the following programming skills, languages, software and/or programs: Microsoft SQL Server C#, ASP.NET, MVC, JavaScript 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) Analytic Dashboard Creation (Tableau, Power BI)

Responsibilities

Create and enhance reports and dashboards for agency staff utilizing SSRS, advanced Excel, and Tableau.
Perform customizations and integrations with off-the-shelf (COTS) solutions.
Develop interfaces using approved Application Programming Interface (APIs) to incorporate data from various data sources and systems into agency databases.
Identify root cause and resolve incidents by providing work around and/or fixing bugs in existing code.
Develop and maintain integrations between third-party platforms and systems to enable secure and reliable information exchange.
Extract, transform, and load data (ETL) from a broad range of sources (on-premises, cloud, and SaaS systems) into data marts, data warehouses, and relational databases.
Administer, monitor and support specialized agency platforms, including SQL Server, SQL Reporting Services, SQL Analysis Services, Tableau and Snowflake.
Provide SQL coding reviews and recommendations for consistency, security, functionality, and efficiency.

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.