JOB TITLE: Software Engineer
FLSA STATUS: Exempt
DEPARTMENT: ERP
REPORTS TO: Software Engineering Manager
SUPERVISORY RESPONSIBILITIES: No
JOB LOCATION: Richmond, KY
TRAVEL: 10%
ESSENTIAL DUTIES & RESPONSIBILITIES:- Collaborate with cross-functional teams to understand business requirements and data structures within legacy systems.
- Design, develop, and implement data migration processes, including Extraction, Transformation, and Importing data.
- Write efficient and optimized SQL scripts for data migration and integration tasks.
- Conduct detailed data mapping and validation to ensure data accuracy and consistency during migration.
- Develop and maintain documentation of data migration processes, including schemas, mappings, and workflows.
- Perform thorough testing of migrated data to identify and resolve discrepancies or issues.
- Support troubleshooting efforts and provide technical assistance during and after the data migration process.
- Optimize performance of the SQL database to ensure scalability and reliability.
- Stay updated with emerging data migration and database management technologies.
MINIMUM QUALIFICATIONS (EDUCATION AND EXPERIENCE):- Proficiency in SQL and database management systems (e.g., SQL Server, MySQL).
- Strong understanding of legacy system architectures and data models.
- Proven ability to write and optimize SQL queries and scripts.
- Attention to detail, with a focus on data integrity and accuracy.
- Excellent problem-solving and analytical skills.
- Familiarity with programming languages (C ) for scripting and automation is a plus.
- Effective communication and collaboration skills.
PREFERRED QUALIFICATIONS (EDUCATION AND EXPERIENCE):- Experience with database migration tools and frameworks.
- Knowledge of data governance, security, and compliance best practices.