VRS - SQL Data Cleanup Specialist
Apply NowCompany: HCL Global Systems, Inc.
Location: Richmond, VA 23223
Description:
VRS Data Office team is seeking a skilled SQL Data Cleanup Specialist to assist with cleansing and standardizing data across a large-scale SQL Server database.
VRS Hybrid 2 days onsite per week (Tuesday and Wednesday)
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.
nalyze 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.
bility to analyze large datasets and pinpoint anomalies or inconsistencies.
Familiarity with data cleansing tools and techniques.
bility 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.
VRS Hybrid 2 days onsite per week (Tuesday and Wednesday)
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.
nalyze 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.
bility to analyze large datasets and pinpoint anomalies or inconsistencies.
Familiarity with data cleansing tools and techniques.
bility 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.