Business Intelligence Developer – Epic Cogito/Caboodle
- Hiring from
- United States
- Work type
- Hybrid
- Posted
624,664 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
The Business Intelligence Developer – Epic Cogito/Caboodle is responsible for designing, developing, validating, deploying, maintaining, and optimizing enterprise analytics solutions using Epic Cogito, Caboodle, Clarity, SQL Server, Reporting Workbench, SlicerDicer, Radar dashboards, and related visualization and data-delivery tools. This 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. The position requires strong SQL query-development experience and working knowledge of Epic data models, reporting architecture, data governance, testing, and analytics lifecycle management.
Responsibilities:
Epic Cogito and Caboodle Development
- Design, build, configure, test, deploy, maintain, and optimize Epic Cogito analytics solutions, including Caboodle-based content, SlicerDicer data models, Radar dashboards, Reporting Workbench reports, metrics, registries, and other Cogito components.
- Use Epic standard content where appropriate and develop 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 new or changed Cogito content, testing data models, and remediating affected reports, dashboards, extracts, and metrics.
- Maintain current documentation of data models, report specifications, dashboard logic, metric definitions, ownership, dependencies, security, and support procedures.
SQL Query Development and Data Analysis
- Write, review, optimize, and maintain complex SQL queries, stored procedures, views, common table expressions, joins, aggregations, window functions, and data extracts against Epic Caboodle, Clarity, and approved enterprise data sources.
- Analyze large and complex data sets to identify trends, performance opportunities, operational variation, data-quality issues, and actionable insights.
- Apply appropriate 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 other authoritative reports.
- Create reusable, governed SQL logic and documented metric definitions to improve consistency across dashboards, extracts, and reports.
- Perform peer review of SQL and reporting logic and participate in code/version-control practices established by the BI organization.
Reporting, Dashboards, and Visualization
- 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 understandable and decision-focused visualizations for clinical, operational, executive, financial, revenue-cycle, and quality audiences.
- Optimize existing reports and dashboards 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.
Data Validation and Quality Assurance
- 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, denominator/numerator logic, date logic, duplicate handling, joins, exclusions, and workflow interpretation.
- Partner with subject matter experts and report requestors to confirm that results accurately reflect clinical and business processes.
- Investigate discrepancies among Epic operational reports, Clarity, Caboodle, SlicerDicer, Tableau, Power BI, financial systems, and other sources.
- Document data-quality defects, root causes, workarounds, remediation, and ongoing monitoring requirements.
- Ensure changes are traceable to requirements, testing evidence, approvals, deployment, and post-production validation.
Analytics Intake, Requirements, and Stakeholder Partnership
- Serve as a liaison among Business Intelligence, clinical and operational departments, Revenue Cycle, Finance, executive leadership, Epic application teams, vendors, and other data owners.
- Clarify the question a stakeholder is trying to answer before selecting the data source, reporting method, or visualization.
- Assess whether needs can be met through existing Reporting Workbench, Radar, SlicerDicer, dashboards, self-service content, or a new custom solution.
- Translate workflow and business context into technical specifications, SQL logic, metric definitions, test scenarios, and deliverables.
- Communicate technical concepts, limitations, assumptions, data latency, and interpretation in clear language for technical and non-technical audiences.
- Manage expectations, priorities, timelines, dependencies, and follow-up throughout the analytics-delivery lifecycle.
Epic Data Models and Healthcare Analytics
- Develop working expertise in relevant Epic clinical, access, revenue-cycle, population-health, quality, and operational data models.
- Understand how data is captured in Epic workflows and how workflow variation affects reporting accuracy and interpretation.
- Support analytics for 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.
- Use Caboodle and SlicerDicer capabilities to expand governed self-service analytics where feasible.
- Identify analytics gaps requiring new data models, ETL/data-pipeline work, source-system changes, or vendor support.
ETL, Data Warehouse, and Technical Operations
- 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 reporting issues caused by ETL delay, schema change, database performance, source-data quality, interface failure, access/security, or application build.
- Support mapping specifications and data transformations for enterprise data warehouses, data marts, local or cloud analytics platforms, and approved third-party extracts.
- Document upstream and downstream dependencies, refresh schedules, data lineage, support ownership, and recovery procedures.
- Participate in downtime, recovery, continuity, and data-validation activities for reporting environments.
Security, Privacy, and Data Governance
- Apply minimum-necessary access, role-based security, privacy, HIPAA, organizational policy, data-use, and audit requirements to all 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 activities involving metric definitions, source-of-truth decisions, data ownership, lineage, quality, retention, and approved use.
- Partner with Identity and Access Management and Epic Security teams to implement appropriate report, dashboard, data-model, database, and extract access.
- Maintain documentation and evidence required for audits, access reviews, risk assessments, and compliance inquiries.
Production Support, Upgrades, and Incident Resolution
- 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 with Epic, hosting/support vendors, database administrators, application analysts, and third parties when issues cross technical or organizational boundaries.
- Support Epic upgrades, monthly 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.
Team Collaboration and Continuous Improvement
- 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 support users in interpreting 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.
Education required:
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.
Experience required:
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 is required. Experience with Epic Cogito, Caboodle, Clarity, Reporting Workbench, SlicerDicer, Radar, Tableau, Power BI, or healthcare data is strongly preferred.
Professional license or certification requirements:
Epic Cogito certification is required or must be obtained within six months of hire. Epic Caboodle and/or Clarity Data Model certification is required or preferred based on assigned responsibilities. Additional certification in clinical or revenue-cycle data models, SlicerDicer, Radar, Tableau, Power BI, SQL, or cloud/data platforms is preferred. Valid driver’s license is required for travel to other offices.
Preferred Skills:
- Advanced SQL query-development and troubleshooting 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.
- Strong analytical, problem-solving, critical-thinking, validation, and attention-to-detail skills.
- Ability to explain SQL logic, metric definitions, assumptions, and findings to technical and non-technical audiences.
- Ability to work with large data sets, competing priorities, tight timelines, sensitive information, and incomplete or changing requirements.
- Strong documentation, organization, project/task management, collaboration, facilitation, and customer-service skills.
- Ability to work independently while participating in peer review, shared standards, cross-training, and team accountability.
