CCL Program Writer - Revenue Cycle Extracts

Most job postings are the same (and can be pretty boring, right?!). That's why we want to start out by telling you what's in it for you:

• We have an amazing platform that maximizes revenue for thousands of healthcare organizations across the country!
• We embrace diversity in a serious way! We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.
• We celebrate and promote career growth and advancement.
• We have an awesome on-demand learning program.
• We do fun stuff like remote Cooking Classes, Yoga Sessions & Mixology Classes because we like to have fun!
• We have cool Peer Nominated Awards & Recognition because we like to celebrate our employees!

We are currently seeking a CCL Program Writer to join our team. The CCL Program Writer owns MDaudit's Cerner CCL extract library the scripts that pull clinical events and charge transactions from client Cerner Millennium environments and feed MDaudit's revenue integrity and audit platform. The role spans the full lifecycle of those extracts: new development as MDaudit adds data sources or product capabilities, ongoing maintenance as Cerner's data model shifts across vendor releases, client-specific localization as new health systems join the portfolio, deployment and install partnership at client sites, and production support when extracts misbehave or downstream ingestion flags an issue.

The work is cross-functional. Internally, as part of the Integrations team the CCL Program Writer partners with MDaudit's ingestion and engineering teams on downstream file format compatibility, with product management on new data sources and client onboarding, with customer success and implementation on install timelines and data configurations, and with compliance and security on PHI handling and BAA conformance. They may occasionally support pre-sales and solutions engineering on prospect calls and feasibility scoping.

Externally, the most important partnership is with the client's own CCL development and Cerner DBA teams they hold compile permissions and schedule access in their domains, and a meaningful part of this role is building enough trust with each client's team that they're comfortable accepting changes from a vendor engineer. The CCL Program Writer coordinates with client revenue cycle, and client IT and infrastructure teams (SFTP configuration, file paths, extracts, etc.).

Essential Duties and Responsibilities Include but not limited to THE FOLLOWING:

• Author and maintain CCL programs for clinical events and charge data extraction (posted charges, suspended charges, surgery, ED, orders, tasks, census, GL audit, and related sources)
• Localize scripts per client domain (current domain, output paths, mbat_common group selection, acuity overrides)
• Deploy at client sites via Citrix Storefront or similar with Visual Discern with DBA compile permissions
• Configure facility and entity setup 
• Schedule and tune ops jobs in Discern Scheduler (Olympus)
• Triage production issues: empty extracts, duplicate output, timing or scheduling conflicts, upgrade-day breakage
• Partner with client CCL developers on installs and changes 
• Document changes through mod-control headers, runbooks, and localization tables
• Coordinate with MDaudit ingestion engineers on file format and column alignment

REQUIRED SKILLS

CCL and Cerner Platform

• Strong Cerner CCL: subroutines, record structures, expand/locateval, select into "nl:", uar_get_code_by, dm_info read/write patterns, GenerateOutput and Addoutput file generation
• Working knowledge of Cerner Millennium tables: clinical_event, encounter, person, orders, surgical_case, charge, charge_event_l*, dm_info, code_value, code_set
• Familiarity with common code sets: 6000 (catalog), 19 (financial class), 10039 (acuity), 72 (note type)
• Ability to read and extend 500+ line existing subroutines without rewriting them

Tooling and Environment

• Visual Discern (IDE), DB Dev / Discern Explorer (interactive queries), DA2 (Discern Analytics 2)
• Discern Scheduler / Olympus for ops job configuration
• Citrix Storefront client access patterns, DBA permission model

Domain Knowledge

• Revenue cycle end-to-end: chargeable clinical event ? posted charge ? bill ? claim
• Charge capture flow: posted vs suspended vs interfaced charges
• Cerner Patient Accounting vs third-party PA, and which extracts apply at each
• Clinical workflows: surgery, ED, orders, tasks, census, anesthesia, chargemaster basics
• HIPAA and HITRUST compliance baseline; sound judgment handling PHI under client BAAs

Soft Skills

• Collaborative engagement style with client CCL teams 
• Clear written documentation: mod-control headers, runbooks, change notes
• Comfortable explaining technical decisions to revenue cycle and HIM stakeholders
• Constructive alignment when client requests would compromise extract integrity

Education and Experience

• Cerner CCL Subject Matter Expert
• Prior experience at a Cerner PA hospital or in a Cerner consulting practice
• Oracle PL/SQL exposure