Senior Cognos BI Architect

MUST HAVES:

• Please refer to the Experience and Skillset Requirements

Description

• 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.

Experience and Skill Set Requirements

Public Sector Experience - 5%

• Experience working in the public sector on a mid-tier cloud and/or legacy platform.

Technical Skills - 50%

• 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 APIs 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

Analytical Skills - 30%

• 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

Communications Skills - 15%

• 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.