Data Migration Specialist

Role: Data Migration Technician

Location: Chicago, IL (Hybrid)

Role Overview: 

We are seeking a skilled Data Migration Technician to join our Client Success Team. This role is key in ensuring the smooth, accurate, and timely transfer of customer data. From a variety of source systems, you will be responsible for executing client migrations using internally developed tooling, preparing and validating customer data for accuracy before migration and importing customer data into the Smokeball target system.

Key Responsibilities

• Execute end-to-end data migrations, including cleansing, transformation, validation, and loading.
• Assist with data extraction from source systems when required.
• Prepare and validate customer data for accuracy before migration.
• Conduct data exploration to analyze datasets from various sources and understand their characteristics and relationships.
• Generate reports and summaries for trial and live migrations.
• Meet deadlines and proactively communicate any potential delays or challenges.
• Identify and suggest improvements to migration tools and processes.
• Collaborate with the Migration Specialist and stakeholders to understand data requirements and ensure data integrity.

What we’re looking for:  

• You're a data handling and manipulation pro, with a knack for software scripting and familiarity with JavaScript and JSON to top it off.
• You have strong attention to detail, excellent analytical and problem-solving skills, and the ability to manage multiple projects with varying timelines and priorities.
• You’ve got experience manipulating CSV/Excel data, using command line tools and have some general SQL/Database knowledge (ability to run some basic queries)
• Bonus points if you have experience with the ETL process - extracting, transforming, and loading data, plus migrating data from CSVs and SQL databases. 
• Bonus points if you've got a legal background (not required)