👋 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.
🙌 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
🏆 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
Join our team as a specialized Data Engineer and play a pivotal role in migrating our clients from legacy systems to the Salesforce platform. You will own the end-to-end data migration lifecycle, from source system analysis and data mapping to building robust ETL pipelines. Your expertise will ensure the seamless, accurate, and scalable transfer of critical business data, directly contributing to our customers' success.
Responsibilities:
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 using the most appropriate tools for the job (e.g. sheets, Python scripting, data loader, APIs, etc.)
Conduct test migrations and validation processes to ensure stakeholder alignment
Perform data cleansing and transformation before loading into the target system
Collaborate with clients and internal stakeholders to understand source and target systems and data migration requirements
Continuously improve data migration processes for efficiency, scalability, and accuracy
Conduct data analysis to support business decisions and migration requirements
Qualifications:
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, data deduplication, etc.
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
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 [email protected] or visit our website at spectrumone.co.