Business Intelligence Developer II

Job Summary: Under general supervision, the Business Intelligence Developer II independently designs, develops, tests, and deploys data visualization and reporting solutions for a large, multi‐facility healthcare system. Applies established methods and professional judgment to moderately complex assignments, managing individual projects from requirements gathering through deployment with limited oversight. The solutions delivered by this role inform operational, clinical, and financial decision‐making for departments and service lines across the health system.Exercises judgment within defined practices and organizational policies to resolve routine and moderately complex technical problems. Proactively identifies data quality issues, recommends improvements to existing reports, and adapts standard approaches to meet evolving stakeholder needs. Decisions and recommendations are reviewed on an exception basis by the supervisor. The scope of accountability is project‐level, encompassing end‐to‐end delivery of assigned reporting solutions.At this level, provides informal guidance to Developer I staff on routine tasks. Operates within one of three platform tracks: Epic Cogito (native reporting toolset), Epic SQL (SQL‐based reporting against Clarity/Caboodle with visualization tools), or Oracle Fusion Reporting. At this l

Qualifications

Education: Required: Bachelor’s degree in Information Technology, Health Informatics, Computer Science, Business Administration, Data Analytics, or a related field.Equivalent: Associate’s degree in a related field plus four (4) years of directly relevant progressive experience in healthcare BI, reporting, or data visualization may substitute for the Bachelor’s degree requirement.

License & Cert: Epic Cogito TrackRequired: Active Epic Cogito Fundamentals certification.Required: At least one (1) additional Epic reporting or application module certification (e.g., Caboodle Data Model, Cogito Tools Administration, or a clinical/revenue cycle module certification relevant to assigned reporting domain).Preferred: Additional Epic module certifications to broaden cross‐application reporting capability.Epic SQL TrackRequired: Active Epic Clarity Data Model certification and reporting domain Data Model certification (e.g., Access, Clinical, or Revenue Cycle).Required: Epic Caboodle Data Model certification (or obtained within 90 days of hire).Preferred: Microsoft Power BI Data Analyst Associate, Tableau Desktop Certified Professional, or equivalent visualization platform certification.Preferred: Epic Caboodle Development for Clarity Data certification.Oracle Fusion TrackRequired: Oracle Cloud Infrastructure Foundations Associate certification.Preferred: Oracle Fusion Cloud General Ledger Certified Implementation Specialist (1Z0‐1054) or Oracle Fusion Cloud Payables Certified Implementation Specialist (1Z0‐1055).Preferred: Certification in a complementary visualization tool (e.g., Power BI Data Analyst Associate) if applicable to organizational reporting architecture. 

Experience: Required: Two (2) to five (5) years of progressive experience in business intelligence, reporting, data visualization, or a closely related field.Required: At least one (1) year of experience in a healthcare environment, including demonstrated familiarity with clinical, financial, or operational data structures.Required: At least one (1) year of hands‐on experience with the assigned platform track (Epic Cogito, Epic Clarity/Caboodle/SQL, or Oracle Fusion reporting tools).

Other Qualifications: Epic Cogito TrackProficient in Epic’s native Cogito toolset, including independent design and configuration of Reporting Workbench reports, SlicerDicer sessions, and Radar Dashboards. Proficient in supporting end users on the Sigma platform and developing ability to build basic Sigma workbooks to complement Cogito native reporting. Ability to configure, test, and deploy both Epic‐released and custom‐developed reporting content across multiple Epic applications. Working knowledge of SQL (SELECT, JOIN, WHERE, GROUP BY, subqueries) as applied to Cogito data extraction and validation; SQL is a growing but supplemental proficiency at this level. Familiarity with Epic Chronicles data structures and the relationship between Cogito reporting tools and underlying data models. Foundational awareness of Databricks as an emerging enterprise data platform and its complementary role alongside Chronicles, Clarity, and Caboodle.Epic SQL TrackProficient in writing intermediate‐to‐advanced SQL queries against Epic Clarity and Caboodle databases, including complex joins across multiple tables, subqueries, common table expressions (CTEs), and aggregate functions. Demonstrated ability to design and develop interactive data visualizations in Tableau, Power BI, or Sigma Computing with a focus on user experience and data s