Software Developer - Senior
Summary:
Join our team as a Senior Cognos BI Developer to lead the design, development, and implementation of business intelligence solutions in a hybrid work environment (3 days onsite/2 remote). This role involves end-to-end BI development using IBM Cognos 11.2.1, including Framework Manager, Report Studio, Transformer, and Active Reports. You'll collaborate with stakeholders to gather requirements, analyze data, and support testing and deployment. Ideal candidates have over 5 years of BI experience, strong data analysis skills, Cognos certifications, and expertise with relational databases like DB2 and Oracle. Public sector experience and excellent communication and troubleshooting skills are highly valued.
 
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.
  • Weekly reporting on status, progress, and key issue/concerns as directed by the Project Lead/Project Manager or Portfolio Manager

 

NOTE

Extension/Amendment Attestation:  Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. The Statement(s) of Work (SOW) shall expire on March 31, 2026. HSC will exercise its option(s) to extend the SOW beyond March 31, 2026, using unused days/funds left on contract and any extension options included in the original SOW. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions and covenants contained in the SOW.

 

Assignment Type: This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion. 

Skills
Experience and Skill Set Requirements

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

45%

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

35%

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.

15%

Public Sector Experience

·Experience working in the Public Sector

5%

 

Supplier Comments

Closing Date - 2025-06-20, 3:00 p.m.

Maximum number of candidate submission - 1 (one)

Hybrid - 3 days in office, 2 days work from home

 

MUST HAVES

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