About The Position

The Business Intelligence Developer – Epic Cogito/Caboodle designs, develops, validates, deploys, maintains, and optimizes enterprise analytics solutions using Epic Cogito, Caboodle, Clarity, SQL Server, Reporting Workbench, SlicerDicer, Radar dashboards, and related visualization and data-delivery tools. The role translates clinical, operational, revenue-cycle, financial, quality, and strategic reporting needs into reliable data models, SQL queries, reports, dashboards, extracts, metrics, and self-service analytics. The developer partners with business stakeholders, clinicians, Epic application teams, operational leaders, Finance, Revenue Cycle, Technology Services, vendors, and other Business Intelligence resources to ensure data is accurate, timely, secure, understandable, and actionable. Strong SQL query-development experience and working knowledge of Epic data models, reporting architecture, data governance, testing, and analytics lifecycle management are required. The position supports Epic analytics and data models, SQL development and analysis, reporting and visualization, data validation and quality assurance, requirements intake and stakeholder partnership, healthcare analytics, ETL and data warehouse operations, security and data governance, production support, upgrades, incident resolution, and team collaboration. Epic Cogito certification is required or must be obtained within six months of hire. A bachelor's degree is preferred, though equivalent relevant professional experience may be considered.

Requirements

  • Minimum of 3 years of experience in business intelligence, healthcare analytics, data warehousing, reporting, or SQL development.
  • Demonstrated experience writing and troubleshooting complex SQL queries.
  • Epic Cogito certification is required or must be obtained within six months of hire.
  • Valid driver's license is required for travel to other offices.
  • Ability to apply minimum-necessary access, role-based security, privacy, HIPAA, organizational policy, data-use, and audit requirements.
  • Ability to work with large data sets, competing priorities, tight timelines, sensitive information, and incomplete or changing requirements.
  • Strong analytical, problem-solving, critical-thinking, validation, and attention-to-detail skills.
  • Strong documentation, organization, project/task management, collaboration, facilitation, and customer-service skills.
  • Ability to explain SQL logic, metric definitions, assumptions, and findings to technical and non-technical audiences.
  • Ability to work independently while participating in peer review, shared standards, cross-training, and team accountability.
  • Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Health Informatics, Business Intelligence, Finance, Healthcare Administration, or a related field is preferred; equivalent relevant professional experience may be considered.

Nice To Haves

  • Experience with Epic Cogito, Caboodle, Clarity, Reporting Workbench, SlicerDicer, Radar, Tableau, Power BI, or healthcare data.
  • Epic Caboodle and/or Clarity Data Model certification, required or preferred depending on assigned responsibilities.
  • Additional certification in clinical or revenue-cycle data models, SlicerDicer, Radar, Tableau, Power BI, SQL, or cloud/data platforms.
  • Advanced SQL skills, including joins, subqueries, common table expressions, window functions, aggregations, date logic, temporary tables, views, stored procedures, and query optimization.
  • Working knowledge of Epic Cogito architecture, Caboodle, Clarity, Reporting Workbench, SlicerDicer, Radar, registries, metrics, and relevant clinical or revenue-cycle data models.
  • Experience with SQL Server Management Studio, Tableau, Power BI, Microsoft Fabric, Excel, or other approved analytics tools.
  • Understanding of data warehousing, dimensional modeling, ETL/ELT, data marts, metadata, data lineage, source-to-target mapping, and master-data concepts.
  • Ability to interpret ambulatory, patient-access, scheduling, revenue-cycle, claims, financial, quality, population-health, and value-based-care workflows.

