Data Engineer (Data Migration Focus) (Remote)

Spectrum One Is Hiring

👋 Hello! We’re Spectrum One. We’re on a mission to continuously support our team’s growth—not just technically, but also in how we communicate with clients around the world. With your help, we aim to enhance the communication skills of our team members so they can confidently represent us in every interaction.

Since 2015, our support has helped clients raise $150 million in funding, and our services are now available in various parts of the world. None of this would have been possible without the dedication of our team—and now we want to invest further in helping them become the best communicators they can be.

Highlights

🙌 8 years in the software development industry

📈 Profitable; net revenue growth of 200% in 2021

💰 Over $150M raised in funding by our clients

🌐 Work anywhere in the world with our permanent work-from-home setup

Why Join Spectrum One?

🏆 As a shapeshifter in Spectrum One, you’ll get the opportunity to really help grow the direction of the company. We don’t micro-manage. We love hustlers who take ownership of their roles. But you’ll definitely get guidance and plenty of support from each other on the team. You’ll be in an environment where learning is always encouraged to empower you to do your best.

✅ Competitive hourly rate (flexible based on experience)

✅ Flexible, ad hoc engagement

✅ Permanent work-from-home setup

✅ Friendly and collaborative team culture

✅ Opportunity to make a direct impact on client-facing success

About The Role

We are seeking a Data Engineer with expertise in data migration (extract, transform, load) to support our customers’ transition from legacy platforms to Salesforce. This role will be critical in designing, implementing, and validating data pipelines while ensuring accuracy, consistency, and scalability. The ideal candidate is highly technical, detail-oriented, and able to collaborate across teams to deliver reliable migration outcomes.

Responsibilities:

• Design and implement data pipelines to migrate data from legacy systems into Salesforce
• Partner with developers to identify and document system mappings (old legacy system → new legacy system in Salesforce)
• Perform field mapping, transformation logic, and prepare technical documentation (spreadsheets, mapping templates)
• Extract, transform, and load (ETL) data via APIs and other integration tools
• Conduct test migrations and develop validation strategies to ensure data integrity
• Perform data cleansing, enrichment, and optimization before loading into the target system
• Collaborate with clients and internal stakeholders to analyze data requirements, evaluate additional fields, and coordinate with devs for object/field mapping
• Continuously improve ETL processes for performance, scalability, and error handling
• Conduct data analysis to support business decisions and migration requirements
• Strong foundation in data modeling principles
• Proficiency in Python (must have), with experience using Pandas for data wrangling (nice to have)
• Advanced spreadsheet expertise: VLOOKUP, pivot tables, COUNT A, IFERROR formulas, data deduplication, and data formatting
• Experience with ETL tools and processes (designing, optimizing, error handling)
• Familiarity with Salesforce data structures and Data Loader 
• Knowledge of SQL for data querying and validation 

Qualifications:

• Experience working with cloud environments (AWS, Google Cloud) 
• Previous involvement in data migration projects is a strong plus
• Excellent communication skills and ability to collaborate with both technical and non-technical stakeholders

Got some questions? Please email us at careers@spectrumone.co or visit our website at spectrumone.co.