IT Data Management – Journey, Information Services Division, Tumwater

Persons requiring reasonable accommodation in the application process or requiring information in an alternative format may contact the recruitment team atHREmployment@atg.wa.gov. Those with a hearing impairment in need of accommodation are encouraged to contact the Washington Relay Service at 1-800-676-3777 orwww.washingtonrelay.com.

Position and Salary
The Attorney General’s Office is recruiting for a permanent full-timeIT Data Management – Journeyin the Information Services Division. This position is located in Tumwater, Washington, and is not union-represented.

Salary range 06IT: $88,832 - $118,800
The base pay offered will take into account internal equity and may vary depending on the preferred candidate’s job-related knowledge, skills, and experience.

• Employees within the information technology professional structure who are in the entry, journey, and senior/specialist levels designated as and performing all the duties of a supervisor will receive 5% supervisory pay differential.
• Incumbents assigned to our Seattle office location receive an additional 5% King County Location Pay stipend.
• Incumbents assigned to a position designated as requiring dual language skills will receive a 5% Dual Language Requirement Pay stipend.

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.

Excellent benefits
Washington State offers one of the most competitive benefits packages in the nation, including Medical/Dental/Vision for employees & dependent(s); Vacation, Sick, and Other Leave; 11 Paid Holidays per year; Public Employees Retirement System (PERS) plans; and Life Insurance. Beyond these traditional benefits, we offer Dependent Care Assistance, Flexible Spending Accounts, Public Service Loan Forgiveness, Tuition Waiver, Deferred Compensation, Employee Recognition Leave, and more. With the goal of employee health and wellness, we also offer:

• Flexible schedules and part-time/hybrid telework options;
• A Wellness Program, an Infants in the Workplace Program, and 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. The AGO is a place to belong and make a difference!

About the Information Services Division

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.

Duties and Essential Functions of an ITDataManagement - Journey

In this position, you will supervise a team responsible for developing advanced reporting, data analytics, data transformation, data integrations with third-party platforms and database administration services. Responsibilities include, but are not limited to:

Advanced Reporting, Data Analytics & Dashboard Development

• Collaborate with cross-functional teams to identify business requirements, predict, and solve reporting needs that allow them to measure and track key performance indicators, determine trends, and make business decisions based on data
• Create and enhance reports and dashboards for agency leadership and staff.

Third-Party Platform Integration & Administration

• Administer and support specialized agency platforms, including SQL Server, SQL Reporting Services, SQL Analysis Services, Tableau and Snowflake.
• 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, ensuring reliability, performance, and reusability.
• Coordinate with vendors and internal technology teams to troubleshoot issues and maintain system performance.

System Monitoring, Support & Continuous Improvement

• Monitor the performance of automation workflows, integrations, and platform services.
• Diagnose and resolve technical issues affecting automation processes and system integrations.
• Lead and supervise Database Administration services; provide maintenance and operation services including performance, monitoring, security, problem resolution and business continuity; prepare and maintain documentation for databases and applications; assist clients in leveraging IT application resources; apply industry best practices; develop test plans and test new releases.

This recruitment announcement may be used to fill multiple open positions for the same classification which may include positions with different lengths or permanency of appointment, beyond those specifically listed here.

Required Qualifications

Option 1: Eight (8) yearsof information technology experience such as analyzing, designing, or programming software applications, data analytics, or dashboard development.

Option 2: An Associate's degree in Computer Science OR equivalent ANDSix (6) yearsof information technology experience such as analyzing, designing, or programming software applications, data analytics, or dashboard development.

Option3: A Bachelor's degree in Computer Science OR equivalent AND Four (4) yearsof information technology experience such as analyzing, designing, or programming software applications, data analytics, or dashboard development.

AND

Provide proof of at least two-years' experience within the past four years, and demonstrate proficiency developing applications and other software solutions using the following integrated developing environment tools:

• Microsoft SQL Server or equivalent
• SQL Server Management Studio orequivalent
• SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server Analysis Services (SSAS) or equivalent
• ETL Technologie sand Transact-SQL

Skills and Abilities

The most competitive candidates will possess the following desired qualifications:

Experience within the past three years with the following programming skills, languages, software and/or programs:

