Senior Software Developer (Back-End)

Description

• Lead the migration from SQL Server to PostgreSQL, including schema redesign, query refactoring, and performance tuning, and implement migration strategies with validation and rollback paths.
• Establish patterns for safe schema evolution and collaborate with the Data Architect to keep backend and analytics schemas aligned.
• Contribute to observability through logging, metrics, and diagnostics that make production behavior transparent.
• Consolidate parts of the existing distributed system into the new architecture without disrupting functionality, and refactor services, models, and APIs to reduce duplication and complexity.
• Work closely with other developers, QA, and product teams to deliver incremental, safe changes, participate in code reviews, and document architecture and migration plans for clarity and maintainability.
• Define and evolve a modular monolith architecture with clear boundaries and explicit dependencies.
• Develop backend services and APIs that power web and mobile applications, integrate internal and external data sources, and maintain automated tests around critical business flows.
• Bring rigor to database design, including schemas, naming conventions, constraints, indexing, and migrations, and own the overall data model for core product domains.

Requirements

• Comfortable reasoning about and simplifying distributed systems: understanding where you can safely centralize logic and where you actually need distribution.
• Experience in safety-critical or high-reliability domains (infrastructure, utilities, transportation, environmental, etc.).
• Experience working in a codebase that has real history (legacy behaviors, odd edges) and incrementally improving it instead of starting from scratch.
• Solid experience with at least one backend language/framework (e.g., TypeScript/Node.js, C#/.NET, Python, or similar) and modern engineering practices (code review, CI/CD, automated testing).
• Direct experience consolidating microservices / distributed monoliths into monoliths or modular monoliths.
• Strong experience with relational databases: schema design, normalization, indexing, query optimization, and transaction semantics.
• Familiarity with geospatial or time-series data and related patterns (though domain expertise can also be learned on the job).
• 7+ years of professional experience building and maintaining backend systems in production.
• Hands-on SQL expertise in at least one of SQL Server or PostgreSQL; ideally you’ve worked with both, or have done a migration between major RDBMSs.
• Good communication skills: you can explain technical trade-offs to peers, document decisions, and collaborate across disciplines.
• Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, or a related discipline or equivalent experience.
• Experience with PostgreSQL-specific features (e.g., JSONB, PostGIS, window functions) and how to use them judiciously.

Benefits

• Hybrid workplace with our downtown office
• Mentoring opportunities
• Casual and professional work environment
• Social and wellness activities

Training + Development

Interview process

Visa Sponsorship

Security clearance