What are the responsibilities and job description for the SQL Data Cleanup Specialist position at Info Origin Inc.?
Job Details
Essential Duties and Responsibilities:
Assist with data cleanup related to Data Quality Enhancement initiatives and other development efforts as needed. Activities include:
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 senior leadership.
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 performance tuning.
Knowledge of indexing, query optimization, and transaction handling for efficient data updates.
Ability to analyze large datasets and identify 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 for collaboration across teams.
Desired Skills:
Experience in Pension Benefit Management programs.
Experience with data cleansing tools such as SQL Server Data Quality Services, Trifacta, Talend, or Alteryx.
Knowledge of programming languages such as Python.
Familiarity with ETL and automated data transformation techniques.
Relevant certifications in SQL, Data Analysis, or Database Management.
Education and Experience:
Bachelor s degree from a four-year college or university preferred, with 5 years of experience in database technology or data-focused roles required.
