MS SQL Server XML Advanced Written Communication Skills Interpersonal Skills Data Q   Requirement id 136912 Job title Analyst Job location in Richmond, VA Skills required T-SQL Query, Data Management, MS SQL Server, XML Advanced Written Communication Skill Open Date 12-Oct-2022 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: T-SQL Query, Data Management, MS SQL Server, XML Advanced Written Communication Skill Start date : 10/24/2022 End Date : 01/02/2023 Submission deadline : 10/17/2022 Client Info : VDH Note: * local candidates strongly preferred * Mostly remote work is available now but needs to be able to come onsite when requested, NO exceptionsv 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 VDH 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.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 136912 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14),         (Analyst: T-SQL Query, Data Management, MS SQL Server, XML Advanced Written Communication Skill in Richmond, VA)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)