What are the responsibilities and job description for the VRS - SQL Data Cleanup Specialist position at i-Link Solutions?
Job Diva #: 25-00405
Job Title : VRS - SQL Data Cleanup Specialist
Job Location : 1200 East Main Street, Richmond, Virginia 23219
Position ID: 761239
Travel Required : No
Overtime Required : No
Position Type : Contract
Agency Interview Type: Both Web Cam and In Person Interview
Work Arrangement: Hybrid
Duration: 15 Months
Job 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.
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.
Skills Required / Desired Years of Exp Minimum 5 years of hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
Required 5 Knowledge of indexing, query optimization, transaction handling for efficient data updates Required 5 Ability to analyze large datasets and pinpoint anomalies or inconsistencies Required 5 Familiarity with data cleansing tools and techniques Required 5 Ability to work independently and manage time effectively Required 5 Excellent problem-solving skills and attention to detail Required 5 Strong communication skills to collaborate with the data team and other business units Required 5 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
Question 1
Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
Question 2
Please list candidate's email address.
Question 3
Does your candidate agree to and able to work and interview on site as required in the short Description.
Question 4
In what city and state is your candidate currently located.
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender
identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.
Job Title : VRS - SQL Data Cleanup Specialist
Job Location : 1200 East Main Street, Richmond, Virginia 23219
Position ID: 761239
Travel Required : No
Overtime Required : No
Position Type : Contract
Agency Interview Type: Both Web Cam and In Person Interview
Work Arrangement: Hybrid
Duration: 15 Months
Job 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.
- 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.
- 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.
- 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.
Skills Required / Desired Years of Exp Minimum 5 years of hands-on experience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuning
Required 5 Knowledge of indexing, query optimization, transaction handling for efficient data updates Required 5 Ability to analyze large datasets and pinpoint anomalies or inconsistencies Required 5 Familiarity with data cleansing tools and techniques Required 5 Ability to work independently and manage time effectively Required 5 Excellent problem-solving skills and attention to detail Required 5 Strong communication skills to collaborate with the data team and other business units Required 5 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
Question 1
Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
Question 2
Please list candidate's email address.
Question 3
Does your candidate agree to and able to work and interview on site as required in the short Description.
Question 4
In what city and state is your candidate currently located.
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender
identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.