Responsibilities

  • Design, build, configure, test, deploy, maintain, and optimize Epic Cogito analytics solutions, including Caboodle content, SlicerDicer data models, Radar dashboards, Reporting Workbench reports, metrics, and registries.
  • Use Epic standard content where appropriate and create custom reporting solutions when standard tools do not meet validated business requirements.
  • Extend and configure Caboodle content to improve self-service analytics and reduce unnecessary custom-report demand.
  • Support Epic upgrade readiness by reviewing release notes, validating Cogito content, testing data models, and remediating affected reports, dashboards, extracts, and metrics.
  • Maintain documentation for data models, report specifications, dashboard logic, metric definitions, ownership, dependencies, security, and support procedures.
  • Write, review, optimize, and maintain complex SQL queries, stored procedures, views, common table expressions, joins, aggregations, window functions, and data extracts against Epic and approved enterprise data sources.
  • Analyze complex data sets to identify trends, performance opportunities, operational variation, data-quality issues, and actionable insights.
  • Apply query-performance, indexing, filtering, parameterization, and data-volume practices in partnership with database administrators and hosting/support teams.
  • Validate SQL logic and reconcile results to Epic workflows, source transactions, operational expectations, and authoritative reports.
  • Create reusable, governed SQL logic and documented metric definitions; perform peer review and participate in BI code/version-control practices.
  • Gather and document reporting requirements, business rules, intended decisions, audience, data latency, refresh frequency, filters, security, and acceptance criteria.
  • Develop and maintain reports, scorecards, dashboards, extracts, and visualizations using Epic Cogito tools, Tableau, Power BI, SQL Server, or other approved platforms.
  • Design decision-focused visualizations for clinical, operational, executive, financial, revenue-cycle, and quality audiences; optimize existing reporting content for usability, performance, maintainability, adoption, and business value.
  • Monitor report usage and retire, consolidate, or replace duplicative and low-value content in accordance with governance standards.
  • Provide secure data extracts to authorized internal users and third-party vendors using approved technical and privacy controls.
  • Develop and execute unit, integrated, regression, upgrade, performance, and user-acceptance test plans for reports, data models, dashboards, and extracts.
  • Validate completeness, accuracy, timeliness, attribution, numerator and denominator logic, date logic, duplicate handling, joins, exclusions, and workflow interpretation.
  • Partner with subject matter experts and requestors to confirm that results accurately reflect clinical and business processes; investigate discrepancies across Epic and other data sources.
  • Document data-quality defects, root causes, workarounds, remediation, monitoring requirements, and traceability from requirements through testing, approval, deployment, and post-production validation.
  • Serve as a liaison among Business Intelligence, clinical and operational departments, Revenue Cycle, Finance, executive leadership, Epic application teams, vendors, and data owners.
  • Clarify stakeholder questions and assess whether needs can be met through existing reporting or self-service tools, or require a custom solution.
  • Translate workflow and business context into technical specifications, SQL logic, metric definitions, test scenarios, and deliverables; communicate technical concepts and limitations clearly to technical and non-technical audiences.
  • Manage expectations, priorities, timelines, dependencies, and follow-up throughout the analytics-delivery lifecycle.
  • Develop working expertise in relevant Epic clinical, access, revenue-cycle, population-health, quality, and operational data models and understand how workflows affect reporting accuracy and interpretation.
  • Support analytics across patient access, scheduling, referrals, authorization, ambulatory care, surgery, professional billing, claims, denials, physician compensation, quality, value-based care, population health, and organizational performance.
  • Collaborate with Epic application analysts to understand build changes, workflow impacts, master-file configuration, and data implications; identify gaps requiring new models, ETL/data-pipeline work, source-system changes, or vendor support.
  • Partner with Cogito administrators, ETL support, database administrators, hosting vendors, and infrastructure teams to maintain reliable Clarity and Caboodle refreshes and reporting availability.
  • Monitor or review ETL completion, data freshness, load failures, downstream impacts, and reporting availability as assigned; troubleshoot issues involving ETL, schema changes, database performance, source-data quality, interfaces, security, or application build.
  • Support data mappings and transformations for enterprise data warehouses, data marts, local or cloud analytics platforms, and approved third-party extracts; document dependencies, refresh schedules, lineage, support ownership, and recovery procedures.
  • Participate in downtime, recovery, continuity, and reporting-environment data-validation activities.
  • Apply minimum-necessary access, role-based security, privacy, HIPAA, organizational policy, data-use, and audit requirements to reporting and analytics solutions.
  • Protect sensitive clinical, financial, acquisition, physician-compensation, employee, and patient information throughout development, testing, delivery, and support.
  • Participate in data governance involving metric definitions, source-of-truth decisions, data ownership, lineage, quality, retention, and approved use; partner with security teams to implement appropriate access.
  • Maintain documentation and evidence required for audits, access reviews, risk assessments, and compliance inquiries.
  • Monitor and support assigned production reports, dashboards, extracts, and analytics solutions and respond within established service-level expectations.
  • Triage and resolve incidents involving report logic, SQL, performance, security, data refresh, data quality, visualization, or workflow interpretation; coordinate across technical and organizational teams as needed.
  • Support Epic upgrades, maintenance, vendor changes, and platform updates through impact analysis, testing, remediation, validation, and communication.
  • Perform root-cause analysis for recurring failures and implement preventive monitoring, standardized logic, documentation, and support procedures.
  • Participate in after-hours support during upgrades, major releases, or critical reporting incidents as required.
  • Participate in work prioritization, peer review, knowledge sharing, documentation, mentoring, and cross-training within the BI team.
  • Provide reporting and SQL guidance to less experienced analysts and help users interpret Epic data appropriately.
  • Identify opportunities to standardize reporting, expand self-service analytics, reduce duplicate reports, automate manual work, improve query performance, and strengthen data literacy.
  • Contribute to analytics roadmaps, platform lifecycle planning, workload/capacity analysis, governance, and future-state hosting evaluations.
  • Maintain current Epic certifications, proficiency, New Version Training, SQL knowledge, and relevant technical skills; perform other duties as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service