Data Specialist

# Summary

To support the enterprise data warehouse by meeting the data needs and data quality standards of the Cooperative. Administer and maintain the enterprise data warehouse and business databases to make data available, accessible, and secure. Develop advanced reporting and dashboards using business analytics software.

# Reporting

- Reports to: Manager of Applications

- Directs: None

# Responsibilities

- Collaborate with subject matter experts across the organization to assess data needs, understand processes, and develop plans for meeting those needs.

- Collaborate with subject matter experts to define data quality standards and implement procedures to maintain data quality.

- Design, implement, and maintain database structures and metadata to support the data needs of the Cooperative.

- Design, develop, and maintain ETL/ELT processes for loading Cooperative data into the enterprise data warehouse.

- Perform regular maintenance activities such as backups, re-indexing, archival, performance monitoring and tuning, patches, and upgrades to business databases and the enterprise data warehouse.

- Design, develop and maintain advanced reporting and dashboards using business analytics solutions.

- Assist with designing, maintaining, and documenting the processes, metadata and policies related to the enterprise data warehouse.

- Maintain current knowledge of Cooperative’s information systems and databases.

- Maintain confidentiality of work at a professional level.

- Adhere to all SVEC’s security standards.

- Perform other activities as requested or required by the position.

- Coordinate and cooperate with all Cooperative personnel and persons outside the organization where the providing of information and assistance will benefit the member-owners of the cooperative.

- Ensure all program sources, equipment, operational programs, documentation, documents, spreadsheets, data files, and all other work, including information contained on his/her personal computer at SVEC “are and remain” the private property of the Cooperative.

- Provide after-hours support for application-related issues that require immediate attention.

- Assist in special projects as necessary.

# Education and Experience

- Bachelor’s degree in computer science, information technology, or related field or related experience and/or training or equivalent.

- Working knowledge of programming and database design concepts.

- Must possess strong SQL skills.

- Experience with IBM Cloud Pak for Data is preferred.

- Experience with IBM Cognos Analytics or similar business analytics tool is preferred.

- Experience with Red Hat Linux, OpenShift, and containerized software systems is preferred.

# Required Skills and Abilities

- Must be able to maintain professionalism and control under all circumstances.

- Has and maintains a valid driver’s license and acceptable driving record and is able to operate SVEC vehicles.

- Must become and remain certified in CPR and first aid. Must also be skilled in the use of safety equipment.

- Ability to handle the challenge of operating efficiently under a very flexible schedule due to the number of unanticipated and unplanned requests for services from the various individuals, departments, and outside contacts with whom this position is involved.

- Leadership ability and the ability to motivate peers toward goal achievement.

- Strong verbal, written, analytical and interpersonal skills.

- Demonstrated problem-solving skills.

- Ability to perform job responsibilities in a timely manner within established guidelines under minimal supervision.

- Ability to independently learn new technologies through research and vendor provided documentation.

- Must be able to reason analytically and relate theoretical concepts to practical needs.

- Must be well organized.

- Ability to communicate effectively orally and in writing and carry out delegated duties with a minimum of supervision.

- Proficient in Microsoft Office products including Excel and Word.

- Must have access to reliable transportation to and from work.

# Physical Requirements

- Participation in SVEC job safety and training programs, relevant workshops, seminars and other SVEC sponsored courses and events.

- Must be able to use office equipment including telephone, computer, and other systems and related software in the performance of position responsibilities.

- Must be able and available, during any and all types of weather conditions, to work weekends, holidays, evenings and other times outside normal duty hours to assist in service restoration and other emergencies that may arise or when the workload demands.

- Must always maintain an operating telephone or personal communication device at his/her place of residence. Ability to contact the telephone or personal communication device must be made available to SVEC for the purpose of contacting the manager to conduct legitimate routine and/or emergency business.

- This position primarily works indoors. Must be able to lift objects unassisted (up to 30 pounds). Some standing, walking, climbing, balancing, stooping, kneeling, crouching, or crawling to a minimal degree.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

To support the enterprise data warehouse by meeting the data needs and data quality standards of the Cooperative. Administer and maintain the enterprise data warehouse and business databases to make data available, accessible, and secure. Develop advanced reporting and dashboards using business analytics software.