SQL Data Cleanup Specialist - (no C2C or Sponsorship)

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an SQL Data Cleanup Specialist on a 15-month contract, offering $50.00 - $55.00 per hour. Requires 5+ years of SQL Server development, data cleansing experience, and familiarity with Pensions Benefit Management. Hybrid work in Richmond, Virginia.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
440
🗓️ - Date discovered
April 23, 2025
🕒 - Project duration
More than 6 months
🏝️ - Location type
Hybrid
📄 - Contract type
Corp-to-Corp (C2C)
🔒 - Security clearance
Unknown
📍 - Location detailed
Richmond, VA 23219
🧠 - Skills detailed
#SQL (Structured Query Language) #"ETL (Extract #Transform #Load)" #Programming #Indexing #SQL Server #Database Management #Datasets #Security #Data Integrity #Data Manipulation #Data Security #Alteryx #Python #Talend #Data Quality #Complex Queries #Data Cleansing #Data Analysis
Role description

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.

This will be a contract position starting with a period of 15 months. To be effective, this resource would need to be available within the next 4 weeks.

The individual will follow the VRS Hybrid work schedule including 2 days onsite per week (Tuesday and Wednesday). The individual may also be called to be onsite for critical meetings and data related discussions. Onsite work will be at the VRS central office at 1200 East Main Street, Richmond, Virginia 23219.

Job Type: Contract

Pay: $50.00 - $55.00 per hour

Benefits:

401(k)

 Dental insurance

 Health insurance

 Paid time off

 Vision insurance

Schedule:

8 hour shift

 Monday to Friday

Education:

Bachelor's (Required)

Experience:

SQL Server development: 5 years (Required)

 indexing, query optimization, transaction handling: 5 years (Required)

 analyzing large datasets & pinpoint anomalies: 5 years (Required)

 data cleansing tools and techniques: 5 years (Required)

 in Pensions Benefit Management programs: 1 year (Required)

 with ETL and automated data transformation techniques: 1 year (Required)

Work Location: Hybrid remote in Richmond, Virginia 23219