Software Engineer

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.