SQL Data Cleanup Specialist
3B Staffing LLC, Richmond, VA, United States
SQL Data Cleanup Specialist
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.
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.