Software Developer - Full Stack

Project Overview

WebFOCUS is the reporting and Business Intelligence (BI) framework currently used to support MTO operational reporting for several critical business functions. This engagement supports the design, development, and delivery of a replacement operational reporting portal. The successful resource(s) will re-platform existing WebFOCUS reports — including the underlying business logic, SQL, and data transformation rules — into a modern, supportable web application (Java back end / Angular front end) hosted in the ministry's Azure environment, in accordance with Ontario Public Service (OPS) architecture, security, and accessibility standards.

Key Responsibilities

• Develop fully commented and functional Angular front-end code for the reporting portal
• Create unit test code and automated UI test coverage
• Build responsive, accessible (AODA-compliant) report views translated from existing WebFOCUS report layouts
• Design and construct REST API services exposing report and reference data
• Provide documentation for developers on effective use, integration, and versioning of the API
• Develop Java-based backend services connecting the application to underlying relational databases
• Migrate and refactor existing WebFOCUS SQL and report logic into the new application
• Produce source code developed to specification, version-controlled in Azure DevOps

Qualifications & Requirements

REQUIRED

• Must be able to work onsite at either 87 Sir William Hearst Ave., Toronto, or 301 St Paul St, St. Catharines
• 8+ years of experience developing large-scale, production business applications using Java for backend/API development
• 5+ years of experience with Angular (or comparable modern JS/TS framework) for front-end development
• Experience in programming and analysis, with specialized software package support at the specified experience level
• Ability to collaborate with IT professionals throughout the software development process
• Experience with Agile/Scrum methodology for the development, design, implementation, and maintenance of applications
• Experience with design, coding, testing, and debugging of applications
• Experience with relational database technologies and SQL, including reading and refactoring existing report/query logic
• Ability to work independently and deliver production-ready components with minimal supervision
• Proficient with both front-end and back-end development, including associated areas such as database design/management and DevOps
• Experience with Java for backend/API development
• Experience with Angular for front-end development
• Design and implementation of overall solution architecture for a web-based reporting application
• Design and construction of REST API services, and integration of front-end UIs with those APIs
• Design and deployment of databases; ability to translate existing SQL/report logic into a modern application
• Experience deploying and supporting applications in a Microsoft Azure environment
• Supporting the implementation/upkeep of Continuous Integration and Continuous Deployment (CI/CD) pipelines, e.g., Azure DevOps
• Ensuring the solution is designed and built for performance, scalability, and maintainability

NICE TO HAVE

• Prior exposure to or working knowledge of WebFOCUS is an asset
• Working knowledge of Power BI
• Working knowledge of Databricks
• Knowledge and understanding of the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards
• Ability to provide system documentation as required
• Experience working within an Ontario Public Service (OPS) or broader public sector IT environment

EVALUATION CRITERIA

• Full Stack Development – Java & Angular - 45 points
  • 8+ years of experience developing large-scale, production business applications using Java for backend/API development
  • 5+ years of experience with Angular (or comparable modern JS/TS framework) for front-end development
  • Demonstrated ownership of end-to-end solution architecture across the full stack, including sound trade-off decisions made independently
  • Depth and breadth of hands-on full stack delivery will be weighted heavily, as this is the core capability required for the engagement

• Database, SQL & Reporting Logic Migration - 20 points
  • Strong experience with relational database technologies and SQL
  • Demonstrated ability to interpret, refactor, and re-platform existing report/query logic (e.g., WebFOCUS or equivalent BI tooling) into a modern application
  • Experience with database design and deployment

• API Development & Azure Deployment - 15 points
  • Experience designing, building, and documenting REST API services
  • Experience deploying and supporting applications in a Microsoft Azure environment
  • Working familiarity with CI/CD pipelines (e.g., Azure DevOps) sufficient to integrate with an existing pipeline maintained by a separate team

• Agile Methodology & OPS Delivery - 10 points
  • 5+ years of experience with Agile/Scrum delivery methodologies
  • Knowledge of Ontario Digital Service standards and/or prior experience in an Ontario Public Service (OPS) or broader public sector IT environment
  • Ability to work independently with minimal oversight and take ownership of delivery timelines, commensurate with a senior-level engagement

• Personal Skills - 10 points
  • Excellent analytical, problem-solving, and decision-making skills
  • Excellent interpersonal, communication, and presentation skills
  • Solid business acumen; ability to dialogue with business teams/leadership to understand priorities and goals, with a focus on delivering business value

Key Skills & Competencies

Java, Angular, SQL, REST API, Microsoft Azure, Azure DevOps, CI/CD, WebFOCUS, Power BI, Databricks, Relational Database, Frontend Development, Backend Development, API Development, Database Design, DevOps