Application Software Engineer 2

Oracle

Kansas City (MO)

On-site

USD 74,000 - 148,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Oracle Health’s AMS Custom Reporting team seeks a software professional to develop and maintain custom reports. You will write SQL queries and CCL programs, debug, test, and document reporting solutions within client environments.

The role blends software development with production support and client collaboration, requiring clear communication and thorough troubleshooting to balance client needs with project priorities.

Qualifications

  • Experience developing CCL programs and SQL queries for reports.
  • Ability to clarify report requirements with clients.
  • Experience in testing, troubleshooting, and optimizing reports.

Responsibilities

  • Develop and maintain CCL programs and SQL queries for Oracle Health Millennium reports.
  • Clarify report requirements with clients, including data fields, filters, parameters, calculations, and output formats.
  • Identify the database tables, relationships, and query logic needed to retrieve the required data.
  • Document report logic, data sources, parameters, and dependencies so other developers can support and maintain the reports.
  • Test report results against requirements and source data; investigate slow-running reports and optimize queries.
  • Review report code and coordinate testing and releases with the team and clients; ensure changes don’t break reports.
  • Follow procedures for accessing patient data and handling report outputs during development, testing, and support.
  • Provide incident rotations with guidance and document investigations and resolutions.

Skills

SQL
CCL programming
Report development
Documentation

Tools

SQL
CCL

Job description

  • Does this position require a security clearance? Yes
  • Years 3 to 5+ years
  • Additional Info Visa / work permit sponsorship is not available for this position
  • Applicants are required to read, write, and speak the following languages English
Job Description

Help advance how health happens through technologies that empower patients, support clinicians, and improve the healthcare experience.

As a member of the AMS Custom Reporting team, you will contribute to software development and custom reporting projects within Oracle Health client environments. You will develop, debug, test, document, and maintain application features, SQL queries, CCL programs, and custom reports in accordance with established requirements and design specifications.

This role combines software development, database knowledge, production support, and client collaboration. Clear communication, effective troubleshooting, and the ability to balance client and business priorities are essential. The complexity of assigned work and level of independence will align with the position’s experience level.

Responsibilities
Key Responsibilities
Report Development and Maintenance
  • Develop and maintain CCL programs and SQL queries for custom reports in Oracle Health Millennium.
  • Clarify report requirements with clients, including data fields, filters, parameters, calculations, and output formats.
  • Identify the database tables, relationships, and query logic needed to retrieve the required data.
  • Document report logic, data sources, parameters, and dependencies so other developers can support and maintain the reports.
Testing, Performance, and Releases
  • 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 that 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.
Report Support and Troubleshooting
  • 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 users’ report inputs and workflows.
  • Develop and test fixes, and work with clients to confirm that reported issues are resolved.
  • Document investigation steps, findings, and resolutions. Create knowledge articles for recurring reporting issues.
  • Prioritize report requests and defects by severity, urgency, and client impact. Communicate progress and elevate issues that require additional expertise or another team’s involvement.
Qualifications

Disclaimer:
Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.
Range and benefit information provided in this posting are specific to the stated locations only
US: Hiring Range in USD from: $74,100 to $148,300 per annum. May be eligible for bonus and equity.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
Oracle US offers a comprehensive benefits package which includes the following:

  • 1. Medical, dental, and vision insurance, including expert medical opinion
  • 2. Short term disability and long term disability
  • 3. Life insurance and AD&D
  • 4. Supplemental life insurance (Employee/Spouse/Child)
  • 5. Health care and dependent care Flexible Spending Accounts
  • 6. Pre-tax commuter and parking benefits
  • 7. 401(k) Savings and Investment Plan with company match
  • 8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
  • 9. 11 paid holidays
  • 10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
  • 11. Paid parental leave
  • 12. Adoption assistance
  • 13. Employee Stock Purchase Plan
  • 14. Financial planning and group legal
  • 15. Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
As part of Oracle's onboarding process and consistent with applicable law, US-based employees are required to complete identity verification, which involves the collection and processing of their biometric information. Accommodations to this requirement may be granted following an individualized assessment.

Experience by Position Level
SQL/CCL Experience
Database Management Experience

SD1 0–2 years 0–2 years

SD2 1–3 years 1–3 years

About Us

Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.

True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling 1-888-404-2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

Request a referral from an Oracle employee.

See who works here

Sign in to see your connections who work at Oracle

Page Application Software Engineer 2 - Oracle Careers loaded

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Application Software Engineer
Application Software Engineer

Oracle • Kansas City (MO)

On-site
USD 74,000 - 148,000
Medical, dental, and vision insurance
401(k) Savings and Investment Plan
Paid time off
+3
Consulting Software Developer - CCL - Oracle Health
Consulting Software Developer - CCL - Oracle Health

Oracle Corporation • United States

On-site
USD 35,000 - 88,000
Software Developer
Software Developer

Oracle Corporation • Nashville (TN)

On-site
USD 97,000 - 210,000
Healthcare Integration Architect
Healthcare Integration Architect

Oracle • United States

On-site
USD 52,000 - 132,000
Medical, dental & vision
401(k) plan
Paid time off
+2
Senior Backend Engineer - AI-First Platform
Senior Backend Engineer - AI-First Platform

Oracle Corporation • United States

On-site
USD 89,000 - 210,000
Medical insurance
Dental insurance
Vision insurance
+3
Senior Security Engineer
Senior Security Engineer

Oracle Corporation • Nashville (TN)

On-site
USD 82,000 - 187,000
Lead Clinical Informaticist
Lead Clinical Informaticist

Oracle • Kansas City (MO)

On-site
USD 102,000 - 210,000
Support Engineer 1
Support Engineer 1

Oracle Corporation • United States

On-site
USD 29,000 - 62,000
Medical, dental, and vision insurance
401(k) Savings and Investment Plan
Paid time off (vacation)
+2
Senior Consultant - Health Information Management
Senior Consultant - Health Information Management

Oracle Corporation • United States

On-site
USD 53,000 - 132,000
Medical/Dental/Vision
401(k) match
Paid time off
+1
Manager, Platform Software Engineering
Manager, Platform Software Engineering

Inside • United States

On-site
USD 116,000 - 264,000