SQL Data Cleanup Specialist - HYBRID
Richmond, VA
Contracted
Experienced
Job Title: SQL Data Cleanup Specialist (HYBRID)
Location: Richmond, VA
Duration: 12+ Months
Job Description:
The Client 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:
Required Skills and Experience:
Desired Skills:
Education and Experience:
Skills:
Location: Richmond, VA
Duration: 12+ Months
Job Description:
The Client 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 and 5+ years’ experience with database technology or data organizations required.
Skills:
| Skill | Required / Desired | Amount | of Experience |
| 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 | Required | 5 | Years |
| Experience in Pensions Benefit Management programs | Desired | ||
| Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.). | Desired | ||
| Knowledge of programming languages such as Python. | Nice to have | ||
| Familiarity with ETL and automated data transformation techniques | Desired | ||
| Other relevant certifications in SQL, Data Analysis and database management | Not Required |
Apply for this position
Required*