Toxics Cleanup Program IT Data Management Journey

Salary : $90,096.00 - $121,176.00 Annually
Location : Thurston County - Lacey, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number: 2026-TCP2399-08282
Department: Dept. of Ecology
Division: Toxics Cleanup
Opening Date: 10/30/2026
Closing Date: Continuous
Salary Information: The high end of the salary range, Step M is typically a longevity step


Description
Keeping Washington Clean and Evergreen
The Department of Ecology is hiring an IT Data Management - Journey position within the
Location:

• Headquarters Office in
• Upon hire, you must live within a commutable distance from the duty station.

Schedule:

• This position is eligible for telework and flexible schedule options.
• You may telework most of your work time with occasional in-person meetings and activities. New employees may be asked to spend some time in the office during orientation and onboarding.
• Schedules are dependent upon position needs and are subject to change.

Application Timeline:

• Apply by November 8, 2026.
• Applications submitted after the date above may not be reviewed unless additional qualified applicants are needed.

Duties
The Toxics Cleanup Program (TCP) is seeking a Journey-level IT Data Management specialist to ensure the program's mission-critical data is accurate, accessible, and actionable. In this role, you will support environmental decision-making by transforming complex program data into reliable insights, guiding data governance practices, and helping staff navigate and use TCP's core information systems. This position plays a key role in maintaining high-quality data systems and enabling evidence-based program operations.
What you will do:

• Develop and maintain SQL queries, stored procedures, and data structures that support data extraction, reporting, and analysis for TCP systems.
• Build and administer business intelligence reports, dashboards, and data workflows using tools such as SSRS and Power BI.
• Serve as data steward and subject matter expert for various TCP environmental databases, maintaining system documentation, definitions, and business rules.
• Design and implement data quality monitoring, validation, and QA/QC processes to ensure accuracy and completeness of program data.
• Manage user access and role-based permissions for TCP's core data systems in coordination with agency IT and security staff.
• Participate in system updates, upgrades, and IT projects to assess data impacts and verify changes meet program requirements.
• Support staff through informal training, technical consultation, and guidance on data standards, reporting tools, and data interpretation.
• Maintain documentation for queries, reports, workflows, and data processes; stay current on evolving data tools and recommend improvements.

Qualifications
For detailed information on how we calculate experience and responses to other frequently asked questions, please visit our
Required Qualifications:
Five years of experience and/or education related to the duties of the position, which must include the following:

• SQL Development & Data Retrieval -Demonstrated competence to design, build, and optimize complex SQL queries, stored procedures, views, and functions to ensure accurate, efficient, and reusable data extraction that supports program operations and reporting needs.
• Business Intelligence & Data Modeling - Ability to create and maintain data models, ad hoc reports, and dashboards using SSRS and Power BI to provide clear, timely, and reliable information that improves program visibility and decision-making.
• Data Quality Assurance & Integrity Management - Experienced in developing validation routines, exception processes, and data audits to detect, document, and resolve data anomalies, ensuring completeness, accuracy, and reliability of program data.
• ETL/ELT Development & Data Transformation - Skilled with designing and maintaining ETL processes using SSIS or similar tools to move, transform, and integrate data across systems, enabling consistent and dependable data availability for analysis and reporting.
• Program Data Interpretation & Technical Documentation - Ability to translate program business rules into precise technical specifications, data definitions, and process documentation to ensure clarity, consistency, and repeatability in data management practices.
• Data Governance & System Stewardship - Experienced in applying data standards, access conventions, and system-level practices to maintain secure, well-documented, and well-managed data environments that support program workflows and operational continuity.
• Collaboration, Communication & Technical Support - Ability to work collaboratively with program staff to understand data needs, explain technical concepts, maintain data solutions, and provide guidance that ensures correct data entry, appropriate system use, and continuous improvement of data processes.

Education involving major study in Computer Science, Information Technology (IT), Science, Technology, Engineering, Mathematics (STEM), or closely related field.

Examples of how to qualify:

