Clinical Programmer Analyst

Medimpact San Diego , CA 92140

Posted 5 months ago

Clinical Programmer Analyst

  • Heavy PL/SQL programming required for this role

If you're interested in a career within a customer-focused, team-oriented environment that rewards innovation, quality, integrity and collaboration, MedImpact Healthcare Systems, Inc. welcomes your application. MedImpact, is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego, California. Our solutions and services positively influence healthcare outcomes and expenditures, improving the position of our clients in the market. MedImpact offers high-value solutions to payers, providers and consumers of healthcare in the U.S. and foreign markets.

Position Summary

The Clinical Programmer Analyst III provides analytical, Oracle SQL and PL/SQL development, Visual Basic programming, and technical support services used for the sale and delivery of clinical trend management products and programs and Clinical Analytics services to MedImpact internal customers, clients and prospects. This position serves as a primary liaison between Clinical Services and Analytics and MedImpact Information Technology staff and is an expert in a variety of desktop and server based database query tools. This position partners in the development of clinical management programs and clinical analytic services that support the goals of the Clinical Services and Analytics department.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

  • Utilizes advanced analytic and programming skills to measure savings and client ROI for clinical trend management products used for pricing and savings guarantee development. Works with Sales and Account Management to measure client performance in relation to savings guarantees targets

  • Utilizes Oracle SQL and PL/SQL, SAS, TOAD/Golden 32, IBM Cognos, Visual Basic, Microsoft Access, Excel, Word, and MedAccess skills to enhance the functionality and diversity of trend management programs. Activities include obtaining requirements, constructed complex queries, testing, and evaluation of logic to measure the performance of clinical management programs, formulary, utilization management edits, and benefit design parameters, to answer business questions related to Client's current performance, and forecasted performance based upon recommendations we would offer

  • Serves as a subject matter expert and resource to Clinical Services and Analytics staff in developing analytic approaches, queries and reports to answer complex clinical and utilization management questions often delivered to clients as a part of fee based consultative services

  • Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs

  • Designs and codes screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems

  • Consults with internal customers to prototype, refine, test, and debug programs to meet needs

  • Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections

  • Trains end users or technical support staff to use programs

Education and/or Experience

For consideration candidates will need a Bachelor's degree from a four -year college or university in information technology/computer science that includes programming, analytics, and IT development. Candidates should have two (2) to five (5) years job related experience and/or training, or equivalent combination of education and job related experience.

Computer Skills

Experience in managing large data sets utilizing relational database management systems including Oracle, SAS, MS Access, SQL Server, IBM Cognos

Hands-on experience in writing complex SQL queries involving multiple tables joins, sub-queries/nested queries, unions and aggregate functions

Solid PL/SQL programming skills and good knowledge of Oracle Relational Database Management System

Familiar with Microsoft Office Suite products, Visual Basic, and SAS is a plus

Other Skills and Abilities

Able to build complex multi-table queries, forms, reports, macros and computer code to support various reporting products and programs

Strong analytical abilities. Experience with analyzing healthcare claims and other related healthcare data is a plus

This position is eligible for Employee Referral Bonus at Level II

EOE, M/F/D/V

OSHA/ADA:

To perform this job successfully, the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.


upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Programmer Analyst

San Diego Community College District

Posted 1 week ago

