Senior Software Engineer (Central Systems)

Job Responsibility: About Us The 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 Role We're seeking a Senior Software Engineer to join our team! The Software Engineer will be a senior member of the IT Development team, and will be responsible for development of individual projects/applications within our ‘Central Systems' area. They will be highly proficient in specific applications/technology, and competent in identify emerging technologies that may benefit this domain. They will also be skilled in collaborating with other Software Engineers to problem solve technical issues. They will foster relationships with Architects, S&T team, and business leads in the OCS to understand the project design and deliver on all technology requirements. They will execute development plans according to solution design plans, and work with the QA team to ensure no defects in promoted code. They will work with the QA and DevOps team in transition planning to the support team, and act as L3 support for completed development work. About Your Day

• Provides input from a systems perspective
• Develops and provides effort estimates for design and development activities across their area of expertise
• Refactor and migrate legacy code and systems to new cutting-edge technologies
• Proficient knowledge in the application domain
• Practiced ability to influence strategy within the application domain and related domains
• Designs components within their specific software application/technology
• Translate functional requirements and wireframes into working technology
• Deploy established development tools, guidelines, and conventions and advocate solutions for the application/solution
• Develops real time and batch interface programs and scalable and high-performance interfaces
• Develops small/midsize applications where there is no commercially available solution
• Analyzes current and new information systems requirements
• Writes 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 transformations
• Ability to configure SaaS, COTS (Commercial Off-The-Shelf) Software with training
• Participates in system and application upgrades and other support activities as needed
• Assists users in solving programs and answers systems and application-related questions.
• Develops programs for automatic correction of erroneous data
• Adheres to programming standards when performing analysis, writing documentation, and testing components.
• Develop code utilizing modern development practices such as Continous Integration, Continuous Deployment, and agile methodologies
• Participate in Secure Code reviews
• Develop Unit test cases and validates test results during testing
• Tests and debugs application in conjunction with business
• Utilize test-driven development and automated testing frameworks
• Develops documentation for the programs written or modified
• Provide input for training materials
• Participate in triage meetings involving all the required stakeholders, to discuss actions on any defects and issues the testing team has found during testing
• Investigate, resolve and escalate problems and develop recommendations for resolution.
• Identifies need for technical assistance to help in problem resolution
• Escalates issues as appropriate

About You

• Post-Secondary education in Computer Science, Information Technology or related areas OR equivalent combination of education and experience
• Significant experience in Systems Integration and Application Development within the Retail or B2B Systems industry
• Certification in Microsoft Dynamics AX and D365 is an asset
• 6+ years of experience with development, databases and data warehouses
• Strong proficiency in implementing solutions using X++, SSRS, .NET, and C#, Fetch, XML, JavaScript, and/or other applicable programming language.
• Proficiency 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 Services
• Cloud experience (Azure preferred) and proven experience with Azure Synapse, Logic Apps, Azure Data Factory and Azure Functions
• Strong SQL skills for writing and optimizing queries to ensure efficient data retrieval and manipulation. Expertise in:
• Tables and Views
• Indexing (including column store indexes), query execution plans, performance tuning and troubleshooting
• Relation data modeling (ERD)
• T-SQL development would be an asset
• Stored procedures
• Triggers
• performance tuning
• Query execution plan analysis
• Statistics IO
• Ability to design and implement OLTP database schemas, considering data normalization, de-normalization, and best practices for relational and NoSQL databases.
• Skills in logical and physical database design and Relation data modeling (ERD), as well as data warehousing and Azure data / delta lakes
• Familiarity with RESTful API principles, including how to interact with APIs from within the database environments
• Proficiency 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 bottlenecks
• Familiarity with version control systems (e.g., Git) to track changes to database schemas, scripts, and configurations
• Ability to provide production support and respond quickly
• Resolve production incidents with SME level of knowledge
• Comfortable to use Jira, Confluence, Zeplin and InVision tools in day-to-day activities
• Ability to work in Agile methodology
• Strong analytical data-driven thinking skills

About the Job

• This position currently offers a fully remote work schedule. (The in-office requirement is depending on business needs. The OCS office is located near York Mills and Yonge St. However, OCS reserves the right to change this policy and its office location at any time.)
• City: Toronto, ON
• Employment Type: Permanent, Full- Time
• Required Travel: Rare, usually within the GTA

Compensation The target hiring range for this position is $100,000- $120,000. This is a pay grade 7 role, with a salary range of $81,805.90 - $ 122,284.74 . 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.