DeveloperJobs.io
← Back to all jobs

Job Description

Oracle Health’s AMS Custom Reporting team builds and supports custom reporting capabilities used by clients and internal stakeholders. In this onsite role in Kansas City, you’ll develop, debug, test, document, and maintain report features, with a focus on SQL queries and CCL programs within Oracle Health Millennium.

You’ll also provide production support for reporting, troubleshoot failures and incorrect results, and partner with clients to refine requirements for releases. The work connects report logic to database structures, performance tuning, and dependable delivery in controlled patient-data workflows.

What you’ll do

  • Develop and maintain CCL programs and SQL queries for custom reports in Oracle Health Millennium.
  • Work with clients to clarify report requirements, including data fields, filters, parameters, calculations, and output formats.
  • Identify the database tables, relationships, and query logic required to retrieve report data.
  • Document report logic, data sources, parameters, and dependencies so other developers can support and maintain reports.
  • Test report results against requirements and source data, checking for incorrect calculations, missing records, and duplicate results.
  • Investigate slow-running reports and optimize SQL queries and CCL code.
  • Review report code and coordinate testing and releases with the team and clients.
  • Verify reports continue to work after relevant application or database changes.
  • Follow approved procedures for accessing patient data and handling report outputs during development, testing, and support.
  • Provide business-hours support for custom reports and participate in assigned incident rotations with guidance.
  • Investigate report failures and incorrect results by reviewing logs, querying database tables, examining CCL and SQL code, and reproducing user report inputs and workflows.
  • Develop and test fixes, then work with clients to confirm that issues are resolved.
  • Document investigation steps, findings, and resolutions, and create knowledge articles for recurring reporting issues.
  • Prioritize report requests and defects by severity, urgency, and client impact.
  • Communicate progress and escalate issues that require additional expertise or involvement from another team.

Required experience and skills

  • Experience developing, debugging, testing, documenting, and maintaining application features, SQL queries, CCL programs, and custom reports according to established requirements and design specifications.
  • Ability to test report results against requirements and source data, including validation for incorrect calculations, missing records, and duplicate results.
  • Ability to investigate slow-running reports and optimize SQL and CCL code.
  • Ability to coordinate testing and releases with the team and clients, including verifying report functionality after application or database changes.
  • Ability to follow approved procedures for accessing patient data and handling report outputs during development, testing, and support.
  • Ability to provide business-hours support for custom reports and participate in incident rotations with guidance.
  • Ability to investigate report failures and incorrect results by reviewing logs, querying database tables, examining CCL and SQL code, and reproducing user inputs and workflows.
  • Ability to develop and test fixes and work with clients to confirm reported issues are resolved.
  • Ability to document investigation steps, findings, and resolutions, and create knowledge articles for recurring issues.

Technologies

  • SQL
  • CCL
  • Oracle Health Millennium

Experience level

  • SD1: 0–2 years (SQL/CCL Experience); 0–2 years (Database Management Experience)
  • SD2: 1–3 years (SQL/CCL Experience); 1–3 years (Database Management Experience)

Location: Kansas City, MO (onsite)

Similar Jobs