SQL Data Cleanup Specialist
DataStaff, Inc. is seeking a SQL Data Cleanup Specialist for a long-term contract opportunity with one of our direct clients in Richmond, VA.
• This position is hybrid; 2 days/week will be onsite.
Responsibilities:
• Assist with cleansing and standardizing data across a large-scale SQL Server database
• Assist with data cleanup related to the Data Quality Enhancement initiative and other development efforts as needed.
• Maintain the confidentiality of all business data and adhere to 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.
Education:
Bachelor’s degree from a four-year college or university preferred and 5+ years’ experience with database technology or data organizations required.
Required Skills:
• 5 Years - Hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
• 5 Years - Knowledge of indexing, query optimization, transaction handling for efficient data updates
• 5 Years - Ability to analyze large datasets and pinpoint anomalies or inconsistencies
• 5 Years - Familiarity with data cleansing tools and techniques
• 5 Years - Ability to work independently and manage time effectively
• 5 Years - Excellent problem-solving skills and attention to detail
• 5 Years - 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
This position is available on a corp-to-corp basis or as a W2 position with a competitive benefits package. DataStaff, Inc. offers medical, dental and vision coverage options as well as paid vacation, sick and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.
DataStaff, Inc. is seeking a SQL Data Cleanup Specialist for a long-term contract opportunity with one of our direct clients in Richmond, VA.
• This position is hybrid; 2 days/week will be onsite.
Responsibilities:
• Assist with cleansing and standardizing data across a large-scale SQL Server database
• Assist with data cleanup related to the Data Quality Enhancement initiative and other development efforts as needed.
• Maintain the confidentiality of all business data and adhere to 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.
Education:
Bachelor’s degree from a four-year college or university preferred and 5+ years’ experience with database technology or data organizations required.
Required Skills:
• 5 Years - Hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
• 5 Years - Knowledge of indexing, query optimization, transaction handling for efficient data updates
• 5 Years - Ability to analyze large datasets and pinpoint anomalies or inconsistencies
• 5 Years - Familiarity with data cleansing tools and techniques
• 5 Years - Ability to work independently and manage time effectively
• 5 Years - Excellent problem-solving skills and attention to detail
• 5 Years - 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
This position is available on a corp-to-corp basis or as a W2 position with a competitive benefits package. DataStaff, Inc. offers medical, dental and vision coverage options as well as paid vacation, sick and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.
