Data Migration Engineer
We are seeking a detail-oriented and highly skilled Data Migration Engineer to join our engineering team. In this role, you will be responsible for designing and executing reliable, scalable data migration solutions across systems and databases. You’ll work closely with product, infrastructure, and engineering teams to ensure successful ETL processes and data integrity during large-scale migrations.
- Design, implement, and manage data migration pipelines for relational databases, particularly MySQL and PostgreSQL.
- Collaborate with stakeholders to understand data requirements and translate them into structured ETL processes.
- Perform complex data mapping, transformation, and validation tasks with precision and attention to detail.
- Develop and maintain Kotlin-based tools and scripts using Gradle for dependency management and build automation.
- Utilize AWS infrastructure (e.g., S3, RDS, Lambda, ECS, etc.) to support scalable and secure data operations.
- Ensure data quality, consistency, and compliance throughout the migration lifecycle.
- Monitor and troubleshoot migration processes, optimizing for performance and reliability.
- Work in a modern development environment using VSCode or IntelliJ.
- Conduct code reviews and provide constructive feedback to ensure code quality and consistency.
- Work with a fast-paced agile team through pull requests, scrum ceremonies, and feature documentation.
- Must be a United States Citizen
- 3+ years of professional experience in data migration, ETL engineering, or related data-focused roles.
- Strong expertise with relational databases, with hands-on experience in MySQL and PostgreSQL.
- Proficiency in Kotlin and experience with Gradle build systems.
- Experience working in modern IDEs such as VSCode or IntelliJ.
- Deep understanding of ETL processes, data modeling, and mapping best practices.
- Proven ability to work with AWS cloud infrastructure, including but not limited to S3, RDS, ECS, and Lambda.
- Excellent problem-solving, communication, and documentation skills.
- Ability to work independently and collaboratively in a fast-paced Agile environment
- Strong communication and interpersonal skills, with the ability to effectively interact with team members at all levels.
Preferred Qualifications
- Familiarity with database migration tools or platforms (e.g., Flyway, Liquibase, AWS DMS).
- Experience with CI/CD pipelines and infrastructure as code.
- Background in handling sensitive data with attention to privacy and compliance standards
What we offer
- Pay $65-$75/hour
- Competitive salary and benefits
- Flexible work hours and remote-friendly culture
- A casual, friendly, and relaxed work environment
- Professional growth encouragement and support
Industrial Security Integrators, LLC (“IsI”) is an equal opportunity employer committed to affirmative action and diversity in the workplace. It is the policy of IsI to provide Equal Employment Opportunities (EEO) to Employees and Applicants, without regard to race, color, religion, sex, age, marital status, citizenship status, national origin, sexual orientation, gender identity, veteran status or disability or any other factor protected by law and to provide advancement opportunities for minorities, women, disabled individuals, and veterans. IsI is stronger and more effective when our workforce includes highly qualified individuals with diverse backgrounds, cultures, and traditions.