Epic Reporting AnalystClient 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 SLAsDesign, develop, and maintain SSIS packages for data extraction, transformation, and loading between Epic and downstream systemsBuild and optimize SQL queries, stored procedures, and views for reports and ad hoc analysesDevelop and maintain Cogito analytics content: Report Workbench reports, operational dashboards, and analytics catalog itemsMonitor ETL pipeline health and SSIS job scheduling; troubleshoot failures and perform root cause analysisValidate report outputs and perform data quality assurance on clinical and operational dataTranslate stakeholder requirements into technical specs; liaise across clinical, operational, and technical teamsCoordinate with offshore support teams; maintain documentation and ensure HIPAA and data governance complianceTop 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)