The Role
Job Title: SQL Data Cleanup Specialist (HYBRID)
Location: Richmond, VA
Duration: 12+ Months
Job Description:
The Client 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:
Required Skills and Experience:
Desired Skills:
Education and Experience:
Skills:
SkillRequired / DesiredAmountof ExperienceExperience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuningRequired5YearsKnowledge of indexing, query optimization, transaction handling for efficient data updatesRequired5YearsAbility to analyze large datasets and pinpoint anomalies or inconsistenciesRequired5YearsFamiliarity with data cleansing tools and techniquesRequired5YearsAbility to work independently and manage time effectivelyRequired5YearsExcellent problem-solving skills and attention to detailRequired5YearsStrong communication skills to collaborate with the data team and other business unitsRequired5YearsExperience in Pensions Benefit Management programsDesiredExperience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.).DesiredKnowledge of programming languages such as Python.Nice to haveFamiliarity with ETL and automated data transformation techniquesDesiredOther relevant certifications in SQL, Data Analysis and database managementNot Required
Location: Richmond, VA
Duration: 12+ Months
Job Description:
The Client 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 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.
Skills:
SkillRequired / DesiredAmountof ExperienceExperience in SQL Server development, writing complex queries, data manipulation statements, stored procedures and tuningRequired5YearsKnowledge of indexing, query optimization, transaction handling for efficient data updatesRequired5YearsAbility to analyze large datasets and pinpoint anomalies or inconsistenciesRequired5YearsFamiliarity with data cleansing tools and techniquesRequired5YearsAbility to work independently and manage time effectivelyRequired5YearsExcellent problem-solving skills and attention to detailRequired5YearsStrong communication skills to collaborate with the data team and other business unitsRequired5YearsExperience in Pensions Benefit Management programsDesiredExperience with data cleansing tools (SQL Server Data Quality Services, Trifacta, Talend, Alteryx, etc.).DesiredKnowledge of programming languages such as Python.Nice to haveFamiliarity with ETL and automated data transformation techniquesDesiredOther relevant certifications in SQL, Data Analysis and database managementNot Required
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Serigor provides IT Services and IT staffing to Government and Commercial enterprises of all sizes. Serigor has twelve years of proven track record in IT Services, Government Solutions, and Staffing Solutions.
● MBE/WBE/WBENC/WOSB company, headquartered in Baltimore, MD.
● Multiple, multi-year contracts with Government Agencies at State, County, City, and Federal.
● Commercial clients include Fortune 1000 and Start-Ups all over the US.
● Onshore and offshore IT delivery centers.
● IT solutions encompass contracts that are Fixed Price, T&M, Product Development in all technologies.
● Workforce and staffing solutions encompass contract, contract-to-hire, permanent placement and statement of work job assignments.
