· Analysis of business requirement documents and liaison with clients.
· Facilitating IT development, design, construction, testing, promotion, implementation of web-based/n-tier, cloud-based and mainframe applications
· Define standards for the integration and governance of enterprise data
· Design metadata management programs and scripts
· Define and evaluate conceptual, logical, and physical BI solution architectures
· Design healthcare business information structures (cubes, dimensions, facts, tables, etc.)
· Perform data quality assessments, data transformation, and data cleansing
· Develop test scripts and perform testing of BI solutions
· Responsible for Java based development utilizing a combination of WebSphere, JDBC, Oracle, DB2, DataPower and associated Web technologies including JavaScript and JSP
· Responsible for integration of Open Source Software (OSS) products into new and existing systems
· Creation and walk-through of Systems Response documents, Technical Specifications, Application Inventory, and Implementation Plans.
· Preparation of test plans, test data, and unit-testing of programs.
· Preparation of implementation plans and promotion of programs.
· System Support/Documentation
· As assigned, response to client queries and troubleshooting of production incidents.
· Conduct/participate in design walkthroughs as well as test case and test results walkthroughs.
· Support testing of the changes by other team members.
· Provide recommendations to the Project Manager as to the acceptance or rejection of any changed system components.
· Weekly reporting on status, progress, and key issue/concerns as directed by the Project Lead or Sr. Project Manager.
· Transfer skills and knowledge to selected OPS staff.
The resource may be required to do similar work related to the role, for other initiatives within PRS, as directed by the manager.

NOTE:
Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
Extension/Amendment Attestation:
Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original SOW.
HSC may exercise its option to extend the SOW beyond October 5, 2027, provided that the Master Service Agreement is extended. Any such extension shall be on the same terms, conditions, and covenants as those contained in the SOW.

• Skills

• Experience and Skill Set Requirements
Public Sector Experience
Experience working in the public sector on a mid-tier cloud and/or legacy platform.
5%
Technical Skills
· 5 + more years of business intelligence experience
· 5 + years of Cognos experience
· 5+ years – Framework Manager and Report Studio
· 5+ years – Active Reports, Transformer and dashboarding
· 5+ years – Report Studio (including being a trainer/mentor)
· 3+ years – Metrics Studio
· 5 years data analysis experience
· IBM Certified Designer – Cognos 11.2.1 BI Reports
· IBM Certified Developer – Cognos 11.2.1 BI Metadata Models
· IBM Certified Administrator – Cognos 11.2.1 BI
· Experience in facilitating workshops with diverse groups of stakeholders (e.g. technical, clinical, executive)
· Experience evaluating design options to support the implementation of a system.
· Preparation of automated deployment builds (Jenkins)
· Experience in structured, agile and DevOps methodologies for the development, design, implementation, and maintenance of applications.
· Experience with one or more platforms, including the operating system, database technology, communication protocols, middleware, and gateways
· Experience developing or maintaining large scale IT systems, including high-volume public facing programs
· Development and design of new programs or enhancements to existing ones
· Integration of service API’s and micro-services to existing or new web services.
· Ability to understand and analyze business requirements, and to design structured programs that efficiently satisfy these requirements
· Ability to write programs that are modular, well-structured, and easy to maintain
· Demonstrated success writing system design and implementation documents
· Experience with, and understanding of, relational databases (DB2, Oracle, MS-SQL)
· Preparation of test plans, test data, and unit-testing of programs
· Preparation of implementation plans and promotion of modules
· Participate in business requirements walkthroughs
· Conduct/participate in design walkthroughs
· Conduct/participate in testing walkthroughs
50%
Analytical Skills
· Analysis of business requirement documents and liaison with clients
· Experience adopting and adhering to unified I&IT project management methodologies (waterfall, agile and DevOps) enterprise architecture and gating frameworks, and standard systems development methodologies.
· Respond to client queries and troubleshooting of production incidents with proven and demonstrable troubleshooting and analytical experience
30%
Communications Skills
· Strong verbal and written communications skills.
· Strong Interpersonal and negotiation skills.
· Strong consulting skills to engage with all stakeholders.
· A demonstrated team player with a track record for meeting deadlines.
· Demonstrated success in working productively with business clients, developers, and technical specialists such as DBAs, web administrators, etc.
· Demonstrated experience reporting status, progress, and key issue/concerns to project managers and leads.
15%

• Supplier Comments
Closing Date - 2026-05-05, 11:00 a.m.
Maximum Number of Submissions - 1 (one)

Assignment Type - Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

MUST HAVES:

Please refer to the Experience and Skillset Requirements