IS Data Services Professional

Job Description: 

The position will be an expert on the EPA Exchange Network grant, ending October 2018, updating WDNR data systems to incorporate data flows to federal databases, and to develop web services to support the transfer of water quality data to and from external partners, organizations, and agencies. WDNR data systems include the Surface Water Integrated Monitoring system (SWIMS); Waterbody Assessment, Tracking, and Electronic Reporting System (WATERS); Fisheries Management Database, and the Fish Contaminant System. Specific goals of this project are to, 1) update the DNR’s data flows to fully implement EPA’s newly redesigned national data exchange flow configuration for required reporting of waterbody assessment results, 2) update the DNR’s Water Quality Exchange (WQX) schema to utilize the most recent version that supports physical, chemical, biological, and habitat raw data flows, and 3) develop web services that instantaneously link to DNR’s datasets to promote transparency and customer service support. The position will be the technical leader in IT infrastructure planning to facilitate data transfers among systems. The role includes writing high-level Oracle SQL queries, writing scripts for computer automation, documenting decisions, QA/QC, IT infrastructure integration, and data management support. Finally, the position will be instrumental in maintaining effective communication and coordination among project team members and external partners, including participation in grant coordination, tracking, and reporting. This effort requires knowledge of new technologies including web services, map services, Exchange Network protocols, and object-relational database management systems. Percent of time performing various duties: 40% – Assist in designing data flow procedures between DNR and external systems. Format and validate data, prepare databases, evaluate flows (quality assurance/quality control; QA/QC), and document procedures. Collaborate with technical programming staff to automate processes or fulfil other programming needs. 40% – Help prepare various raw datasets for upload to databases, assist in QA/QC process, generate automated reports based upon the data. Manage and display data or results in various spatial viewers and web pages. 20% – Project coordination. Set up and facilitate meetings among grant supervisors, task leaders, and technical staff to document progress towards grant goals. Compile progress reports for submittal to EPA as per grant requirements.

Knowledge Required: 

Ability to work independently with little supervision. Excellent skills in problem-solving, collaboration, and communication including speaking, writing, and listening. Need superior organization and attention to detail. Proficiency is needed in Microsoft Office, especially Access and Excel. Experience processing and maintaining large volumes of data, stored procedures, and functions. An ideal candidate has some combination of education or experience among the following: Data systems design, analysis, development, documentation, testing, debugging, and deployment. Use of ESRI ArcGIS software and extensions, Geocortex and plugins, scripting with Python or .NET, various web services, Oracle 11g data systems, and writing SQL queries. 

Application Deadline: May 23, 2016

To Apply: Submit Form 9100-162 LTE Application (hard copy also available at most DNR offices) , resume, cover letter and references to:

Brian M. Weigel 
PO Box 7921 
Madison, WI 53707-7921 
RE: Job Code 10495