Epic Reporting Analyst

Epic Reporting Analyst

Client is seeking an Epic Cogito Reporting Lead Analyst to serve as a subject matter expert for Epic's analytics and reporting suite. The team focuses on delivering production-grade data solutions by executing ETL development and Cogito reporting builds to meet clinical and operational needs. This role collaborates closely across clients, Epic stakeholders, and offshore support teams to maintain data pipelines and ensure high-governance reporting standards.

Day-to-day responsibilities include:

• Serve as SME for Epic Cogito; provide daily support and resolve incidents per defined SLAs
• Design, develop, and maintain SSIS packages for data extraction, transformation, and loading between Epic and downstream systems
• Build and optimize SQL queries, stored procedures, and views for reports and ad hoc analyses
• Develop and maintain Cogito analytics content: Report Workbench reports, operational dashboards, and analytics catalog items
• Monitor ETL pipeline health and SSIS job scheduling; troubleshoot failures and perform root cause analysis
• Validate report outputs and perform data quality assurance on clinical and operational data
• Translate stakeholder requirements into technical specs; liaise across clinical, operational, and technical teams
• Coordinate with offshore support teams; maintain documentation and ensure HIPAA and data governance compliance

Top three required skills include:

• Epic Cogito Reporting (including Report Workbench, Operational Reporting, and an active Epic Cogito Certification) (4+ years)
• SSIS / ETL Development (designing/maintaining packages, control flow, data flow, error handling, and deployment) (3–5+ years)
• Advanced SQL Server (complex queries, stored procedures, CTEs, indexing, performance tuning, and SQL Server Agent) (4+ years)