Application Development

Location: Oklahoma City, OK (Onsite) • Duration: 9 Months

About the role

The Oklahoma Department of Agriculture, Food, and Forestry’s Consumer Protection Services Division is looking for development support for our new Inspections application. The Inspections application will allow agency field inspectors to collect agricultural inspections data via online forms, save the data to the SQL database, and generate and store PDF documents. The Department’s existing inspections program is scheduled to be decommissioned in Spring of 2027, and the replacement system is being developed in-house.

Responsibilities

• Convert approximately seventy existing fillable PDF inspection documents into new interactive HTML forms for data collection.
• Use JavaScript to build functionality for inspector inputs to be saved to the SQL database.
• Use Jinja templates to compile those inputs back into new PDF files.
• Provide JavaScript development support as needed to help keep the current project on track.

Requirements

• Beginner to intermediate experience with JavaScript.
• Experience with SQL (T‑SQL or any variant).
• Proficiency in HTML and CSS.

Skills

• Experience with Python (plus, can be learned on the job).
• Experience with Docker (plus, can be learned on the job).
• Experience with Jinja (plus, can be learned on the job).
• Experience with Git/GitHub (plus, can be learned on the job).