Rq08951 - Software Developer - Senior

About the job RQ08951 - Software Developer - SeniorDescription
Responsibilities:Software Developer (BO)
Develop, test, support and maintain Panorama Business Object (BO) reports. This includes modifying the underlying components to conform to vendor upgrade releases of the Panorama product, business requirement changes, as well as support for Panorama reports
Supporting Panorama Immunization, Inventory and Audit reports, including 29 critical reports for Immunization and 44 reports for Inventory using Business Objects tools
Provide subject matter expertise to develop and maintain BO tools for development and unit testing
Provide Business Objects and Crystal Reports
SQL query creation and tuning
Provide Business intelligence and data analytics, data warehouse design, development and support
Conducting technical analysis, troubleshooting, and issuing resolutions for production operational support of Panorama reports and other components and utilities
Develop reports using relational and hierarchical database technologies
Support BO administration and package creation
Provide and support BO upgrades
Conduct research and assessment of options for technical design issues
Provide impact analysis, effort estimate and solution design/development for supported solutions due to IR solution upgrades, software upgrades or any new requirements (e.G. Panorama 4.4.X upgrades, PHU merge and more)
Assess and analyze impact of upgrades to BO reports for Panorama updates, as well as developing the changes/improvements needed as per change requests already approved
Resolving and implementing critical fixes and changes as per defects found by business and as per Panorama critical changes
Conduct routine and incident management
Perform performance tuning as well as audit and ad hoc reporting per business requests
Meeting the service level agreements by troubleshooting and solving incidents opened for business objects reports via service desk
Maintain Development environments and continue continuous Integration (CI) practice
Translate technical systems specifications into working, tested applications
Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.
SkillsExperience and Skill Set RequirementsPublic Sector Experience
Knowledge of the provincial immunization system and Public Sector large complex IT Health related projects or equivalent
Experience with integration of Clinical IT Systems such as Client and Provider Registries
Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
Knowledge of industry standard such as Project Management Institute (PMI)
Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.
5 points
Technical Skills10+ years of experience in the following:
SAP BusinessObject (BOBJ) and Crystal Report
Other Reporting tools, particularly Cognos and PowerBI would be an asset
Database management such as data normalization, relational database structures, table joins, database constraints
BO scripting, Unix/Linux shell scripting and tuning
BO administration and package creation
Informatica or other ETL experience
Oracle (19c), SQL, PL/SQL, JSON, XML, optimized database queries, data architecture, data design, modeling and mapping Business intelligence and data analytics, data warehouse design, development and support.
Database and BO Performance tuning, automation
Enhanced CI/CD experience and DevOps methodologies and technologies an asset
BO/Crystal report AODA
Develop and support application monitoring using Elastic/Logstash/Kibana or Sematext
Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services
Knowledge of the provincial immunization systems.
45 points
Core Skills, Knowledge and Experience10+ years of experience with:
Creating new database objects, develop indexes, trigger procedures or manipulating the tables to create materialized views
Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications sustainment and upgrades
Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions
Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices
Conducting technical analysis, program code, detailed programming reports and specifications, program design, writing and/or generating code, and conducting tests
Developing and maintaining system design models, technical documentation and specifications
Maintaining development environments and adopt continuous Integration (CI) practice
Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
Providing impact analysis, effort estimate and solution design/development for solution/software upgrades or based on any new business requirements
Undertaking proof of technology with test data to simulate application load and performance tuning related applications
Providing software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Providing application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
Developing and maintaining system design models, technical documentation and specifications
Developing medical and clinical based systems
Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Conducting technical analysis, trouble‑shooting, and issue resolutions for production operational support of reports, and other components and utilities
Knowledge of recognized accessibility laws, regulations, and standards (e.G., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing
Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports
Experience with Software Development Lifecycle (SDLC)
Continuous Integration (CI) practice and enhanced Ci/CD experience and DevOps methodologies and technologies an asset
Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.
20 points
General Skills
Demonstrated strong leadership and people management skills
Exceptional analytical, problem solving and decision-making skills
Demonstrated strong interpersonal, verbal and written communication, and presentation skills
Proven troubleshooting and critical thinking experience
Demonstrated ability to apply strong listening skills to facilitate issue resolution
Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively
A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
30 points
MUST HAVES:10+ years of experience in the following:
SAP BusinessObjects (BOBJ) Server, Crystal Reports, WEBI Reports
Oracle (19c), SQL, PL/SQL, JSON, XML, optimized database queries, data architecture, data design, modeling and mapping Business intelligence and data analytics, data warehouse design, development and support.
Database management such as data normalization, relational database structures, table joins, database constraints
BO scripting, Unix/Linux shell scripting and tuning
BO administration and package creation
Nice To Have:
Other Reporting tools, particularly Cognos and PowerBI would be an asset
#J-18808-Ljbffr