VIEW JOBS 1/8/2019 12:00:00 AM 2019-04-08T00:00 Posting Details (Default Section) Closing Date: 01/20/2019 Open Until Filled No Classification Title Programmer Analyst Working Title Programmer Analyst Recruitment Limits Location District Pay Information Range H ($5,660.46 – $9,450.36) per month based on the current Supervisory and Professional Employees' Association – Salary Schedule B Initial salary placement is commensurate with related experience and promotional rules. The District offers a comprehensive fringe benefit package including employer paid: medical, dental, and vision plans; sick and vacation leave; and opportunities for professional development. Initial Salary Placement, Promoted or transferred employees will be placed as specified in the SPAA – Supervisory & Professional Administrators Association Handbook. This position is FLSA exempt and does not accrue overtime. A temporary probationary period will be applied to the employee entering this assignment. The SDCCD Employment Web Page provides a link to employee collective bargaining agreements and handbooks, and more information about terms and conditions of employment to include salary and benefits. Position Equivalent FTE: 100% No. Months: 12 Months Position Number: 011816, 011811 and 00120188 FLSA Status Exempt (does not accrue overtime) Position Type Classified Bargaining Unit Supervisory/Professional Range H Department Business & Technology Services The Position San Diego Community College District (SDCCD), second largest of California's community college districts is looking for three Programmer Analysts at the District Office in Mission Valley, San Diego. These positions will support the District's PeopleSoft enterprise applications. We offer excellent benefits and ample sick and vacation leave. About SDCCD As the second-largest of California's 72 community college districts, the San Diego Community College District serves approximately 100,000 students annually at its three, credit colleges, San Diego City College, Mesa College, Miramar College and seven campuses of San Diego Continuing Education. Hours are 8:00 to 5:00 p.m., Monday thru Friday. Selected candidates must be willing to adjust work days/hours based on the department's needs. Applicants must have authorization to permanently work in the US. Please note that an employee may be transferred to any site at the option of the Chancellor. Classification Description Click here for description If you would like to open the link in a different tab or window, right click and select the option. Desired Qualifications Knowledge: Comprehensive knowledge of maintaining and enhancing computing architectures and environments. Specific PeopleSoft software/programming languages/tools such as: * PeopleTools 8.5x * Application Designer * PeopleCode * Application Engine (AE) * Integration Broker/Tools * Process Scheduler * PS Query * SQR, Workflow * nVision * PeopleSoft Security * Tree Manager * Data Mover * BI Publisher/XML Publisher * Oracle (SQL, SQL Developer, SQLPlus) * Microsoft Office Suite. * Hyperion Planning tool Skills and Abilities: Recognize and resolve system related problems. Work independently and make necessary decisions within department guidelines. Perform multiple tasks concurrently and respond to emergency situations effectively. Communicate technical and complex information both orally and in writing. Training and Experience: Associate Degree in computer related discipline. Minimum of 2 years programming experience may substitute for the degree requirement on a year-for-year basis. Minimum of 2 years' experience in systems design, programming and/or systems software and support. Foreign Degree: Applicants with foreign degrees from colleges or universities outside of the United States must have their coursework evaluated by a professional association that is a member of the National Association of Credential Evaluation Services (NACES). A copy of the evaluation must be submitted with your on-line application. Commitment to Diversity: All applicants must have demonstrated cultural competency and sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students and staff. Special Instructions to Applicants: SELECTED CANDIDATE IS REQUIRED TO COMPLETE THE FOLLOWING PRIOR TO EMPLOYMENT: Submit "official" transcripts as stated on application (From all institutions listed in the online application); Pass a pre-employment physical exam at the District's expense; Provide a Tuberculosis Clearance Certificate for initial appointment (Note: The certificate must be renewed every 4 years as a condition of continuing employment); Have fingerprints taken by a Live Scan computer at the candidate's expense (Clearance must be received prior to first day of employment); Present original documents for proof of eligibility to work in the United States as required by the I9 Employment Eligibility Verification form; AND Attend a new hire processing appointment in Human Resources located at the District Administrative Offices. EMPLOYMENT AFTER RETIREMENT If you accept a contract (permanent) position with SDCCD and are a retired annuitant with CalPERS or CalSTRS, you must reinstate from your retirement system. Please reference the CalPERS or CalSTRS website for further information. Conditions of Employment: SELECTED CANDIDATE IS REQUIRED TO COMPLETE THE FOLLOWING PRIOR TO EMPLOYMENT: Submit "official" transcripts as stated on application (From all institutions listed in the online application); Pass a pre-employment physical exam at the District's expense; Provide a Tuberculosis Clearance Certificate for initial appointment (Note: The certificate must be renewed every 4 years as a condition of continuing employment); Have fingerprints taken by a Live Scan computer at the candidate's expense (Clearance must be received prior to first day of employment); Present original documents for proof of eligibility to work in the United States as required by the I9 Employment Eligibility Verification form; AND Attend a new hire processing appointment in Human Resources located at the District Administrative Offices. EMPLOYMENT AFTER RETIREMENT If you accept a contract (permanent) position with SDCCD and are a retired annuitant with CalPERS or CalSTRS, you must reinstate from your retirement system. Please reference the CalPERS or CalSTRS website for further information. Additional Information: EMPLOYEE BENEFITS SDCCD provides a comprehensive fringe benefit package for its full-time classified employees. The District contributes toward the cost of the premium (including dependent coverage) for the medical insurance plan options. Additional benefits include dental, vision, sick leave, vacation and opportunities for professional development. Contract employees become members of the California Public Employees' Retirement System (CalPERS) upon appointment. Posting Number CL01082 San Diego Community College District San Diego CA

Clinical Programmer Analyst

Medimpact