SQL Data Cleanup Specialist

SQL Data Cleanup Specialist,Richmond, VA,United States

SQL Data Cleanup Specialist

The Virginia Retirement System (VRS) Data Office team is 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.
• 5+ years’ experience with database technology or data organizations required.
  
  

Skill Matrix

• Minimum 5 years of hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
• Required 5 Years Knowledge of indexing, query optimization, transaction handling for efficient data updates
• Required 5 Years Ability to analyze large datasets and pinpoint anomalies or inconsistencies
• Required 5 Years Familiarity with data cleansing tools and techniques
• Required 5 Years Ability to work independently and manage time effectively
• Required 5 Years Excellent problem-solving skills and attention to detail
• Required 5 Years Strong communication skills to collaborate with the data team and other business units
• Desired Experience in Pensions Benefit Management programs
• Desired Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.).
• Nice to have Knowledge of programming languages such as Python.
• Desired Familiarity with ETL and automated data transformation techniques
• Not Required Other relevant certifications in SQL, Data Analysis and database management