12/05/2023
IQVIA is hiring for Senior Clinical Process Associate for multiple locations, such as Bengaluru/Thane.
Find the JD below:
Job Description:
Developing VBA macro based excel templates to create the dashboards.
Advanced level Excel knowledge
Logical functions – If function, Nested If function, AND, OR, IFERROR, IFNA etc.
Date & Time Functions – Date, Days, Workdays, Network days, TODAY, YEAR, etc.
Lookup & reference functions – VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET, INDIRECT, GETPIVOTDATA, etc.
Statistical functions – AVERAGE, AVERAGEIF/S, COUNT, COUNTA, COUNTIF/S, LARGE, MAX, MAXIF/S, Median, LARGE, MIN, MINIF/S etc.
Text Functions – FIND, REPLACE, CONCATINATE, LEFT, RIGHT, LEN, MID, TRIM, VALUE etc.
Creating calculated fields and conditional formatting in Pivot tables.
Creating Dynamic range in Excel.
BASIC, INTERMEDIATE, ADVANCE Level Excel VBA knowledge
Creating code and User Form MODELS
MsgBox
Declaring Variables and Data Types
Types of Loops – For Next, For Each, Do Until & DO while loops.
Creating the excel templates to collate the multiple source data.
Excellent in data modelling.
Basic/Advanced level of knowledge on creating Spotfire dashboards.
Conditional Formatting.
Basic and advanced level of Knowledge on POWER Queries, Power Pivots etc.
Working knowledge of clinical systems.
CTMS
Vault Clinical
IWRS/IVRS
eDC – Inform/Veeva etc.
Strong communication skillset to connect with Global external and internal clients.
Expert in ICH GCP Guidelines.
Good knowledge on Clinical trials.
Understating the work Responsibilities of each roles involved in the Clinical trials.
Minimum Work Experience:
Candidates must have minimum 2 to 5 years of experience in Clinical or analytical fields.
Qualifications:
Bachelor’s Degree in healthcare/ Bachelors of Science / Master’s in Healthcare/ Masters of Any Technologies.
Link to apply: https://lnkd.in/dfbvyETz