• Agile software development methodologies
• Asynchronous JavaScript and XML (AJAX)
• jQuery
• Web Services — ASP.NET Web API, XML Web
• Services or Restful APIs
• MVC or C#
• Version Control Software (Team Foundation Server or equivalent)
• Analytic Dashboard Creation (Tableau, Power BI or equivalent)

About the Washington State Office of the Attorney General
The Attorney General’s Office (AGO) touches the lives of every resident in this state. We serve more than 230 state agencies, boards, commissions, colleges and universities, as well as the Legislature and the Governor. The Office is comprised of nearly 700 attorneys and 800 professional staff, all working together to deliver the highest quality professional legal services to Washington state officials, agencies, and entities. This includes:

• Economic justice and consumer protections (safeguarding consumers, protecting youth, seniors, and other vulnerable populations)
• Social justice and civil rights (addressing discrimination, environmental protection, and veteran and military resources)
• Criminal justice and public safety (investigative and prosecutorial support, financial crimes)
• And much more!

Our agency also has national reach, representing the State of Washington before the Supreme Court, the Court of Appeals and trial courts in all cases that involve the state’s interest. If you want to make a difference, we may be the perfect fit for you! Learn more about the AGOhere.

Commitment to Diversity
Diversity is critical to the success of the mission of the AGO. This means recognizing, respecting, and appreciating all cultures and backgrounds-- and fostering the inclusion of differences between people. Appreciating, valuing and implementing principles of diversity permits AGO employees to achieve their fullest potential in an inclusive, respectful environment.

One recent measure of the AGO's commitment to diversity can be found in its nomination for Rainbow Alliance and Inclusion Network's"Outstanding Agency Award" in 2019. Our commitment to employee wellness is reflected in earning the 2024 Zo8 Washington Wellness Award.

Application Instructions

In addition to completing the online application, applicants must attach the following documents to their profile in order to be considered for this position:

• A letter of interest, describing your specific qualifications for the position;
• A current resume detailing experience and education.

Read the Following Information Completely:

• Carefully review your application for accuracy, spelling and grammar before submitting.
• You may not reapply to this posting for 30 days.
• The initial screening of applications will be solely based on the contents and completeness of the “work experience” and “education” sections of your application in www.careers.wa.gov, completeness of the application material submitted, and responses to the supplemental questionnaire.
• A resume will not substitute for completing the “work experience” section of the application.
• All information may be verified and documentation may be required.
• The Washington State Office of the Attorney General does not use the E-Verify system; therefore, we are not eligible to extend STEM Optional Practical Training (OPT). For more information, please visit www.uscis.gov.
• The AGO complies with employment eligibility verification requirements of the federal employment eligibility verification form, I-9, and the selected candidate for these roles, on the first day of employment, must be able to provide proof of identity and eligibility to work in the United States consistent with the requirements of form I-9. In order to proceed in the consideration process at AGO, you will need to provide work authorization that would not require the AGO to sign a cooperative education agreement with a school.

Equal Employment Opportunity and Accommodations Requests

Honoring diversity, equity and inclusion means that as an agency, and as individuals, we are committed to ensuring that all employees and volunteers enjoy a respectful, safe and supportive working environment. Only by fostering the inclusion of people from all backgrounds, cultures and attributes, can AGO employees and volunteers achieve their fullest potential and best advance the goals and mission of the AGO.

The AGO is an equal opportunity employer and does not discriminate on the basis of race, creed, color, national origin, sex, marital status, sexual orientation/gender identity, age, disability, honorably discharged veteran or military status, retaliation or the use of a trained dog guide or service animal by a person with a disability. Persons requiring reasonable accommodation in the application process or requiring information in an alternative format may contact the recruitment team atHREmployment@atg.wa.gov. Those with a hearing impairment in need of accommodation are encouraged to contact the Washington Relay Service at 1-800-676-3777 or www.washingtonrelay.com.

For questions regarding this recruitment or assistance with the application process, please contact the recruitment team atHREmployment@atg.wa.gov. If you are having technical difficulties creating, accessing or completing your application, please call NEOGOV toll-free at (855) 524-5627 or support@neogov.com.