Senior Backend Engineer

FS Operations Canada, Ltd; Auburn (AL); Remote; CAD 116,000 - 140,000; Full time

Benefits offered by this job

Medical

Extended Health and LTD plan

Dental

Vision

RRSP with employer match

Health Spending Account

Flexible paid time off

Job summary

Commerce7, part of the Fullsteam organization, seeks a Senior Backend Engineer to design, build, and optimize data systems powering our products and business insights.

You will own multi-tenant reporting, modernize legacy systems, and build robust ETL pipelines while collaborating with Product and Frontend teams to deliver scalable SaaS reporting features.

Qualifications

• 5+ years of backend software engineering focused on database architecture, data processing and reporting.
• Strong JavaScript (ES6+) and NodeJS (Express/Fastify/AWS Lambda).
• Advanced MySQL expertise and experience with ORMs like Sequelize.
• Experience with AWS services: Aurora Serverless, DynamoDB, SQS.
• Ability to migrate legacy systems and modernize databases.
• Excellent communication and collaboration across teams.

Responsibilities

• Own multi-tenant reporting architecture with high performance.
• Migrate legacy MSSQL/SSRS to modern stack.
• Build ETL pipelines, data replication and sync engines.
• Optimize database performance with indexing and rollups.
• Develop scalable REST APIs powering SaaS reporting.
• Collaborate with Product and Frontend for data visualizations.
• Participate in code reviews and testing.

Skills

Database performance

Advanced SQL & MySQL

ETL & Data sync

AWS Cloud

NodeJS & JavaScript

ORM experience (Sequelize)

System migration

Attention to detail

Communication

Tools

Sequelize ORM

MSSQL/SSRS

Job description

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.

Primary Responsibilities:

• 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 Quicksights, 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.

Skills & Competencies:

• 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 written communication skills to collaborate effectively across engineering and product teams.
• User first: A deep empathy for the user and a desire to learn about how they use Commerce7.

Minimum Qualifications:

• 5+ years of experience in backend software engineering with a direct focus on database architecture, data processing, ETL, and reporting systems.
• Strong proficiency in JavaScript (ES6+) and NodeJS (Express, Fastify, AWS Lambda).
• Advanced hands-on experience with MySQL, modern ORMs (e.g., Sequelize), and writing optimized raw SQL.
• Direct experience working with AWS cloud services (Aurora Serverless, DynamoDB, SQS).
• Demonstrated track record of executing database migrations or legacy system modernizations (experience with MSSQL, SSRS, or PowerShell is a strong advantage).

Salary Range:

$116,000 - $140,000 CAD

Fullsteam recognizes that your health and wellbeing are a priority. This is why we offer a full suite of benefits that include:

• Medical
• Extended Health and LTD plan
• Dental
• Vision
• RRSP (with employer match)
• Health Spending Account
• Flexible paid time off

Fullsteam supports an inclusive workplace that values diversity of thought, experience, and background. Fullsteam is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state, or local law.

Fullsteam: Leading the Evolution of Software and Payments Fullsteam integrates modern and scalable payments technology with vertical software to create industry-specific features and end-to-end business management systems. Fullsteam is a rapidly growing, dynamic, and exciting private equity-backed software and payments company headquartered in Auburn, AL. The company was formed in 2018 by a core group of talented payments and software experts. Fullsteam is quickly expanding its operations through the acquisition of strategic portfolio companies that could benefit from our cutting-edge software and payments platform.

This posting is for an existing vacancy and will remain open until filled.