SQL Data Cleanup Specialist
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Datasoft Technologies, Inc., is seeking the following. Apply via Dice today!
SQL Data Cleanup Specialist
Hybrid
About The Job
• Duration: 12 Months Contract (possibility of extension)
• Location: - Hybrid: Richmond, VA
• Pay rate: Hourly, depending on experience
• Job ID: 761239
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.
Qualifications:
• 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
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.
About our Company
DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:
• Paid Holidays/Paid Time Off (PTO)
• Medical/Dental Insurance
• Vision Insurance
• Short Term/Long Term Disability
• Life Insurance
• 401 (K)
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Datasoft Technologies, Inc., is seeking the following. Apply via Dice today!
SQL Data Cleanup Specialist
Hybrid
About The Job
• Duration: 12 Months Contract (possibility of extension)
• Location: - Hybrid: Richmond, VA
• Pay rate: Hourly, depending on experience
• Job ID: 761239
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.
Qualifications:
• 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
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.
About our Company
DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:
• Paid Holidays/Paid Time Off (PTO)
• Medical/Dental Insurance
• Vision Insurance
• Short Term/Long Term Disability
• Life Insurance
• 401 (K)
