Toxics Cleanup Program IT Data Management Journey

Keeping Washington Clean and Evergreen

The Department of Ecology is hiring an IT Data Management - Journey position within the Toxics Cleanup Program (TCP).

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

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

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

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.

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

For detailed information on how we calculate experience and responses to other frequently asked questions, please visit our Recruitment website.

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…