IT Application Developer - Journey

About the role

The Washington State Department of Agriculture has been serving the state for over 100 years. Through service, regulation, and advocacy, we keep agriculture viable and vital in Washington State, while protecting consumers, public health, and the environment. We work extensively with farmers and ranchers, but our responsibilities – from ensuring food safety to environmental protection – touch the lives of millions of people locally, nationally, and abroad.

Responsibilities

• Serve as the agency’s subject matter expert and primary technical developer for The ERP business application (currently Dynamics GP).
• Maintain, enhance, and troubleshoot ERP application modules used by WSDA, including financial, purchasing, vendor management, and custom business processes.
• Design, develop, and maintain integrations between the ERP application system and other agency or statewide systems.
• Monitor, maintain, and troubleshoot EDI, EFT, banking, and other external ERP application connections.
• Develop and maintain stored procedures, views, triggers, and scripts to support ERP application functionality and reporting.
• Support and maintain ERP application reporting using SQL Server Reporting Services (SSRS), Management Reporter, and other reporting platforms.
• Provide Tier 3 technical support for Dynamics GP functional issues escalated from Finance/Accounting and IT staff.
• Coordinate with vendors, WaTech, and statewide technical teams on ERP application patches, service packs, and version upgrades.
• Ensure adherence to internal control, audit, and security requirements for financial system data.
• Represent WSDA IT in all technical activities related to the One Washington Workday implementation and transition away from the current ERP application.
• Identify and document all ERP application integrations, customizations, dependencies, scripts, and data flows that will be impacted by Workday adoption.
• Aid in the design and testing of new interfaces between Workday and downstream agency systems.
• Lead technical analysis, planning, and execution for the agency’s transition away from Microsoft Dynamics GP.
• Document current-state Dynamics GP architecture, integrations, workflows, and data structures.
• Work with Finance, IT leadership, and vendors to evaluate potential Dynamics GP replacement solutions.
• Identify migration requirements, risks, and technical constraints.
• Support procurement activities by providing technical input and requirements.
• Develop transition plans, migration strategies, test plans, and implementation timelines.
• Cookordination with Application Development, Systems, and Security teams to ensure successful migration and system cutover.
• Support new system configuration, integration development, QA, and deployment.

Qualifications

• Professionals with a bachelor’s degree in computer science OR four (4) years of IT work experience including three (3) years as a journey or equivalent.
• Eight (8) years of IT work experience including three (3) years as an IT-Journey level OR equivalent.
• Equivalent (private sector); with progressive responsibility within information technology to include two (2) years of experience in business requirements or high-level designs for business software applications.
• Knowledge and application of techniques for requirements gathering and writing high-level designs.
• Excellent understanding of programming logic and database structure/processing.
• Technical knowledge of and three (3) years of experience in application design.
• Understanding of GIS technology, experience in implementing GIS applications, and knowledge of data management for GIS systems.
• Technical knowledge of and three (3) years’ experience working with: Enterprise Resource Planning (ERP), Financial System, Visual Studio ASP.NET 6-8, C#, Blazor, Microsoft SQL 2016-2022, Microsoft SQL Server Reporting Services, Entity Framework, JavaScript, API Integration, Web Services, Crystal Report (version 10-11), Project Management, Project Estimates.
• Advanced knowledge of SQL Server 2019-2022.
• Advanced knowledge in using MS-VisualStudio Development tools to maintain and develop agency or enterprise level systems.
• Ability to provide high-level support for more than one project at a time.

Supplemental Information

Employee Benefits: A healthy work/life balance, which may include flexible work schedules, and teleworking. WSDA provides an excellent benefits package beyond traditional benefits. State employment offers Dependent Care Assistance, Flexible Spending Accounts, Public Service Loan Forgiveness, Tuition Waiver, Deferred Compensation, Employee Recognition Leave; click here for more information. 12 paid Holidays & Vacation and Leave Accruals. All Personal Protective Equipment (PPE) required will be provided by the agency.

Contact Us

If you have any questions regarding this position or the online application, contact the Human Resource Office at Recruitment@agr.wa.gov.