Cognos Administrator

Infinite Computer Solutions; United States; On-site; USD 110,000 - 140,000; Full time

Job summary

Infinite Computer Solutions is seeking a Cognos Administrator for the Medicaid EDW. This role ensures reliable delivery of operational, analytical, and federally mandated reports to state agencies, CMS, and internal stakeholders while maintaining HIPAA compliance.

You will install, configure, monitor, and support IBM Cognos Analytics environments across Development, Test, UAT, and Production, including security, performance tuning, and change management.

Qualifications

• 5+ years administering IBM Cognos Analytics or Cognos BI.
• Strong Cognos architecture, security, and deployment knowledge.
• Proficiency in SQL and relational data models.
• Experience with large enterprise data warehouses.
• Familiarity with Unix/Linux and Windows servers.
• Experience with job scheduling and performance tuning.
• Healthcare data experience, Medicaid/MMIS, HIPAA/CMS knowledge.

Responsibilities

• Install, configure, upgrade, patch IBM Cognos Analytics.
• Manage Cognos environments across Dev, Test, UAT, Prod.
• Monitor health, schedules, and report performance.
• Troubleshoot Cognos issues and performance bottlenecks.
• Configure security and access controls, HIPAA compliant.
• Support CMS- and state reporting (T-MSIS, MBES/CBES).
• Provide Tier 2/3 support for incidents and requests.

Skills

Cognos Administration

SQL

Unix/Linux

Windows Server

Medicaid data

HIPAA compliance

Job scheduling

Tools

DataStage

Informatica

ETL tools

Job description

Domain-Medicaid Enterprise Data Warehouse

Position Summary

This is not a developer role, though collaboration with developers may occur.

The Cognos Administrator is responsible for the installation, configuration, security, performance, and ongoing support of the IBM Cognos Analytics environment used by the Medicaid Enterprise Data Warehouse (EDW). This role ensures reliable delivery of operational, analytical, and federally mandated reports to state agencies, CMS, and internal stakeholders while maintaining compliance with HIPAA, CMS, and state security requirements.

Key Responsibilities

• Install, configure, upgrade, and patch IBM Cognos Analytics (including gateways, application servers, and content manager components).
• Manage Cognos environments across Development, Test, UAT, and Production.
• Monitor system health, job schedules, and report execution performance.
• Troubleshoot and resolve Cognos platform issues, outages, and performance bottlenecks.

Security & Access Control

• Configure Cognos security using ForgeRock integration.
• Manage roles, groups, object-level permissions, and data-level security.
• Ensure HIPAA-compliant access to PHI and PII.
• Support audit requests related to user access and report usage.

Report Operations & Scheduling

• Administer report schedules, bursting, distribution, and subscriptions.
• Support high-volume batch reporting (e.g., MMIS, claims, provider, eligibility, financial reports).
• Coordinate report promotions and content migrations between environments.

Performance & Optimization

• Tune Cognos configurations for large datasets and complex queries.
• Collaborate with EDW DBAs and ETL teams to optimize queries, indexes, and data models.
• Identify and resolve long-running or failed reports.

Change & Release Management

• Support report and platform releases following ITIL or SDLC processes.
• Maintain rollback procedures and disaster recovery readiness.

Compliance & Federal Reporting Support

• Support CMS-required reports (e.g., T-MSIS, MBES/CBES, financial and program integrity reporting).
• Ensure reporting availability and timeliness for federal and state audits.
• Document Cognos configurations, processes, and operational procedures.
• Work with report developers, business analysts, and data modelers.
• Provide Tier 2/Tier 3 support for Cognos-related incidents and service requests.
• Assist end users with access issues and basic report execution troubleshooting.

Required Qualifications

Technical Skills

• 5+ years of experience administering IBM Cognos Analytics (or Cognos BI).
• Strong knowledge of Cognos architecture, security, and deployment.
• Proficiency in SQL and understanding of relational data models.
• Experience supporting large enterprise data warehouses.
• Familiarity with Unix/Linux and/or Windows server environments.
• Experience with job scheduling, monitoring, and performance tuning.
• Experience supporting Medicaid, MMIS, or healthcare data environments.
• Understanding of claims, eligibility, provider, and financial data domains.
• Familiarity with HIPAA, CMS, and state Medicaid reporting requirements.

Preferred Qualifications

• Experience with Medicaid Enterprise Data Warehouse or MITA-aligned systems.
• Exposure to T-MSIS reporting and CMS federal submissions.
• Knowledge of DataStage, Informatica, or other ETL tools.
• Experience with cloud environments (AWS, Azure, or GCP).
• ITIL or relevant technical certifications.

Soft Skills

• Strong troubleshooting and analytical skills.
• Ability to communicate technical issues to non-technical stakeholders.
• Attention to detail and strong documentation habits.
• Ability to work in regulated, audit-driven environments.
• Comfortable supporting mission-critical reporting systems.
• Works closely with data warehouse, security, and application teams.
• Subject to background checks and data access agreements due to PHI exposure.
• Support on-call or after-hours maintenance for upgrades or critical issues.