Data Systems Developer (IT Data Management – Journey)

About the role

The Department of Ecology is hiring a Data Systems Developer (IT Data Management – Journey) within the Spill Prevention, Preparedness, and Response program. The position is eligible for telework and flexible schedule options.

Responsibilities

• Assist in the development, maintenance, and evolution of the program’s mission-critical information systems.
• Serve as part of a team to provide data management and application development services for the program.
• Design, develop, test, and implement highly complex custom applications using modern development tools and agency standards.
• 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.
• Influence program strategies, participate in architecture discussions, and ensure that technical systems are reliable, scalable, secure, and aligned with business needs.
• 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.

Qualifications

• 5 years of experience and/or education related to the duties of the position, which includes the following:
• 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 (e.g., C#, ASP.NET, JavaScript, SQL Server) to support program operations and external user needs.
• Education involving a major study in Computer Science, Information Technology (IT), Science, Technology, Engineering, Mathematics (STEM), or closely related field.

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.

Pay

Details on pay are not specified in the job posting.

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. Schedules are dependent upon position needs and are subject to change.

Benefits

Details on benefits are not specified in the job posting.