Data Systems Developer (IT Data Management – Journey)

Data Systems Developer Keeping Washington Clean and Evergreen Location: Headquarters Office in Lacey, WA. You must live within a commutable distance from the duty station. Schedule: Eligible for telework and flexible schedule options. Telework most of the time with occasional in-person meetings. Schedules are dependent on position needs and subject to change. Application Timeline: Apply by July 26, 2026. Applications submitted after may not be reviewed unless additional qualified applicants are needed. Responsibilities Assist in development, maintenance, and evolution of the program’s mission‑critical information systems. 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 the 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 and 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. Application Design and Development – Ability to build and maintain applications using standard development tools (e.g., C#, ASP.NET, JavaScript, SQL Server). Desired Qualifications System Integration and Troubleshooting – Ability to connect data and applications across systems and resolve technical issues. Reporting and Data Visualization – Ability to create and manage reporting tools and environments (e.g., SSRS). GIS and Spatial Data Integration – Ability to incorporate spatial datasets into databases and applications. Project and Solution Planning – Ability to plan, scope, and lead development efforts from requirements through implementation. Data Governance and Quality Management – Ability to define data requirements, standards, and practices to ensure program information is accurate, consistent, and usable. Benefits Benefits include Medical/Dental/Vision, 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, SmartHealth, and more. 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, gender identity diversity. Women, racial and ethnic minorities, persons of disability, persons over 40, veterans, military spouses, and people with various identities are encouraged to apply. #J-18808-Ljbffr