SQL Data Cleanup Specialist

Job Title: SQL Data Cleanup Specialist
📍 Location: Richmond, VA
🕒 Term: 1 Year
💼 Work Arrangement: Hybrid (2 days onsite per week – Tuesday and Wednesday)
📧 Send Resumes to: greathireteam2@gmail.com

🔍 Job Description:
We are looking for a SQL Data Cleanup Specialist to assist with cleansing and standardizing data across a large-scale SQL Server database. The ideal candidate will have hands-on experience with SQL Server SQL development, data manipulation, and data optimization techniques. This role involves collaborating with the data team and utilizing tools and techniques to automate and expedite the data cleansing process.

📋 Essential Duties and Responsibilities:
Maintain the confidentiality of all business data and adhere to 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.
Handle special projects as directed by 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.
Strong knowledge of indexing, query optimization, and 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 Python programming language.
Familiarity with ETL and automated data transformation techniques.
Relevant certifications in SQL, Data Analysis, and database management.

🎓 Education and Experience:
Bachelor’s degree from a four-year college or university preferred.
5+ years of experience in SQL and data analysis.

📌 Apply Here: https://forms.gle/1YFVKJhTCuXZ8y7m6
📧 Send Resume To: greathireteam2@gmail.com