About UsThe Ontario Cannabis Store provides safe, responsible access to recreational cannabis for adults 19 and older. We operate the sole legal online store for recreational cannabis in Ontario and are the provincial wholesaler of cannabis for private retail stores.Working at the OCS is a unique opportunity to be part of an agile start-up in a ground‑breaking new industry. We’re a diverse team passionate about delivering a great customer experience, working together with mutual respect and building value out of our differences. We’re an inclusive organization that understands that delivering great results comes out of ensuring every voice is heard.About the RoleWe’re looking for a Senior Software Engineer – Central Systems to join our team!The Software Engineer is a senior member of the IT Development team, responsible for development of individual projects/applications within our Central Systems area. They are highly proficient in specific applications/technology and competent in identifying emerging technologies that may benefit this domain. They are also skilled in collaborating with other Software Engineers to problem‑solve technical issues.They foster relationships with Architects, the S&T team, and business leads in the OCS to understand project design and deliver on all technology requirements. They execute development plans according to solution design plans, work with the QA team to ensure no defects in promoted code, collaborate with the QA and DevOps team in transition planning to the support team, and act as L3 support for completed development work.About Your DayDevelops and provides effort estimates for design and development activities across their area of expertiseRefactor and migrate legacy code and systems to recent cutting‑edge technologiesPracticed ability to influence strategy within the application domain and related domainsTranslate functional requirements and wireframes into working technologyDeploy established development tools, guidelines, and conventions and advocate solutions for the application/solutionDevelops real‑time and batch interface programs and scalable and high‑performance interfacesWrites programs to extract, translate, load,



and verify data using an enterprise messaging layer (i.E. Kafka)Develops programs to address requirements for data conversions and other data transformationsAbility to configure SaaS, COTS (Commercial Off‑The‑Shelf) Software with trainingParticipates in system and application upgrades and other support activities as neededAssists users in solving programs and answers systems and application‑related questionsAdheres to programming standards when performing analysis, writing documentation, and testing componentsDevelop code utilizing modern development practices such as Continuous Integration, Continuous Deployment, and agile methodologiesDevelop Unit test cases and validate test results during testingDevelops documentation for the programs written or modifiedProvide input for training materialsParticipate in triage meetings involving all the required stakeholders, to discuss actions on any defects and issues the testing team has found during testingInvestigate, resolve and Escalate problems and develop recommendations for resolutionIdentifies need for technical assistance to help in problem resolutionAbout YouPost‑Secondary education in Computer Science, Information Technology or related areas OR equivalent combination of education and experienceSignificant experience in Systems Integration and Application Development within the Retail or B2B Systems industryCertification in Microsoft Dynamics AX and D365 is an asset6+ years of experience with development, databases and data warehousesProficiency in working with widely used DBMS platforms like Azure SQL, PostgreSQL, or CosmosDB, including advanced knowledge of SQL Server Engine architecture and SQL Server Integration ServicesCloud experience (Azure preferred) and proven experience with Azure Synapse, Logic Apps,



Azure Data Factory and Azure FunctionsStrong SQL skills for writing and optimizing queries to ensure efficient data retrieval and manipulation. Expertise in:Tables and ViewsIndexing (including column store indexes), query execution plans, performance tuning and troubleshootingRelational data modeling (ERD)T‑SQL development would be an assetStored proceduresTriggersPerformance tuningQuery execution plan analysisStatistics IOAbility to design and implement OLTP database schemas, considering data normalization, de‑normalization, and best practices for relational and NoSQL databases.Experience in logical and physical database design and relational data modeling (ERD), as well as data warehousing and Azure data / delta lakesFamiliarity with RESTful API principles, including how to interact with APIs from within the database environmentsProficiency in scripting languages to automate routine tasks, such as backups, data migrations, and monitoring (e.G. Spark, Python, PySpark)Skilled in monitoring database performance and able to diagnose and resolve performance bottlenecksFamiliarity with version control systems (e.G., Git) to track changes to database schemas, scripts, and configurationsAbility to provide production support and respond quicklyComfortable to use Jira, Confluence, Zeplin, and InVision tools in day‑to‑day activitiesAbility to work in Agile methodologyStrong analytical data‑driven thinking skillsAbout the JobLocation: Toronto, ON near York Mills and Yonge StreetHours of Work: 36.25 a weekEmployment Type: Full‑Time, PermanentRequired Travel: Rare, usually within the GTACompensationThe target hiring range for this position is $100,000–$120,000. This is a pay grade 7 role, with a salary range of $82,623.96–$123,507.59. Placement in the salary range will be based on factors such as market conditions, internal equity, and candidate experience, skills, and qualifications relevant to the role.We are committed to providing an accessible, equitable and inclusive candidate and employee experience. We provide reasonable accommodation throughout the recruitment process and in employment. If you require an accommodation please let us know, we will work with you to meet your needs.#J-18808-Ljbffr

📌 Senior Software Engineer - $100,000 - $120,000 A Year (Toronto)
🏢 Ontario Cannabis Store
📍 Toronto