Cognos Reports Developer with Framework Manager

NetStrive Consulting

Lombard, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Cerner Data Analysis Health Informatics Cloud Computing Information Systems Databases Data Governance Extract Transform Load (ETL) Data Profiling Database Queries Database Storage Structures IBM InfoSphere DataStage

+16 more

IBM Cognos Business Intelligence Metadata Microsoft SQL Server Oracle Databases Performance Tuning SQL Databases Systems Integration Azure Data Factory Sql Optimization Snowflake Electronic Medical Records Information Technology Data Analytics Epic Clarity Epic Caboodle Allscripts

Job description

Role: Sr. Cognos Reports Developer with Framework Manager and Healthcare Insurance experience, We are seeking a highly skilled Cognos Developer with deep expertise in Framework Manager to join our healthcare analytics team. In this role, you will be responsible for designing, developing, and maintaining complex reporting solutions that empower our clinicians and administrators to make data-driven decisions. You will bridge the gap between complex healthcare data sources (EHR, Claims, Billing) and intuitive end-user insights, ensuring our metadata models are scalable, high-performing, and HIPAA-compliant., * Metadata Modeling: Lead the design and development of robust metadata models in Framework Manager, including physical, business, and presentation layers.

Report & Dashboard Development: Create sophisticated reports, active reports, and interactive dashboards using Cognos Analytics (v11.x/12.x) Report Studio and Dashboarding.
Healthcare Data Integration: Navigate and query complex healthcare schemas (e.g., Epic Clarity/Caboodle, Cerner, or Allscripts) to extract meaningful KPIs like Patient Readmission Rates, HCAHPS scores, and RVUs.
Performance Tuning: Optimize report performance and SQL queries to handle large-scale healthcare datasets efficiently.
Data Governance: Ensure all reporting solutions adhere to HIPAA regulations and internal data security policies.
Stakeholder Collaboration: Work closely with clinical leads and financial analysts to translate “medical speak” into technical requirements.

Requirements

Experience: 5+ years of dedicated experience in IBM Cognos development.
Technical Mastery: Proven track record with Cognos Framework Manager (DMR modeling, star schemas, and snowflake schemas).
SQL Proficiency: Advanced SQL skills for data profiling, troubleshooting, and complex joins across disparate healthcare databases.
Industry Knowledge is a plus: Minimum 2 years of experience working in a Healthcare environment with a solid understanding of clinical workflows or healthcare financial cycles.
Education: Bachelor’s degree in Computer Science, Health Informatics, Information Systems, or a related field.

Preferred Skills & Certifications

Experience: Direct experience with EMR database structures.
ETL Knowledge: Familiarity with DataStage or Informatica is a major plus.
Cloud Awareness: Experience with Cognos on Cloud or integrating with Snowflake/Azure data lakes.
Soft Skills: A “detective” mindset-the ability to look at a data discrepancy and hunt down the root cause in the source system.

Technical Environment

BI Suite: IBM Cognos Analytics 11.2/12
Modeling: Framework Manager, Data Modules
Database: Oracle, SQL Server, Snowflake
Domain: Population Health, Revenue Cycle Management (RCM), Clinical Quality Measures.