"Alerted.org

Description

Robert Half is seeking an Application Systems Analyst - PL/SQL

Responsibilities include but are not limited to:

Formulates and defines system scope and objectives through research and fact-finding to develop or modify moderately complex information systems. Prepares detailed specifications from which programs will be written. Analyzes and revises existing system logic difficulties and documentation as necessary. Competent to work on most phases of applications systems analysis activities, but requires instruction and guidance in other phases.

Provides detailed support for definition/refinement of business requirements and for quality assurance/acceptance testing efforts Designs, develops, tests and debugs software components of moderate complexity Provides implementation, production and upgrade support for software components of moderate complexity May act as supporting liaison between the application team and the user community, responsible for facilitating communications, coordinating system enhancements, and providing production support. Works with user community to define business requirements in sufficient detail and define business use cases that systems configuration, development/enhancement, and/or Operations activities can be pursued. Develops internal IT, user and Operations documentation to allow for smooth operations and easy system maintenance.

•Design, develop and maintain PL/SQL stored procedures, functions and packages to process HIPAA 278 (Healthcare Services Review - Request for Review and Response) authorization data.

•Analyze and translate business requirements into functional and technical specifications with a strong focus on data transformation and integration logic.

•Create and optimize complex SQL queries for data extraction, validation and performance tuning, ensuring accuracy and efficiency in authorization workflows.

•Collaborate with Business Analysts, EDI specialists, and other technical teams to implement enhancements and resolve issues within existing systems and processes.

•Perform unit testing, participate in peer code reviews, and support QA and UAT efforts for application changes and new implementations.

•Provide production support for existing PL/SQL solutions, troubleshoot incidents, and ensure timely resolution of data processing errors or anomalies.

•Maintain technical documentation for all developed components, processes, and procedures.

•Stay informed on HIPAA standards, especially related to X12, and apply domain knowledge to improve solution design and integrity.

•Participate in Agile or Waterfall development lifecycles as applicable, managing tasks effectively within sprint or release timelines.

Other duties as needed

Requirements

Interviews are currently being conducted, for immediate consideration please apply

The success Applications Systems Analyst will have:

Bachelor s degree in related technical/business area plus 2 years of IT or business experience. 6 years of additional experience can be substituted in lieu of degree

Technical Expertise:

Experience with PL/SQL Development – with Oracle PL/SQL including stored procedures, functions, triggers, cursors and exception handling.

SQL Performance Tuning – Ability to optimize complex queries for large datasets and high-volume transactional systems.

Version Control – Familiarity with Git, Bitbucket or other source control systems for managing codebase changes.

Healthcare knowledge is a plus.

Technology Doesn't Change the World, People Do.®

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.

All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

• 2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https://www.roberthalf.com/us/en/terms) .