*local candidates strongly preferred*remote work is available now but needs to be able to come onsite when requested, NO exceptions

Job Description:

• Explore and understand the data structure and contents in the data repositories
• Assist in the review of data quality, troubleshooting, and data cleanup process
• Manage and maintain large volumes of data using manual and automated techniques for investigation and resolution of data quality issues.
• Assist in gathering and documenting data needs and migration requirements for use in the migration tool design, as well as other reporting measures.
• Develop, automate, and maintain data management and data improvement processes using MS SQL SSMS, MS SQL Server Jobs, SSIS, and Tableau.
• Utilize SQL server environment for all SQL development activities including data extraction, data quality, transformation and formatting, testing, modification and validation.
• Participate in the development of effective solutions and enhancements to increase efficiency of system operations, availability and reporting of high quality data.
• Routinely review SQL scripts and processes to optimize performance.
• Develop QA and performance dashboards measuring data quality dimensions including integrity, validity, accuracy, consistency, and completeness using Tableau
• or similar software.
• Extensive experience implementing relevant, trend-based data quality measurements and assessing scope, frequency and severity of data anomalies using advanced SQL scripts within MS SQL Server Management Studio
• Maintain documentation of processes, procedures and manuals
• Assist in managing and maintaining the confidentiality and security of the data at all times
• Assist in responding to data requests, data analysis using SQL and automation/ generation of ad-hoc reports
• Provide assistance in various data management activities as assigned
• Collaborates with peers to ensure formatted data received meets reporting and system requirements within the Office of Epidemiology (OEPI).
• May write reports or facilitate data access by other means as needed, to include SSIS, SSRS, Tableau, etc.
• Participates in internal and external meetings.

.Please submit your resume in word format.

Job Type: Contract

Pay: $40.00 - $45.00 per hour

Schedule:

• 8 hour shift

Application Question(s):

• Bachelor’s degree in IT, Computer Science, and/orequivalent experience and training

Experience:

• development, change management and testing.: 3 years (Required)
• advanced SQL query &SSIS development within SQL server: 5 years (Required)
• database structure &design in the MS SQL server: 5 years (Required)
• data quality management, data structure and contents: 5 years (Required)
• XML: 3 years (Required)
• Knowledge of public health disease surveillance and data;: 2 years (Required)
• reportable disease/health-related info systems&management: 2 years (Required)
• Maintain documentation of processes, procedures and manuals.: 5 years (Required)
• R or SAS: 3 years (Required)
• Health Level (HL7) messaging standards: 2 years (Required)
• T- SQL in data management,analysis&reporting in MS SQL: 5 years (Required)

Work Location: Hybrid remote in Richmond, VA 23219