Toxics Cleanup Program IT Data Management Journey
State of Washington
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
State of Washington's Department of Ecology seeks an IT Data Management - Journey to ensure data accuracy, accessibility, and actionable insights for TCP. You will transform complex program data into reliable information, guide governance, and empower staff with data tools.
The role blends SQL development, BI reporting (SSRS/Power BI), data stewardship, governance, and collaboration with IT and program staff. Telework-eligible hybrid role from Lacey, WA.
Qualifications
- Five years of related experience/education required.
- Demonstrated ability to design, build, and optimize SQL queries for reporting.
- Create and maintain data models, dashboards, and ad hoc reports.
- Develop data quality routines, audits, and validation processes.
- Translate business rules into technical specifications and docs.
- Apply data standards, access conventions, and governance practices.
- Collaborate with staff to tailor data solutions and provide guidance.
Responsibilities
- Develop and maintain SQL queries, stored procedures, and data structures.
- Build BI reports and dashboards using SSRS and Power BI.
- Serve as data steward for TCP databases and document business rules.
- Design data quality monitoring, validation and QA/QC processes.
- Manage user access and permissions with IT and security.
- Support system updates and IT projects affecting data.
- Provide informal training and guidance on data standards and tools.
- Maintain documentation for queries, reports and data processes.
Skills
Education
Tools
Job description
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 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.
- 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.
- 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.
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 www.uscis.gov.
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.
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 Recruitment website.
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.
If you need reasonable accommodation during the application and/or screening process, including this job announcement in an alternate format:
- Please contact us at 360-407-6186 or careers@ecy.wa.gov
- If you are deaf or hard of hearing, you may call through the Washington Relay Service by dialing 711 or 1-800-833-6384.
- For specific questions about the position location options, schedule, or duties, please contact Robert Grazia at Robert.Grazia@ecy.wa.gov.
- 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 careers@ecy.wa.gov
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), whichprovides 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).
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.
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 Medical/Dental/Vision for employee & dependent(s) Public Employees Retirement System (PERS) Vacation, Sick, and other Leave * 11 Paid Holidays per year * Public Service Loan Forgiveness Tuition Waiver Long Term Disability & Life Insurance Deferred Compensation Programs Dependent Care Assistance Program (DCAP) Flexible Spending Arrangement (FSA) Employee Assistance Program Commute Trip Reduction Incentive Combined Fund Drive SmartHealth * Click here for more information
To learn more about Ecology, please visit our website, explore Working at Ecology, check out the Strategic Plan, and connect with us on LinkedIn, Facebook, Instagram, YouTube, or our blog.
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.
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
