drjobs SQL Data Cleanup Specialist HYBRID

SQL Data Cleanup Specialist HYBRID

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Richmond - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

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 largescale 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 handson 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 problemsolving 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:
  • Bachelors degree from a fouryear 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 tuning5YearsKnowledge of indexing query optimization transaction handling for efficient data updates5YearsAbility to analyze large datasets and pinpoint anomalies or inconsistencies5YearsFamiliarity with data cleansing tools and techniques5YearsAbility to work independently and manage time effectively5YearsExcellent problemsolving skills and attention to detail5YearsStrong communication skills to collaborate with the data team and other business units5YearsExperience 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

Required Experience:

Senior IC

Employment Type

Contract

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.