What are the responsibilities and job description for the Clinical Operations Specialist – Technical Support - SQL/ACCESS position at McInnis Inc.?
Currently, seeking a 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 job is a hybrid position with weekly on location visits required in Ridgefield, CT.
Most recent job MUST have been creating/developing an intermediate to complex Microsoft Access database
Requirements:
- 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.
Preferences:
- Access Level IV certification
- Access Visual Basic Application Level II certification
- Excel macro certification
Duties & Responsibilities:
- 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.
Desired Experience, Skills and Abilities:
- 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.
Additional Provisions:
Contractor will comply with Key Performance Indicators (KPIs), including but not limited to:
- LOS Compliance
- TimeRecorder Compliance
- COS will not send, receive, share, or maintain work products/documents on or to a personal computer or with ISP Vendor.
Salary: $44-$47/hour
Salary : $44 - $47
