SAS Programmer

Regular Full-Time


ERT is a global data and technology company that minimizes uncertainty and risk in clinical trials so that our customers can move ahead with confidence. With more than 45 years of clinical and therapeutic experience, ERT balances knowledge of what works with a vision for what’s next, so it can adapt without compromising standards.

Powered by the company’s EXPERT® technology platform, ERT’s solutions enhance trial oversight, enable site optimization, increase patient engagement, and measure the efficacy of new clinical treatments while ensuring patient safety. Over the past four years, more than half of all FDA drug approvals came from ERT-supported studies. Pharma companies, Biotechs, and CROs have relied on ERT solutions in 9,500+ studies spanning three million patients to date. By identifying trial risks before they become problems, ERT enables customers to bring clinical treatments to patients quickly – and with confidence. For more information, go to or follow us on LinkedIn, Twitter, and Facebook.


As a Systems Analyst you will design and implement database extractions for eCOA studies in EPX system. You will create and test SAS code used for standard file creation and create or review ERT standard dats specifications for studies in our EXPERT system.



For eCOA studies in EPX system:

  1. Design, implement, and unit test database extractions and edit checks as defined in the Data Management and Quality Plans for studies.
  2. Design, implement, and unit test other database queries in support of the Data Management department and other departments as requested.
  3. Create, support and maintain databases as required for studies, including the entry of subject and site information.
  4. Develop tools to increase internal Data Management efficiencies.
  5. Create and maintain documentation required in support of project and study development.
  6. Work with Data Management department to lock and archive study databases at the end of a study.
  7. Work with the QC department to assist in the formal validation of database extractions and other work produced.
  8. Participate in code reviews with other personnel.

 For Studies in EXPERT system:

  1. Attend Client Meetings as appropriate to understand data collection requirements.
  2. Review or provide standard data specifications.
  3. Develop SAS programs to create ERT standard data files.
  4. As part of the Software Development Life Cycle, review User Requirements and create and/or review Functional and Technical Specifications.
  5. Process data extracts through SAS
    • -Review encoding requests daily to run encoding programs.
    • -Produce generic SAS edit checks and client-specific edit checks for the DM/PM to clean data.
    • -Create final client data files and transfer to client (for electronic transfers) or produce CD or diskette and provide to the DM/PM.
  6. Create and test ad-hoc programs for data resolution/mining.



  1. Assist with orientation and training of Systems Analyst / Data Management / Project Management personnel as determined by management.
  2. In conjunction with the entire department, recommend, develop and implement SOPs for improved Data Management Procedures.
  3. Perform other duties as assigned by management.


  1. BS in computer sciences or related field.
  2. 2-5 years of experience in database development
  3. Familiarity with Microsoft SQL Server database administration required
  4. Advanced query development using T-SQL using complex joins and unions required
  5. Experience working in a multi-cultural environment, supporting multi-geographic/international locations
  6. Understanding of the pharmaceutical drug development process.
  7. Strong organization, analytical and communication skills.
  8. Detail-oriented.
  9. Experience with Windows and Microsoft Office products preferred.
  10. Minimum one year experience with BASE SAS products and procedures and one year experience in database design and data structures.
  11. Domain experience in clinical database a plus
  12. Knowledge in third party OLAP tools a plus

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.