Epic Cogito Reporting Analyst

Job Title: Epic Cogito Reporting Lead Analyst Location: Cedar Rapids, IA 52402 (Remote) Duration: Contract - 12 months Job Description We are seeking an Epic Cogito Reporting Lead Analyst to serve as the subject matter expert for Epic’s analytics and reporting suite. The role focuses on SSIS-based ETL development, Epic Cogito reporting build across Report Workbench and Operational Reporting, and cross-functional collaboration to deliver reliable, production-grade reporting solutions that meet clinical and operational needs. Responsibilities: • Serve as SME for Epic Cogito and provide daily support, resolving incidents within SLAs. • Design, develop, and maintain SSIS packages for ETL between Epic and downstream systems. • Build and optimize SQL queries, stored procedures, and views for reports and ad hoc analyses. • Develop and maintain Cogito content including Report Workbench, operational dashboards, and catalog items. • Monitor ETL pipeline health and SSIS job schedules, 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 specifications and partner with clinical, operational, and technical teams. • Coordinate with offshore support teams, maintain documentation, and ensure HIPAA and data governance compliance. Required Skills & Qualifications: • 4+ years of Epic Cogito reporting and healthcare data management experience. • Active Epic Cogito certification required and maintained during employment. • 3–5+ years of SSIS/ETL development, including control flow, data flow, error handling, and deployment. • Advanced SQL Server skills: complex queries, stored procedures, CTEs, indexing, and performance tuning. • Experience with SQL Server Agent for job scheduling and production support, and SSMS/Visual Studio (SSDT) for SSIS. • Healthcare industry experience with clinical and operational workflows and HIPAA compliance. Preferred Skills: • Epic Clarity and/or Caboodle experience as ETL sources; understanding of healthcare data models. • Caboodle and data warehousing concepts: fact/dimension modeling, ETL pipelines, and data architecture. • SlicerDicer configuration and additional Epic Reporting certifications such as Clarity Data Model or Caboodle. Why BCforward? At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to: • Competitive compensation and benefits. • Opportunities for growth with global clients. • A supportive, inclusive culture that values innovation and people. • Exposure to cutting-edge technologies and projects. About Our Commitment BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.