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.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Clinical Operations Specialist - Technical Support - SQL/ACCESS?
Sign up to receive alerts about other jobs on the Clinical Operations Specialist - Technical Support - SQL/ACCESS career path by checking the boxes next to the positions that interest you.
Not the job you're looking for? Here are some other Clinical Operations Specialist - Technical Support - SQL/ACCESS jobs in the Ridgefield, CT area that may be a better fit.
We don't have any other Clinical Operations Specialist - Technical Support - SQL/ACCESS jobs in the Ridgefield, CT area right now.
