About the position Under limited supervision, the EHR Business Analyst II is responsible for designing, developing, validating, and maintaining Electronic Health Record (EHR) reporting solutions. While reporting and analytics are the primary focus of this role, the position may also contribute to build, configuration, and ongoing support for clinical, financial, and administrative components of the EHR. The analyst uses tools such as Oracle Analytics, SAP Business Objects, Cerner Discern Analytics, and Cerner Command Language (CCL) to support the organization’s operational, clinical, and public health reporting needs. Responsibilities include report development, troubleshooting, system documentation, user support, and cross -functional collaboration to ensure reporting and application workflows meet business and regulatory requirements.

Responsibilities

• Design, build, test, and maintain EHR reports and dashboards supporting clinical, financial, operational, and public health program areas.
• Use Oracle Analytics, SAP Business Objects, Cerner DA2, and CCL to develop, validate, and optimize reporting solutions.
• Gather and analyze reporting requirements and translate business needs into accurate and actionable technical specifications.
• Maintain and enhance existing reporting assets, data models, and data logic within the EHR environment.
• Provide technical support and troubleshooting for reporting components, ensuring data accuracy, timely delivery, and system reliability.
• Contribute to EHR build and maintenance activities as needed, including configuration changes, workflow updates, and support for clinical, financial, and administrative modules.
• Collaborate with application teams, operations, IT, and program stakeholders to align reporting and application workflows with organizational standards.
• Participate in system upgrades, regression testing, data validation activities, and changes related to reporting or module configuration.
• Serve as a subject matter resource on reporting best practices and provide mentorship on advanced analytics tools and techniques.
• Assist with architectural design decisions, promote standardization across analytics tools, and participate in cross-team technical planning.
• Prepare and maintain comprehensive system documentation, including report inventories, specifications, logic definitions, and operational procedures.
• Provide backup support for other EHR analysts and related public health applications as assigned.
• Assist with performance tuning, data quality improvements, and optimization of reporting processes.
• Perform other duties as assigned related to the position.

Requirements

• A high school diploma and experience in computer system development and modification.
• A bachelor's degree in a related area may substitute for the required work experience.
• Knowledge of information systems design, testing, debugging, analysis, maintenance and security techniques.
• Ability to establish working relationships with management, committee / work team members, and customers.
• Ability to communicate effectively both orally and in writing.
• Any equivalent combination of education and/or experience that demonstrates the required knowledge, skills, and abilities may be considered in meeting the minimum qualifications, subject to approval by the DPH Chief Human Resources Officer, or their delegate.

Nice-to-haves

• Oracle/Cerner EHR systems, Cerner Reporting Portal, SAP Business Objects, Discern Analytics 2, and CCL Experience Preferred.

Benefits

• 15 days Annual (Vacation) Leave per year
• 15 days Sick Leave per year
• 13 Paid Holidays
• Paid Parental Leave
• Health, dental, vision, long-term disability, and life insurance for employees, spouse, and children.
• S.C. Deferred Compensation Program available
• Retirement benefit choices
• State Retirement Plan (SCRS)
• State Optional Retirement Program (State ORP)