Job Description:
As EHR Data Transformation Lead, you''ll be the technical bridge between clinical stakeholders and IT delivery teams. This role combines healthcare domain knowledge, Cerner expertise, and software engineering to ensure clinical workflows are accurately translated into data extraction, reporting, and analytics solutions.
Core Responsibilities
• Assess and document clinical workflows across inpatient, outpatient, and ancillary care environments; translate operational requirements into
technical specifications
• Design, develop, test, optimize, and maintain Cerner Command Language (CCL) scripts and data extraction logic within Cerner Millennium
production environments
• Perform complex data extraction, validation, and reconciliation from Cerner Millennium Oracle database schemas; ensure data integrity across
migrations
• Support enterprise-wide EHR data migration, reporting modernization, and legacy system retirement initiatives
• Develop, maintain, and troubleshoot structured data feeds, flat file extracts, and ETL (Extract-Transform-Load) processes
• Diagnose and resolve CCL performance issues, data integration failures, and downstream reporting challenges
• Execute, tune, and optimize CCL scripts; manage batch jobs in production and non-production environments
• Act as technical liaison between clinical informatics teams and delivery teams to ensure clinical requirements are accurately implemented
• Communicate technical constraints, data limitations, and system dependencies to non-technical clinical and business stakeholders
You are the ideal candidate if you:
• Are a Cerner Command Language (CCL) expert with 5+ years of hands-on development experience in production Cerner Millennium environments
• Understand healthcare operations and clinical workflows and can translate them into technical requirements without translation losses
• Have shipped mission-critical data transformations as part of large-scale EHR implementations or migrations
• Are comfortable working at the intersection of clinical, operational, and technical concerns
• Possess strong data integration skills and are comfortable working with SQL, Linux, ETL tools, and Oracle databases
• Can troubleshoot complex performance issues and are experienced in optimizing code, queries, and batch processes
• Are excellent communicators able to explain technical constraints and system limitations to clinical and non-technical audiences
• Have experience in government healthcare environments or working on mission-critical healthcare systems
MUST HAVE
11 Required Strong understanding of clinical workflows and healthcare operations.
11 Required Demonstrated experience supporting large scale EHR implementations, migrations, or optimization initiatives.
11 Required Proven ability to translate clinical requirements into technical and data specifications.
11 Required Advanced, hands on experience with Cerner Command Language (CCL).
11 Required Working knowledge of Cerner Millennium architecture and Oracle databases
11 Required Experience with SQL, Linux, and enterprise data extraction or migration patterns.
11 Required Experience designing and supporting ETL processes.
11 Required Familiarity with healthcare data integrations and reporting environments.
11 Required Experience with REST / SOA development.
11 Required Knowledge of distributed systems, networking, and performance tuning.
11 Required Experience writing, executing, and tuning CCL scripts in production environments.
11 Required Experience with data extraction, system integration, and code development.
11 Required Working knowledge of one or more of the following: Java, C, C++, Python, Perl, OCI.
11 Required Hands-on experience developing or supporting services on public cloud platforms (AWS, Azure, Google Cloud Platform, OCI).
PREFERRED
11 Preferred Experience supporting Cerner Millennium environments.
11 Preferred Prior experience serving as a senior Cerner consultant or technical lead.
Never miss an opportunity! Create an alert based on the job you applied for.
