At BuildOps, we’re revolutionizing the commercial contracting industry with our cutting-edge software solution. From service management to project coordination, we’re committed to breaking barriers and fostering a team that aligns with our mission. If you’re a motivated individual who thrives in a fast-paced environment, you could be our next valuable addition!
We are looking for an experienced Senior Data Onboarding Engineer to join our team and lead complex data migration projects, ensuring the smooth transfer of large volumes of data from multiple source systems to a variety of target environments (e.g., MySQL, PostgreSQL, SQL Server, etc.). In this role, you will be responsible for designing, implementing, and optimizing ETL pipelines, as well as ensuring data quality and consistency in highly transactional OLTP systems. You will work closely with both technical and business teams to ensure seamless integration, performance, and data integrity throughout the migration process.
What You'll Do
- Design, develop, automate, and optimize ETL pipelines to migrate data from various unknown or legacy source systems to target systems like MySQL, PostgreSQL, or SQL Server using tools such as FlatFile, GraphQL mutations, and REST API endpoints
- Define and implement data migration strategies to ensure large volumes of data are migrated with minimal disruption to business operations, including incremental load processes, full data loads, and error-handling strategies
- Identify and resolve performance bottlenecks within ETL pipelines by leveraging query optimization, indexing, parallel processing, and partitioning
- Implement and maintain data validation, cleansing, and reconciliation processes to ensure the integrity, accuracy, and consistency of migrated data
- Monitor and troubleshoot ETL pipelines during migration, providing root cause analysis and implementing corrective actions
- Collaborate with product managers, software engineers, implementation, and customer success managers to gather requirements and deliver scalable data solutions
- Document the full data migration process including pipeline configurations, transformations, data mappings, and known limitations; provide support and training to internal teams
- Continuously assess and improve ETL workflows by staying current on tools and technologies and applying best practices
What We Look For
- 5–7 years of experience in data migration, ETL development, or data integration roles
- Hands-on experience with ETL tools such as FlatFile, Talend, Fivetran, or similar platforms
- Experience with cloud-based ETL services such as AWS Glue, Azure Data Factory, or Google Cloud Data Fusion
- Strong experience with relational databases (MySQL, PostgreSQL, SQL Server); familiarity with NoSQL databases like MongoDB is a plus
- Proficiency in SQL and Python
- Solid understanding of data quality principles including profiling, validation, de-duplication, and reconciliation
- Experience integrating data from multiple complex sources such as flat files, APIs, and legacy systems
- Familiarity with OLTP systems, transaction processing, and maintaining data consistency and integrity
- Strong analytical and troubleshooting skills, with the ability to quickly identify and resolve issues
- Excellent communication skills and the ability to work effectively across technical and business teams
- Ability to work a hybrid schedule - Monday/Friday WFH, Tuesday - Thursday, in office
Nice To Have
- Experience working in SaaS companies or cloud-based environments
- Familiarity with multi-tenant architectures, scaling data systems, and migrating customer data in a SaaS context
- Experience with cloud platforms like AWS (Redshift, S3), Azure, or Google Cloud
- Familiarity with automation tools and techniques for ETL pipeline orchestration
- Certifications such as AWS Certified Solutions Architect, Informatica PowerCenter Developer, or Certified Data Management Professional (CDMP)
What We Offer
- Negotiable base salary + annual bonus
- Generous equity grant, become an owner in our company!
- A comprehensive benefits package
- Flexible paid time off
- Work from home stipend
- MacBook computer provided
- Hubs in Los Angeles, Toronto, and Raleigh with hybrid work schedules and daily lunch stipends for in-office days
- Company events like BBQs and team-building activities, both in-person and virtual
- Talented and motivated team members who care deeply about one another (seriously, everyone is rooting for your success!)
- Growth Opportunity: Be part of a company transforming an industry and accelerating at an extraordinary pace
About BuildOps
Join BuildOps, the largest commercial trade platform in the country, as we transform the multi-billion dollar commercial contracting industry!
We’re not just talking incremental improvements—we’re talking a full-scale revolution, empowering the hardworking heroes who build and maintain the infrastructure that keeps our world running. See why contractors choose Buildops here.
This is your chance to be part of a rocketship. We’re fresh off a $1 billion valuation and a $127M Series C funding round (part of over $275M raised to date) led by industry-leading investors like Meritech Capital, BOND, and SE Ventures, backed by Schneider Electric (Reuters, TechCrunch, LA Business Journal) . Our latest investors join our team of industry heavyweights like Next47, former Twitter CEO Dick Costolo, former Salesforce President Gavin Patterson, and Boost Mobile CEO Stephen Stokols. Their investment is fueling our aggressive growth and our commitment to equipping contractors with AI-driven tools to conquer chaos, boost efficiency, skyrocket profitability, and ultimately, deliver exceptional service.
At BuildOps, we’re changing the game and doing the best work of our careers. You’ll be a key player in a company that’s truly making a difference for the backbone of our economy. If you’re ready to tackle big challenges, work with a passionate team, and build something extraordinary, BuildOps is the place for you. 🚀
