VBA Developer

IQVIA™ is the leading human data science company focused on helping healthcare clients find unparalleled insights and better solutions for patients. Formed through the merger of IMS Health and Quintiles, IQVIA offers a broad range of solutions that harness the power of healthcare data, domain expertise, transformative technology, and advanced analytics to drive healthcare forward.

Overview of RWI at IQVIA and the Real-World Insights (RWI) Team

IQVIA believes that the growing use of Real World Insights (RWI) is one of the most critical developments in life sciences today.  With an explosion of new electronic data sources, transformations in technology, new analytic methodologies, and deeper understanding of healthcare issues, QuintilesIMS are investing heavily in growing this part of our business. 

IQVIA Real-World Insights (RWI) works with clients to help them use RWI to answer their specific questions globally, make more informed decisions, and deliver results.  Our approach is unique in the industry and it is defining the way companies can develop and apply RWE.

We are a team with a company history entirely based in healthcare and everything we do supports providing more insight about market dynamics, therapy area changes, scientific innovations, and previous research approaches.  We are collaborative, intellectually curious, entrepreneurial, and constantly looking for opportunities to harness the value of RWI in a constantly evolving industry.  Our collective expertise (across functions, therapeutic areas, and disciplines) helps clients understand how to answer their questions by leveraging the best possible information, technology and analytic research techniques.  We work with our internal experts in roles from strategic consulting to HEOR to pharmaco-epidemiology to predictive analytics to data management to local experts – whatever the client needs.

We’re seeking strategic thinkers, innovative technologists, deep subject matter experts and passionate data evangelists.

The Team

QuintilesIMS Real-World Insights (RWI) teams work with clients to help them use complex, clinically rich, patient-level healthcare datasets to answer their specific questions globally, make more informed decisions, and deliver results. Our approach is unique in the industry and is defining the way companies can develop and apply Real World Insights (RWI) to provide deeper insight about market dynamics, therapy area changes, outcomes research and other scientific insights. We are collaborative, intellectually curious, entrepreneurial, and constantly looking for opportunities to harness the value of RWE in a constantly evolving industry.

Background

The role involves the development of pricing algorithms and extensive VBA programming using Excel. The purpose will be to support the development and design of a global pricing tool / database working together with a cross-functional team. This pricing tool should drive efficiency through simplicity, reduced stakeholder involvement, transparency and ultimately impact client satisfaction.

Responsibilities and Accountabilities

• Read, interrogate and program VBA in Excel at an in-depth level
• Analyze and re-engineer complex Excel pricing tool to achieve project / department / division goals
• Identifying issues and proposing improvements within the pricing tool and beyond
• Create database, capturing project specific information from the pricing tool
• Test, QA and improve existing tool / database to achieve efficiencies
• Delivery of process documentation
• UAT Support
• Drive maintenance and participate in governance of the pricing tool / database
• Ensure appropriate standards and procedures are adhered to during the programming process to provide quality
• Proactively works with project managers and cross-functional teams to gain an understanding of the business and its requirements
• Coordinates programming activities with other functions including service, consulting, business lines and sales, as appropriate
• Provide progress reports

• Desired Skills and Experience
• Proficient in Excel based model development
• Extensive VBA programming experience (object orientated, user defined functions, scratch written code and error handling)
• Strong analytical and problem-solving skills
• Effective time management skills and ability to manage competing priorities
• Must be pro-active and hands-on
• Ability to establish and maintain effective working relationships with coworkers and managers
• Fluent in English

  Qualifications 

  Bachelor’s degree or equivalent with a minimum of 3 years or more relevant VBA programming experience. Knowledge of QI offerings and pharmaceutical industry and/or finance would be an asset.

Join Us

Making a positive impact on human health takes insight, curiosity, and intellectual courage. It takes brave minds, pushing the boundaries to transform healthcare. Regardless of your role, you will have the opportunity to play an important part in helping our clients drive healthcare forward and ultimately improve outcomes for patients.

Forge a career with greater purpose, make an impact, and never stop learning.