Senior Backend Engineer (Data Migrations, Python)

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 a Senior Backend 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 and maintain ETL pipelines to migrate data from various unknown or legacy source systems to target systems like MySQL, PostgreSQL, or SQL Server
• Own libraries of Python importers transforming batch files to CRUD API requests into the application layer
• Identify and resolve performance bottlenecks within ETL pipelines by leveraging query optimization, indexing, parallel processing, and partitioning
• Implement and maintain scalable data validation, cleansing, and reconciliation processes to ensure the integrity of the ETL pipelines
• Collaborate with product managers, software engineers, implementation, and customer success managers to grow offerings to scale for the future
• 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+ years of proficient experience developing backend solutions with Python and SQL
• Strong understanding of relational databases (MySQL, PostgreSQL, SQL Server); familiarity with NoSQL databases like MongoDB is a plus
• Experience implementing GraphQL mutations and/or REST APIs to process data into application databases
• Experience with cloud-based applications in AWS
• 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
• Familiarity with automation tools and techniques for ETL pipeline orchestration
• Experience using AI to generate code and troubleshoot issues

What We Offer:

• Negotiable base salary + annual bonus
• Generous equity grant, become an owner in our company!
• A comprehensive benefits package
• Flexible PTO and hybrid work schedules
• Work from home stipend
• 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
• Fast-paced, collaborative, and dynamic work environment
• Opportunities for growth and career advancement
• Chance to work with cutting-edge technology and innovative solutions
• The chance to get in on the ground floor and build something truly groundbreaking for ourselves and our amazing customers