Clinical Operations Specialist – Technical Support - SQL​/ACCESS

Overview

Clinical Operations Specialist – Technical Support (COS) to join our Business Operations team located at our Ridgefield, CT facility. The COS will provide VBA and SQL programming to existing and new Microsoft Excel workbooks and Microsoft Access databases.

This is a hybrid position with weekly on-site visits required in Ridgefield, CT.

• Microsoft Access Programmer
• Experienced in writing new code, testing, and debugging, application troubleshooting, and modification techniques, code optimization including programs/utilities developed by other developers.
• Proficient in VBA and SQL programming
• Advanced knowledge of relational databases
• Ability to work independently based on user requirements
• Ability to work on multiple projects in parallel and meet deadlines
• Good programming practices, ability to write user manuals and technical documents, capture, and document user requirements
• Effective communication
• 4-Year college degree or relevant experience
• Good understanding of RDBMS

• Access Level IV certification
• Access Visual Basic Application Level II certification

• As part of the local Business Operations team, the COS specialist will be responsible for:
• Creating and updating complex MS Excel macros
• Modifying and maintaining existing MS Access databases, debugging problems, along with creating and generating new reports
• Gathering user requirements for developing new MS Excel macros and MS Access databases
• Ability to integrate data from various data sources and perform complex calculations and/or analysis
• Providing support for Microsoft Office products
• Providing support for ad-hoc requests from supporting areas
• Uphold Good Programming Practices

• Highly motivated developer who is detail oriented and a critical thinker
• Capable of multi-tasking and able to work on various projects simultaneously
• Ability to learn and adapt to Clinical Operations business processes
• Highly proficient computer skills, with direct working experience in multiple electronic platforms such as but not limited to:
  SharePoint, Clinical Trial portals, Central IRB portals, Time reporting portals, Learning portals, Access Databases, Microsoft Excel, Microsoft Skype, Microsoft Teams, Adobe Acrobat Professional and scanning software etc.
• Visualization software such as Tableau and/or Spotfire
• Ability to develop interactive Excel dashboards using Power Query and Power Pivot
• Maintain knowledge of assigned BI SOPs and BI Working Instructions
• Maintain current knowledge of assigned role-based ICH and GCPs, applicable FDA guidelines, US Federal Regulations pertaining to Clinical Trials and Guidance Documents and Information Sheets, PhRMA code, and industry standards for the monitoring of clinical trials at no cost to BI
• Knowledge of Amazon AWS or other popular cloud-based solutions is preferred
• Represent BIPI with the highest ethical and professional standards with all business contacts

Contractor will comply with Key Performance Indicators (KPIs), including but not limited to:

• Time Recorder Compliance
• COS will not send, receive, share, or maintain work products/documents on or to a personal computer or with ISP Vendor

What is your highest level of education completed?

Have you created an intermediate to complex Access database recently? Yes No

Are you comfortable working in a hybrid setting? Yes No

How many years of work experience do you have with Access VBA?

Are you able to participate in a hybrid position that includes weekly in-person attendance in Ridgefield, Connecticut and remote work?

The following questions are entirely optional. To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

I consent to be contacted over SMS/Text for this job. By providing your phone number you agree to receive informational/marketing text messages from McInnis Inc. Messages frequency will vary. Reply HELP for help or STOP to cancel.