About the Role
Our Client is seeking a Senior Software Developer with strong expertise in SAP BusinessObjects Crystal Reports and enterprise reporting platforms to support critical public health reporting systems. The role focuses on developing maintaining and optimizing Panorama reporting solutions supporting immunization inventory and audit reporting while ensuring system performance reliability and compliance with enterprise architecture standards.
Key Responsibilities
Develop maintain and support SAP BusinessObjects (BOBJ) and Crystal Reports solutions.
Support Panorama reporting systems including Immunization Inventory and Audit reports.
Design and develop reports using relational and hierarchical database technologies.
Create and optimize SQL queries and PL/SQL procedures for reporting and analytics.
Perform database performance tuning and query optimization.
Support BusinessObjects administration package creation and report upgrades.
Provide technical analysis troubleshooting and production support for reporting systems.
Conduct impact analysis effort estimation and solution design for upgrades or new requirements.
Resolve defects and implement enhancements for Panorama reporting solutions.
Support incident management and resolve service desk tickets while meeting SLA requirements.
Perform performance tuning audit reporting and ad hoc reporting requests.
Maintain development environments and support Continuous Integration (CI) practices.
Translate technical system specifications into working and tested applications.
Conduct technical analysis program design coding and unit testing.
Required Technical Skills
SAP BusinessObjects (BOBJ)
Crystal Reports
Oracle 19c
SQL and PL/SQL
Data modeling and relational database design
Database normalization joins constraints and query optimization
Business intelligence and data warehouse design and development
BO scripting
Unix/Linux shell scripting
Informatica or other ETL tools
JSON and XML
Java and API integrations
RESTful web services
HL7 / FHIR healthcare integration standards
BusinessObjects administration and package management
Database and BI performance tuning
Application monitoring tools such as Elastic Logstash Kibana or Sematext
CI/CD pipelines and DevOps methodologies
Assets: Cognos Power BI AODA compliance experience.
Public Sector & Healthcare Experience (Preferred)
Experience working on large public sector IT systems particularly within healthcare environments.
Knowledge of provincial immunization systems or Panorama platform.
Experience integrating clinical IT systems such as Client and Provider Registries.
Familiarity with public sector enterprise architecture frameworks and government SDLC processes.
Knowledge of PMI project management practices.
Core Experience
10 years of experience developing enterprise reporting and data solutions.
Experience creating database objects such as indexes triggers and materialized views.
Experience translating business requirements into technical application design.
Experience working with QA teams for testing debugging and deployment.
Experience developing complex enterprise applications and supporting system upgrades.
Strong experience with SDLC Agile development methodologies and CI practices.
Experience performing architecture assessments and technical design analysis.
Experience maintaining technical documentation and system design specifications.
Experience supporting mission critical production systems.
Compliance & Accessibility
Knowledge of accessibility standards such as W3C WCAG and AODA.
Experience supporting usability accessibility and compliance testing.