Data Developer

Data Developer

Company Profile 

From its founding in 2011, RxAnte’s mission has been exceedingly simple: Get more from medicines. Today, we are the leading provider of pharmacy care management solutions that improve medication prescribing and adherence. With over 30 million lives under management, our patented solutions for health plans are proven to improve quality scores and lower costs by improving prescription drug use.

In 2019, RxAnte launched Mosaic Pharmacy Service (MPS), a wholly owned subsidiary. Designed specifically to provide in-home pharmacy services to medically complex and vulnerable seniors, MPS directly improves prescribing, adherence, and drug therapy outcomes for patients under our care.

RxAnte is a subsidiary of UPMC, the $20+ billion health plan and hospital system.

Job Overview

The Data Developer is responsible for designing and building the systems required to deliver RxAnte's analytic products in a scalable manner.  Strong analytic and SAS programming skills are required.  The developer works with the VP of Data Services, Director of Data Services (manager) and fellow Developers to establish the architectural design patterns for our systems.  The Developer builds these systems by employing iterative and agile development techniques and modular code.  In addition to designing and developing the systems, the developer contributes to the monthly production of client deliverables and works with clients as needed to acquire data and resolve data issues. This full-time position is a remote work arrangement.

Essential Duties and Responsibilities:

• Work with VP of Data Services to maintain computing infrastructure and develop long-term computing/software architecture
• Establish and maintain project-deliverable processes with an eye toward scalability
• Rework and enhance existing base code, building in scalability and systemizing as necessary
• Program client-deliverable projects using SAS, R, and other software as required
• Collaborate with our client's IT team to acquire client data and resolve client data issues
• Other activities as needed 

Required Skills/Abilities:

• Ability to read in complex raw data files
• Ability to manipulate data in a SAS datastep, using array processing, by group processing with first., last., retain, SAS functions, SAS dates, etc.
• Experienced using SAS hash objects, hash tables, and iterators
• Extensive use of proc format
• Ability to understand how SAS programs are tokenized, compiled, and executed
• Understanding of how the macro processor works; and how to access SAS metadata using dictionary tables, and how to use dictionary tables and SAS macros to write dynamic and robust code
• Ability to understand program data vector and the difference between SAS executable and non-executable statements
• Experience with report writing using ODS, data null, proc summary, proc report, proc tabulate.
• Extensive experience using proc sql (within SAS and pass-through to Oracle, DB2, etc.)
• Experience using table-driven development techniques for modular coding

• Ability to function well in a fast-paced environment with fluctuating priorities and deadlines.
• Self-motivated and highly productive with the ability to work independently
• Team player with strong organizational, time management, and communication skills
• Analytical and critical thinking skills
• Ability to thrive in an environment where you need to roll up your sleeves and own outcomes
• Proficiency with Microsoft Office Suite including Word, Excel, and Outlook

Education and Experience:

• A Bachelor’s degree is required; an advanced degree in epidemiology, health services research, health policy, public health, mathematics/statistics, computer science, or other relevant fields is preferred
• 2+ years of relevant/related experience in similar role
• Strong SAS coding experience and skill, including system design
• Experience working with administrative health care data (e.g., commercial medical, hospital, and pharmacy claims, and Medicare or Medicaid data), healthcare informatics, or health care claims processing