Overview
Skills
Job Details
Key Responsibilities
Report Migration
o Lead the conversion and migration of Cognos ReportNet/BI reports into Power BI, ensuring performance, accuracy, and usability improvements.
o Redesign legacy reports into modern, interactive dashboards aligned with stakeholder requirements.
Data Modeling & Architecture
o Design and maintain Power BI semantic models optimized with star schema (fact/dimension) structures.
o Evaluate when to apply snowflake schema for normalized dimensions and performance tuning.
o Ensure models are scalable, high-performing, and aligned with BI governance standards.
Power BI Development
o Build and manage datasets and dataflows (Gen2) within Power BI/Fabric, enabling incremental refresh and large-scale data ingestion.
o Develop advanced DAX measures, calculated groups, and calculation items (via Tabular Editor) to support reusable time intelligence and reduce redundancy.
o Create dashboards, KPIs, and visualizations that are intuitive, accurate, and aligned with clinical/business needs.
Stakeholder Collaboration
o Partner with healthcare users to gather requirements and define key clinical and operational KPIs.
o Produce wireframes/mockups to validate dashboard design before development.
o Translate complex data into clear insights for non-technical audiences.
Data Integration & Governance
o Support integration of data from Epic (EHR), EMR, claims systems, and ERP platforms.
o Collaborate with data engineers and architects to ensure proper ETL, pipelines, and governance.
o Monitor and optimize scheduled refreshes and data pipelines.