{bc}
Apply
workday

Senior Backend Engineer

Fullsteam
Remote, CAN
Full-time
Senior · 5+ years experience
Remote
CAD 116000-140000 yearly / year
Discovered 3 weeks ago
NodeJSExpressFastifyAWS LambdaMySQLSequelize

Full Job Posting

Primary Responsibilities

  • Data & Reporting Ownership: Take ownership of a multi-tenant reporting architecture (currently 16 pools with individual tenant databases, over 3000 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
  • This posting is for an existing vacancy and will remain open until filled.
  • 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.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Fullsteam

Account Executive, Maestro PMS

, USA

Discovered TodayFull-time

Billing Specialist (SaaS Billing)

, CAN

Discovered 2 days agoFull-time

Agentic Operations Engineer

, USA

Discovered 2 days agoFull-time

Frontend Engineer

, CAN

Discovered 6 days agoFull-time

Demand Generation Manager

, CAN

Discovered 6 days agoFull-time

AI/ML Software Engineering - Talent Pipeline

, USA

Discovered 3 weeks agoFull-time

Accounting Manager, Payments and Platform Services Revenue

, USA

Discovered 3 weeks agoFull-time

Corporate Counsel

, USA

Discovered 3 weeks agoFull-time