Senior Backend Engineer

It's fun to work in a company where people truly BELIEVE in what they're doing! Fullsteam is a leading provider of vertical software and embedded payments technology dedicated to helping businesses flourish by providing their customers with seamless experiences. With a dynamic and growing team of over 1,900 employees, we are committed to driving innovation and delivering best-in-class software and payment solutions that empower small and medium-sized businesses across numerous industries.

Our purpose is to help our customers grow their businesses and delight their customers. Join us and be a part of a forward-thinking company that values growth, excellence, and the success of our clients.

Commerce7, part of the Fullsteam organization, is a customer-centric commerce platform in the alcohol industry. Today we are the platform that powers over 3,500 leading alcohol brands including Opus One, Caymus, Harlan Estate, William Chris Winery and more. We believe that above price and product, the number one reason why a consumer chooses a brand is customer experience. Customer experiences that are customer-centric lead to loyalty, customer happiness, and ultimately drive sales and profit.

Our mission at Commerce7 is to empower wineries with the tools and insights needed to deliver exceptional customer experiences and succeed in DTC.

We are seeking a Senior Backend Engineer with a strong background in software engineering and data to help design, build, and optimize the data systems that power our products and business insights, who is passionate about data architecture, reporting, and building scalable backend systems. The ideal candidate is results-driven, detail-oriented, and committed to continuous improvement. If you thrive in a collaborative environment that values openness, innovation, and high standards, we’d love to hear from you.

• Data & Reporting Ownership:
  Take ownership of a multi-tenant reporting architecture (currently 16 pools with individual tenant databases, over 3,000 tenants), ensuring stability, accuracy, and high performance for millions of processed records.
• Migration Strategy:
  Architect and execute the long-term migration of legacy reporting systems (MSSQL/SSRS) into our modern core infrastructure (NodeJS/Aurora MySQL/AWS) with the potential to introduce Quick sights, Redshift or other technology.
• Data Pipelines & ETL:
  Build, maintain, and scale robust ETL processes, data replication processes, and data sync engines utilizing batch processing and parallel execution chains.
• Database Optimization:
  Identify and address performance bottlenecks using advanced database performance strategies like index optimization, denormalized columns, and rollup tables.
• API Development:
  Design and build data-intensive, scalable REST APIs that power core SaaS reporting features without relying on excessive external API calls.
• Cross-functional Collaboration:
  
  Collaborate closely with Product to translate reporting requirements into technical implementation plans. Work with Frontend Engineers to ensure smooth delivery of data visualizations.
• Code Quality:
  Participate in code reviews, write automated integration/unit tests, and ensure backend code and data models follow modern best practices.

• Database Performance:
  Proven ability to manage massive data volumes (millions of records). Strong understanding of indexing, stored procedures, denormalization strategies, and creating rollup tables for reporting.
• Advanced SQL & MySQL:
  Deep expertise in MySQL and writing highly performant, direct SQL code. Must be comfortable with advanced concepts including complex Joins, Subqueries, Dynamic SQL, and Common Table Expressions (CTEs).
• ETL & Data Sync:
  Extensive experience building ETL processes, data replication, and high-volume data synchronization engines.
• AWS Cloud Ecosystem:
  Experience working with AWS cloud services, specifically Aurora Serverless, DynamoDB, Lambda, and SQS.
• NodeJS & JavaScript:
  Proficiency with NodeJS (Express/Fastify), JavaScript (ES6+), and asynchronous programming patterns.
• ORM
  
  Experience:
  
  Experience working with modern ORMs (like Sequelize) while knowing when to bypass them for raw SQL performance.
• System Migration:
  Demonstrated experience modernizing legacy databases or migrating complex architectures into modern cloud ecosystems.
• Detailed-Oriented: A strong sense of ownership for data integrity, code reliability, and accuracy in a product environment.
• Communication:
  Excellent verbal and…