Cognos Reports Developer (Must have Framework Manager and Healthcare Insurance Industry Experience)

Role: Sr. Cognos Reports Developer with Framework Manager and Healthcare Insurance experience

Duration: Long term

Location: Remote, 

Client: Healthcare Insurance

Position Summary
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.

Key Responsibilities

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

Required Qualifications

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

Thanks 

John

Netstrive Consulting, LLC

450, E. 22^nd St, Suite 178,

Lombard, IL 60148

Direct:

Desk No: Ext-404

Fax:

Web: 

Email: 

Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our mailing list.