Description

You will manage and maintain large volumes of data within an MS SQL Server environment, focusing on data quality, extraction, and reporting.

Responsibilities

• Develop, automate, and maintain data management processes using MS SQL SSMS, SQL Server Jobs, SSIS, and Tableau.
• Execute SQL development activities including data extraction, transformation, formatting, testing, and validation.
• Investigate and resolve data quality issues using manual and automated techniques to ensure integrity, validity, and accuracy.
• Optimize SQL scripts and processes to increase system operation efficiency and performance.
• Develop QA and performance dashboards to measure data quality dimensions and maintain process documentation.

Required Skills

• 5+ years of experience with T-SQL query language for data management, analysis, and reporting.
• 5+ years of experience with MS SQL Server, including database structure and design.
• 5+ years of experience in data quality management and procedures.
• 5+ years of experience with advanced SQL query development and SSIS development.
• 3+ years of experience in software development, change management, and testing.
• Proficiency with MS SQL SSMS and SQL Server Jobs.
• Experience with Tableau for data visualization and dashboarding.

Preferred Skills

• Experience with XML, R, SAS, or SSRS.
• Knowledge of HL7 messaging standards or public health disease surveillance data.

Key Skills

Education

Bachelor's degree