Data Conversion Lead

End-to-end hands-on experience with large scale data migrations / ETL processes from legacy to modern systems, including design, data mapping, development, validation, and implementation.

Working with complex IT software projects in a large organization using Waterfall and Agile methodologies. Strong technical background of database management, development, and migration including SQL server, SSIS, SQL, Stored Procedures.

Experience with Excel, as well as ETL tools and techniques. Attention to detail, proficiency in both written and verbal communications.

Experience with the following is desired: Mainframe applications development and support, including Integrated Database Management System (IDMS) databases, and COBOL including batch and online development.

Ownership and management of data conversion and migration tasks for several source applications being consolidated to a singular target system, working in close coordination with various County and vendor subject matter experts and technical teams.

Leads design and planning activities, working with various stakeholders to gather and document requirements, and create and document an overall data migration strategy to extract and prepare County data to be imported to the vendor system.

Investigates the functionality and data structures of source systems in order to successfully identify needed data mapping tasks requirements.

Ensure data quality throughout the data migration process through design and implementation of data cleansing and standardization strategies.

Leading the implementation and execution of data migration processes throughout the project to support development, testing, and production deployment phases.

Lead data conversion testing and validation activities and acceptance, working with both business customers and technical teams to identify and resolve issues.

Working closely with the project management team to communicate progress, issues, and risks to the customer.