SQL Data Cleanup Specialist

Job description:

Seeking a skilled Structured Query Language (SQL) Data Cleanup Specialist to assist with cleansing and standardizing data across a large-scale SQL Server database

Essential Duties and Responsibilities:

Assist with data cleanup related to the Data Quality Enhancement initiative and other development efforts as needed. Activities include:

·       Maintain the confidentiality of all business data and adhere to VRS data security policies.

·       Analyze and understand the structure and relationships within the database.

·       Write and execute SQL update and insert statements to clean and optimize data.

·       Utilize tools and techniques to automate and expedite the data cleansing process.

·       Collaborate with the data team to ensure data integrity and accuracy.

·       Document the data cleanup process and provide regular progress updates.

·       Special projects at the direction of the Chief Operating Officer or Data Officer.

 Required Skills and Experience:

·       Minimum 5 years of hands-on experience in SQL Server SQL development, including writing complex queries, data manipulation statements, stored procedures, and tuning.

·       Knowledge of indexing, query optimization, transaction handling for efficient data updates.

·       Ability to analyze large datasets and pinpoint anomalies or inconsistencies.

·       Familiarity with data cleansing tools and techniques.

·       Ability to work independently and manage time effectively.

·       Excellent problem-solving skills and attention to detail.

·       Strong communication skills to collaborate with the data team and other business units.

Desired Skills:

·       Experience in Pensions Benefit Management programs.

·       Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.).

·       Knowledge of programming languages such as Python.

·       Familiarity with ETL and automated data transformation techniques.

·       Other relevant certifications in SQL, Data Analysis and database management.

Education and Experience                                                                    

Bachelor’s degree from a four-year college or university preferred and 5+ years’ experience with database technology or data organizations required. 

 This will be a contract position starting with a period of 15 months.  To be effective, this resource would need to be available within the next 4 weeks.