Product​/Data Specialist; Application Testing, SQL & Oracle - CTC - ONSITE in Augusta, ME

Overview

Product Specialist 2 / Data Specialist position is part of the Health Inspection Program (HIP) within the Maine Center for Disease Control and Prevention. The role collaborates with the Office of Information Technology (MaineIT) to ensure data and systems support are maintained and will support HIP, Maine CDC, and MaineIT with technical assistance programs. Work will be performed on site or remotely with daily collaboration with team members.

On-site meetings are required for the first 3 months of orientation; after 3 months, occasional on-site meetings may be required. The HIP application supported is , used for licensing, inspection, enforcement and reporting services.

Work Location:

100% Onsite in Augusta, ME for the first 3 months, then a hybrid schedule will be determined. Local candidates within an hour radius of Augusta, ME will be considered. Work may be performed on site or remotely with daily collaboration with team members. Initially, on-site meetings will occur for the first 3 months of orientation. After 3 months, occasional on-site meetings may be required.

This position provides oversight for tracking all aspects of licensing, inspection and enforcement data; develops and manages quality assurance and quality control processes to facilitate effective and efficient regulatory compliance, including creating queries to facilitate QA/QC; coordinates and advises on proper documentation of information in the database of record; provides guidance and assistance to staff on database-related issues (including developing standard operating procedures, creating and conducting training seminars and technical assistance on database organization and workflow issues);

provides advice and recommendations for policy changes and is responsible for quality control of all data entered into the  system (approximately 26 users). Tasks include business coordination and/or process management oversight, data querying for quality control and assurance, supporting application testing, overseeing application ticket management, planning and managing new and ongoing system tasks, updating Gov Delivery subscriptions, and generating monthly reports for HIP and CDC management (e.g., Complaints, Inspections & Overdue Inspections).

• Minimum two years of application testing experience.
• Essential skills in developing/writing queries in SQL.
• Experience analyzing data and building custom reports.
• Oracle database experience.
• Strong communication skills to relay information to non-technical staff.

Strong ability to develop and implement quality control plans and identify system improvements; ability to develop and generate custom reports for distribution; willingness to provide technical assistance and training as needed.