Data Systems Developer (IT Data Management – Journey)

Keeping Washington Clean and Evergreen The Department of Ecology is hiring a Data Systems Developer within the Spill Prevention, Preparedness, and Response program. Location: Lacey, WA Must live within commutable distance from the duty station. Schedule: Position eligible for telework and flexible schedule options. May telework most of the working time with occasional in-person meetings. Schedules may change based on position needs. Application Timeline: Apply by July 26, 2026 Applications after this date may not be reviewed unless additional qualified applicants are needed. In this role, you will assist in the development, maintenance, and evolution of the program’s mission‑critical information systems. This role is ideal for a seasoned professional who enjoys solving complex technical problems, building sophisticated databases and application ecosystems, and shaping modern technology solutions that directly support environmental protection. You will serve as part of a team to provide data management and application development services for the program. You will independently design and manage advanced databases, build and maintain custom applications used by spill responders and regulatory staff, and deliver technical solutions that enable fast, accurate decision‑making in high‑stakes oil spill prevention and response scenarios. You will also influence program strategies, participate in architecture discussions, and ensure that technical systems are reliable, scalable, secure, and aligned with business needs. What you will do: Design, develop, test and implement highly complex custom applications using modern development tools and agency standards. Design, develop, optimize and maintain Spills Program databases, including schema design, stored procedures, integrations, and performance enhancements. Provide technical guidance and consult with program staff to improve business workflows, ensure high‑quality data, and contribute to long‑term data and application strategies. Develop user interfaces and mobile application components that support daily work of spill responders, inspectors, plan reviewers, and public users. Build and maintain reporting environments and advanced data retrieval systems, including SSRS reports, spatial data integrations, and sustainable ETL processes. Analyze and resolve complex technical issues across applications, ensuring smooth system interoperability and uninterrupted service for all end users. Support oil spill risk modeling and analysis teams by designing and maintaining specialized data systems, preparing datasets, and developing custom scripts and queries. Collaborate with agency IT teams (ITSO, ITSS, Application Developers, Enterprise Architects) to ensure system security, SQL ecosystem alignment, architectural consistency, and successful project delivery. Required Qualifications: 5 years of experience and/or education related to the duties of the position. Critical Thinking and Problem Solving – Ability to assess complex data and system issues to develop solutions that keep information systems reliable and aligned with business needs. Collaboration and Communication – Ability to work effectively with staff, IT teams, and partners to translate needs, share information, and ensure systems function well for all users. Decision Making and Judgment – Ability to independently make sound technical and workflow decisions to ensure data systems and applications meet program, agency, and industry standards. Business Process and Workflow Improvement – Ability to evaluate how data and applications support work processes and recommend clear, practical improvements to increase efficiency and data quality. Database Design and Development, SQL and Data Processing – Ability to design, build, and maintain databases to ensure program data is well‑structured, secure, scalable, and accessible. Ability to write and optimize SQL queries, stored procedures, and ETL routines to support reporting, system integration, and analytical work. Application Design and Development – Ability to build and maintain applications using standard development tools (C#, ASP.NET, JavaScript, SQL Server) to support program operations and external user needs. Education 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 higher. Desired Qualifications: System Integration and Troubleshooting – Ability to connect data and applications across systems and resolve technical issues to prevent disruptions and maintain reliable service. Reporting and Data Visualization – Ability to create and manage reporting tools and environments (such as SSRS) to support decision‑making, analysis, and QA/QC activities. GIS and Spatial Data Integration – Ability to incorporate spatial datasets into databases and applications to support environmental analysis and program operations. Project and Solution Planning – Ability to plan, scope, and lead development efforts—from requirements through implementation—to deliver dependable databases and applications. Data Governance and Quality Management – Ability to define data requirements, standards, and practices to ensure program information is accurate, consistent, and usable. Our Commitment to DEIR Diversity: We celebrate and appreciate diversity; our unique perspectives and abilities enrich us all and lead to innovative approaches and solutions. Equity: We champion equity, recognizing that each of us need different things to thrive. Inclusion: We intentionally create and hold space so that we all have meaningful opportunities to participate and contribute to Ecology’s work. Respect: We treat each other with respect and dignity, acknowledging the inherent worth of our diverse perspectives and lived experiences, even in times of uncertainty and disagreement. 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. 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. #J-18808-Ljbffr