Job Description
Job Description
SQL Data Cleanup Specialist
Interview: Virtual & In-person
Work mode: Hybrid (Tuesday & Wednesday)
Duration: 12+ months
Job Description:
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.
- Analyze and understand the structure and relationships within the database.
- Write and execute SQL updates 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 in 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.