Software Eng IV

“Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors.  A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.”

This position is not eligible for Sponsorship.

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team!

Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.

At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!

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

• Design, develop, and maintain ETL workflows and mappings in Informatica PowerCenter

• Develop and optimize complex Oracle PL/SQL procedures, functions, triggers, and packages

• Build and maintain Shell scripts for data automation, monitoring, and job scheduling

• Gains a thorough understanding of functional requirements for new software requests

• Works with Business Systems Analysts to understand and clarify software requirements and translate into working software

• Designs, develops and performs testing of software to meet functional requirements

• Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products

• Partners with software team in the development of software engineering processes

• Works to identify and resolves technical or product problems

• Participates in software project meetings and provides status reports

• Translates technical designs into working software

• Maintains existing applications by enhancing software and troubleshooting issues

• Collaborates with team members and partners with others as needed to ensure successful completion of assigned software development tasks

• Ensures data quality, performance, and scalability of ETL processes and database solutions

• Participates in code reviews, release management, and process improvement efforts  Troubleshoot and resolve production issues related to data processing and performance

• Contributes to best practices, documentation, and continuous improvement initiatives within the team

• Applies software engineering and Object-Oriented Design principles in creating UML diagrams and technical design documents for software components

• Partners with team members and technical project lead to ensure component design fits in with the overall solution

• Adopts new techniques and technologies

• Initiates attendance at job related training to keep skills current; maintains current understanding of the industry’s best practices

• Assists with mentoring and training of less experienced IT staff members

Supervisory Responsibilities        

No supervisory responsibilities

Client Responsibilities

This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written).  One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.

Qualifications

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

Education and/or Experience

BS/BA and 8+ years’ experience or equivalent combination of education and experience, and 4 years of SME in respective areas

Computer Skills

• Eight (8) plus years of experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter and B2B Data Exchange products

• Hands-on experience with PowerCenter Mapplets, Mappings, Workflows, and Applications

• Experience in PowerCenter Developer using Data Transformation and Developer Studio tools

• Strong ETL and data modelling experience, including schema design, query optimization, and performance tuning

• Eight (8) plus years of experience in development of database processes using Oracle SQL, PL/SQL in Oracle 12c and Unix shell scripting

• Proficiency in Oracle PL/SQL, including advanced SQL, stored procedures, and performance optimization

• Familiarity with job scheduling tools such as UC4, Control-M, AutoSys, or similar

• Excellent knowledge of debugging, tuning and optimizing performance of database queries

• Strong experience with Unix/Linux Shell scripting for ETL orchestration and automation Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications

• Strong proficiency in database interfacing and relational database management systems

• Excellent problem-solving, analytical, communication skills and collaboration with cross-functional teams

Other Skills and Abilities

• Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams

• Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions

• Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences

• Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines

• Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful

Travel - This position may require domestic travel as well as attendance at various local conferences and meetings.

Competencies To perform the job successfully, an individual should demonstrate the following competencies:

Composure

Decision Quality

Organizational Agility

Problem Solving

Customer Focus

Drive for Results

Peer Relations

Time Management

Dealing with Ambiguity

Learning on the Fly

Political Savvy

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic).

Work Location

This position must work on-site at the San Diego Headquarters (or other company location) for purposes of providing adequate support to internal clients; being available for face-to-face interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as for facilitation of quick and effective decisions through collaboration with stakeholders.  Periodic scheduled remote work may be permitted as allowed under the department’s policy and with management approval. 

Working Hours

This is an exempt level position requiring the incumbent to work the hours required to fully accomplish job responsibilities and reasonably meet deadlines for work deliverables. The individual must have the flexibility to work beyond traditional hours and be able to work nights, at weekends or on holidays as required.  Work hours may be changed from time to time to meet the needs of the business.  Typical core business hours are Monday through Friday from 8:00am to 5:00pm.

• Medical / Dental / Vision / Wellness Programs
• Paid Time Off / Company Paid Holidays
• Incentive Compensation
• 401K with Company match
• Life and Disability Insurance
• Tuition Reimbursement
• Employee Referral Bonus

To explore all that MedImpact has to offer, and the greatness you can bring to our teams, please submit your resume to www.medimpact.com/careers

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.

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.

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.