Senior Backend Engineer (Data Migrations, Python)

Position Overview

At BuildOps, we’re revolutionizing the commercial contracting industry with our advanced software solution. We are seeking a Senior Backend Engineer to lead complex data migration projects, designing, implementing, and optimizing ETL pipelines to ensure the smooth and secure transfer of large data volumes across various databases (e.g., MySQL, PostgreSQL, SQL Server). You will collaborate with technical and business teams to integrate, enhance performance, and maintain data integrity in highly transactional systems.

Key Responsibilities

• Design and maintain ETL pipelines to migrate data from legacy and varied source systems to target databases like MySQL, PostgreSQL, or SQL Server.
• Develop and manage Python libraries for transforming batch files into CRUD API requests for the application layer.
• Identify and resolve performance bottlenecks within ETL processes using query optimization, indexing, parallel processing, and partitioning techniques.
• Implement scalable data validation, cleansing, and reconciliation processes to ensure the integrity of the ETL workflows.
• Collaborate with product managers, software engineers, implementation teams, and customer success managers to scale and improve offerings.
• Document pipeline configurations, transformations, and data mappings, providing necessary training and support to internal teams.
• Continuously assess and enhance ETL workflows by adopting best practices and staying updated on the latest tools and technologies.

Required Qualifications

• 5+ years of experience developing backend solutions using 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 integrate data into application databases.
• Proven experience with cloud-based applications in AWS.
• Excellent communication skills and a collaborative mindset to work across technical and business teams.
• Ability to work a hybrid schedule with remote work on Monday/Friday and in-office presence from Tuesday to Thursday in Raleigh.

Preferred Qualifications

• Experience in SaaS companies or cloud-based environments.
• Familiarity with multi-tenant architectures and scaling data systems for customer data migration in a SaaS context.
• Knowledge of automation tools and techniques for ETL pipeline orchestration.
• Experience using AI for code generation and troubleshooting.

Benefits & Perks

• Compensation: Negotiable base salary + annual bonus
• Generous equity grant – become an owner in our company!
• Macbook computer provided
• A comprehensive benefits package
• Flexible PTO and hybrid work schedules
• Work from home stipend
• Hybrid work hubs in Los Angeles, Toronto, and Raleigh with in-office lunch provided
• 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
• Be part of a groundbreaking revolution in the commercial contracting industry