Job Description :
Extracts and manipulates data from multiple systems across various departments to create statistical reports; analyzes department statistics, notes trends and makes recommendations to management; evaluates database effectiveness and reviews data for accuracy and trends; conducts training and provides technical support to database users; and researches and investigates data accuracy of reports and information.
Duties:
Analyzes requests for information and determines how to extract the data from the database systems for the appropriate reports. Develops and tests the accuracy of reports created to ensure high quality information is provided to end-users. Documents processes, conducts training, and provides technical support to database users. Gathers and summarizes data from various sources in order to complete reports and special projects. Retrieves records or data and distributes information as appropriate in order to provide timely and accurate information to department members or external customers. Maintains database systems, ensuring the integrity of the data within each system and resolves issues relating to the database information. Collaborates with various departments to develop and support data reporting needs.
Specific Position Requirements:
In addition to the job description for the Data Coordinator II position, this position will also require a person that knows, understands, and actively uses Microsoft Excel VBA and macros and can create, edit, and manipulate complex excel VBA programs. The positions main responsibility is to coordinate all activities for combine headers. This includes working with the factory to order new heads, working with a union shop on updating and prioritizing work on the heads, and working with engineering on scheduling and priorities of the heads. The positions other responsibilities is working with the PV&V Validation team lead on creating, generating, and maintaining data and documents on field schedules, work priorities, asset management, manpower planning, and general testing documentation. Most of these documents are maintained in excel and require VBA manipulation to produce status reports as well as workable views of the current plans.