59566: Columbus, OH – IT – EPA – Product Specialist 3/PS3

Job Title: PS3
NFP Rate: $56.04
Will close to submissions: Monday 2/25/19 at 10:00am EST
Interviews: Onsite only

Start date expected: 04/01/19

Job Description:

.  DES (Division of Environmental Services) is requesting assistance with approximately 10 projects requiring extensive knowledge of Excel, beyond the capabilities of any staff currently at DES.
.  These projects will be used primarily to organize and summarize data from instrument output files, sort, flag out of range data, and apply calculations to this data.
.  Projects range in size from modifications to macros and coding in existing spreadsheets to the creation of new spreadsheets to perform certain data comparison functions. We will also require assistance in the creation of spreadsheets to work with a software program, Winwedge, which can capture data via an RS232 connection directly to Excel.
.  We anticipate these projects will involve the creation and running of macros along with using various data functions and advanced sorting within Excel such as pivot tables, charts, complex formulas, and VLOOKUPS. They will also require the construction of complex Excel workbooks including automation using macros, data manipulation functions, importing and exporting data.

.  DES staff will be available to work closely with the resource to assist and learn the skills necessary to maintain the spreadsheets moving forward.

Comments are closed.