Convert a range of 3 digit US zip codes

We are seeking a freelancer to assist us in converting a range of 3-digit US zip codes into their corresponding 5-digit zip codes. This project involves approximately 20 sales territories that are currently assigned using a 3-digit zip code system. Our goal is to convert these 3-digit zip codes to their full 5-digit counterparts and associate them with the respective territory names and numbers.

The successful freelancer will have a strong understanding of US zip code geography and the ability to efficiently convert large volumes of data. They will work closely with our team to ensure that the conversion process is accurate and timely.

Key responsibilities:

1. Identify and extract the 3-digit zip codes from our existing data sources.
2. Use appropriate software and algorithms to convert each 3-digit zip code into its corresponding 5-digit zip code.
3. Associate the converted 5-digit zip codes with the corresponding territory names and numbers.
4. Clean and validate the resulting data to ensure accuracy.
5. Provide us with a report detailing the conversion process and the final dataset.

Requirements:

1. Strong knowledge of US zip code geography and the zip code conversion process.
2. Experience with data manipulation and cleaning.
3. Ability to work independently and meet deadlines.
4. Excellent attention to detail and accuracy.
5. Familiarity with software such as Excel and SQL.

If you are a skilled freelancer with the required expertise and experience, we would love to hear from you. Please submit your proposal, including your rate and estimated timeline for completion, to [insert contact information].