• 5 years of experience.
• 4 years of experience AND 30-59 semester or 45-89 quarter college credits.
• 3 years of experience AND 60-89 semester or 90-134 quarter college credits (Associate's degree).
• 2 years of experience AND 90-119 semester or 135-179 quarter college credits.
• 1 year of experience AND a Bachelor's degree or above.

Desired Qualifications:

• Enterprise SQL Platform Experience - Experience designing, optimizing, and maintaining SQL solutions within enterprise data environments such as Microsoft SQL Server or Azure SQL to support reliable, accurate, and efficient data retrieval.
• Cloud Analytics Administration - Demonstrated competence administering cloud-based analytics environments such as Power BI Service to ensure secure, organized, and dependable delivery of reports, data models, and refresh operations.
• ETL/ELT Development & Cloud Integration - Experience supporting ETL/ELT processes using SSIS, Azure Data Factory, or comparable tools to enable consistent, automated movement and transformation of data between systems.
• Modern Data Warehousing & Cloud Analytics Tools - Familiarity with data warehousing concepts or modern analytics platforms such as Azure Synapse, Databricks, or Microsoft Fabric to enhance the agency's ability to adopt and utilize evolving cloud-based data solutions.
• Advanced Scripting for Data Analysis - Experience using Python or R for data profiling, automation, or analytical tasks to expand data processing capabilities beyond SQL alone.

If you are excited about this role and meet the required qualifications, we encourage you to apply. Desired qualifications reflect additional knowledge, skills, or experience that are nice to have but not required. Studies have shown that some applicants, especially women and people of color, are less likely to apply unless they meet every listed qualification. At the Department of Ecology, we are dedicated to building a diverse and authentic workplace centered in belonging, and we welcome applicants with varied backgrounds and unique perspectives.
Supplemental Information
Ecology does not use the E-Verify system; therefore, we are not eligible to extend STEM Optional Practical Training (OPT). For more information, please visit
Application Process

Ecology seeks diverse applicants: We view diversity, equity, inclusion, and respect through a broad lens including race, ethnicity, class, age, religion, sexual orientation, gender identity, immigration status, military background, language, education, life experience, physical disability, neurodiversity, and intersectional identities. Qualified job seekers from all backgrounds are encouraged to apply.
How to Apply

Click "Apply" at the top of this page. Complete the entire application, including full work history and responses to all supplemental questions, and attach the following required documents :

• Cover letter, describing your interest in and qualifications for this position
• Resume

Because we base our selection on the information you provide, it is in your best interest to complete the application thoroughly. A resume will not substitute for the "work experience" section of the application or vice versa. Applications with blank fields or supplemental question responses with comments such as "see resume" may be considered incomplete.
For detailed application information, please visit our
Application Attestation: By submitting an application, you are affirming that the information contained in your application and on all attachments is complete and truthful. The state may verify this information, and any false or misleading answers may result in rejection of your application or dismissal if employed.

Need an Accommodation?

If you need reasonable accommodation during the application and/or screening process, including this job announcement in an alternate format:

• Please contact us at or
• If you are deaf or hard of hearing, you may call through the Washington Relay Service by dialing 711 or 1-.

Questions?

• For specific questions about the position location options, schedule, or duties, please contact Robert Grazia at .
• If you need assistance applying for this job, are inquiring about the status of your application, would like to request the full position description, or have any other questions, please contact the Recruitment Team at

About the Toxics Cleanup Program

The mission of the Toxics Cleanup Program (TCP) is to protect human health and the environment for the people of Washington by preventing, reducing, or eliminating exposure to contamination to support the development of environmentally and economically sustainable communities. This position is housed within the Information Communication Unit (ICU), which provides information, tools and services that support Ecology staff and managers in their efforts to clean up contaminated sites. The ICU develops and maintains information systems to support three main groups:

• TCP managers that require reliable information to evaluate program performance and make decisions regarding budget, grant applications, workload and resource allocation.
• TCP staff that require reliable information on environmental conditions at particular sites and analytical tools for evaluating that information when developing cleanup plans.
• Members of the public who request information on sites and program performance (such as members of the news media, land developers, general public and more).

About the Department of Ecology

As the State of Washington's environmental protection agency, we are deeply committed to protecting, preserving, and enhancing Washington's environment for current and future generations. Joining Ecology means becoming part of a team dedicated to protecting and sustaining healthy land, air, water, and climate in harmony with a strong economy. A career in public service at Ecology allows you to help solve some of the most challenging problems facing our state, while keeping your health and financial security a priority. We combine one of the most competitive benefits packages in the nation with a strong commitment to life/work balance. We invest in our employees to create and sustain a working environment that encourages creative leadership, effective resource management, teamwork, professionalism, and accountability.
Diversity, Equity, Inclusion, and Respect (DEIR) are core values central to Ecology's work. We strive to be a workplace where we are esteemed for sharing our authentic identities, while advancing our individual professional goals and collaborating to protect, preserve, and enhance the environment for current and future generations.
We believe that DEIR is both a goal and an action. We are on a journey, honoring our shared humanity and taking steps to demonstrate our commitment to a vision where each of us is heard, seen, and valued.
Ecology employees may be eligible for the following: , , *, *, , , & , , , , , , , * Click here for more information
To learn more about Ecology, please visit our , explore , check out our , and connect with us on , , , , or our
Equal Opportunity Employer: The Washington State Department of Ecology is an equal opportunity employer. We strive to create a working environment that includes and respects cultural, racial, ethnic, sexual orientation and gender identity diversity. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age, veterans, military spouses or people with military status, and people of all sexual orientations and gender identities are encouraged to apply.
Collective Bargaining: This is a position covered by a bargaining unit for which the Washington Federation of State Employees (WFSE) is the exclusive representative.
Note: This recruitment may be used to fill other positions of the same job classification across the agency. Once all the position(s) from the recruitment announcement are filled, the recruitment may only be used to fill additional open positions for the next sixty (60) days.
#LI-Hybrid #LI-DNP
More than Just a Paycheck!
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.

We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.

Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.

To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.

The Washington State Employee Assistance Program promotes the health and well-being of employees.

Retirement and Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

Social Security
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.

Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.

Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.

Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.

Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.

Sick Leave
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.

Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.

Vacation (Annual Leave)
Full-time employees accrue vacation leave at the rates specified in (1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.

Part-time employees accrue vacation leave hours in accordance with (1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.

Pay status includes hours worked, time on paid leave and paid holiday.

As provided in , an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.

Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.

Military Leave
Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave
Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.

Additional Leave
Leave Sharing

Family and Medical Leave Act (FMLA)
Leave Without Pay

Please visit the State HR Website for more detailed information regarding benefits.

Updated 01-07-2026
01


How did you hear about this job?

• Community Based Organization
• Community / Technical College
• Ecology Employee
• Ecology Recruiter
• Ecology Jobs Page
• Facebook
• Job Board
• Job Fair
• LinkedIn
• Newspaper
• Other State Agency
• Other Website
• Professional Association
• Twitter
• University Job Board
• WorkSource
• Other

02


If you selected Community Based Organization, Community / Technical College, Job Board, Job Fair, LinkedIn Group, Newspaper, Other State Agency, Other Website, Professional Association, University Job Board, WorkSource, or Other, please share which one.
03


Have you ever worked for the Department of Ecology in any capacity including: Permanent, Non-Permanent, Project, Intern, or Volunteer?

• Yes
• No

04


How many years of experience do you have related to the duties of this position? Please include any experience gained through employment, internships, and/or volunteer positions. Note that experience gained from academic coursework, class projects, or other degree requirements is assessed in later questions.

• One year
• Two years
• Three years
• Four years
• Five or more years
• None of the above

05


Select your ability to design, build, and optimize SQL queries, stored procedures, views, and functions to support data extraction and reporting needs.

• None - I have no experience writing SQL queries.
• Foundational - I can write basic select queries with guidance.
• Intermediate - I can build multi-table joins and simple stored procedures to support routine reporting needs.
• Advanced - I design and optimize complex SQL queries, stored procedures, and views for large or interrelated data systems.
• Expert - I architect SQL solutions, tune performance, and troubleshoot complex relational data issues across multiple systems.

06


Please rate your ability to design and maintain data models, reports, or dashboards using SSRS, Power BI, or similar tools.

• None - I have not created reports or dashboards.
• Foundational - I can create basic visualizations using provided datasets.
• Intermediate - I can build structured reports and data models that support routine reporting needs.
• Advanced - I develop interactive dashboards and optimized data models that support decision-making.
• Expert - I design complex BI architectures, performance tuning strategies, and integrated reporting environments.

07


Please describe a situation where you identified a data quality issue and implemented a solution. What methods or tools did you use to diagnose the problem, and what steps did you take to correct it? If you do not have this experience, enter N/A.
08


What is your level of experience designing or maintaining ETL/ELT processes using SSIS or similar tools to move or transform data across systems?

• None - I have no ETL/ELT experience.
• Foundational - I can follow existing ETL workflows and make minor updates.
• Intermediate - I create and maintain ETL packages or equivalent workflows to support routine data movement.
• Advanced - I design robust ETL solutions, troubleshoot failures, and optimize performance across systems.
• Expert - I architect integrated enterprise ETL systems with complex transformation logic.

09


Provide an example of when you translated business rules or program requirements into clear technical specifications or data documentation. What steps did you take to ensure accuracy and usability? If not applicable, enter N/A.
10


Please rate your experience applying data governance practices such as naming conventions, access controls, or system-level data standards.

• None - I have no experience applying data governance practices.
• Foundational - I understand basic concepts and can follow established standards.
• Intermediate - I apply data governance practices consistently in my work and help others understand them.
• Advanced - I help develop or refine data standards and manage access or permissions for systems.
• Expert - I design governance frameworks or oversee governance practices across programs.

11


Provide an example of when you helped someone understand a technical data concept, system process, or reporting tool. What approach did you use, and what was the result? If not applicable, enter N/A.
12


Please provide additional details to support your responses to Questions 5 - 11 above. The following information is needed: position title(s), specific duties, and periods of employment. Make sure your response specifically addresses the qualification above. An incomplete answer, including "please see resume" may remove you from further consideration.
SQL Development & Data Retrieval -Demonstrated competence to design, build, and optimize complex SQL queries, stored procedures, views, and functions to ensure accurate, efficient, and reusable data extraction that supports program operations and reporting needs.
Business Intelligence & Data Modeling - Ability to create and maintain data models, ad hoc reports, and dashboards using SSRS and Power BI to provide clear, timely, and reliable information that improves program visibility and decision-making.
Data Quality Assurance & Integrity Management - Experienced in developing validation routines, exception processes, and data audits to detect, document, and resolve data anomalies, ensuring completeness, accuracy, and reliability of program data.
ETL/ELT Development & Data Transformation - Skilled with designing and maintaining ETL processes using SSIS or similar tools to move, transform, and integrate data across systems, enabling consistent and dependable data availability for analysis and reporting.
Program Data Interpretation & Technical Documentation - Ability to translate program business rules into precise technical specifications, data definitions, and process documentation to ensure clarity, consistency, and repeatability in data management practices.
Data Governance & System Stewardship - Experienced in applying data standards, access conventions, and system-level practices to maintain secure, well-documented, and well-managed data environments that support program workflows and operational continuity.
Collaboration, Communication & Technical Support - Ability to work collaboratively with program staff to understand data needs, explain technical concepts, maintain data solutions, and provide guidance that ensures correct data entry, appropriate system use, and continuous improvement of data processes.
13


What is your level of education?

• 30-59 semester or 45-89 quarter college credits
• 60-89 semester or 90-134 quarter college credits (Associate's degree)
• 90-119 semester or 135-179 quarter college credits
• Bachelor's degree or above
• None of the above

14


If you have college credits or a degree, please list your major(s) or field(s) of study and any degree(s) earned. If you don't have this education, put N/A.
15


The State of Washington and the Department of Ecology, play a vital role in fostering a Diverse, Equitable, Inclusive, and Respectful (DEIR) workplace and contributing to equitable outcomes for the communities we serve. We view DEIR through a broad lens including: race, ethnicity, class, age, religion, sexual orientation, gender identity, immigration status, military background, language, education, life experience, physical disability, neurodiversity, and intersectional identities. We believe it is everyone's job to contribute to a DEIR workplace. What experiences have you had working with people whose backgrounds are very different from your own? What impact did those experiences have on how you worked?
16


I understand that Ecology does not use the E-Verify system and is unable to extend STEM Optional Practical Training (OPT).

• Yes
• No

Required Question