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. ?
