SQL Server/ETL developer - Hybrid

Title: SQL Server/ETL developer - Hybrid

Location: Richmond, VA, United States

Length: Long term

Restriction: W2 or C2C

Description:

** **Long term*** Hybrid***

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)

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.

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.

Required Skills:

Minimum 5 years of 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 5 Years

Other relevant certifications in SQL, Data Analysis and database management Years

Experience in Pensions Benefit Management programs preferred

Experience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.). Years preferred

Familiarity with ETL and automated data transformation techniques Years

Knowledge of programming languages such as Python. Years