Excel Pivot Table Remote Jobs in Elgin, IL (NOW HIRING)

Data Analytics Analyst II

The Analytics team within IQVIA's Patient Access & Support Services (PASS) group is an exciting and dynamic healthcare practice where you can start or continue your career in the life sciences industry.

IQVIA possesses the largest and most comprehensive set of healthcare data assets in the world. Additionally, the PASS team generates client data through savings program transactions captured by our proprietary claims engine. From our position atop this wealth of information, we seek to deliver unparalleled insights and analysis to our clients. We are seeking the best, brightest, and most analytically motivated individuals to join our team.

The Role of a PASS Data Analyst:

Analysts begin under the guidance of more senior team members, but are quickly provided with opportunities to contribute to all aspects of client engagements. Team members will begin to assume an active ownership in running projects and mentoring more junior colleagues. The analytic rigor and creativity of our analysts' work is critical to the success of our engagement teams and our practice as a whole.

As PASS Analyst you'll be responsible for:

• Leveraging skills in Excel and SQL to yield trends, conclusions, and actionable recommendations for clients

• Contributing to internal brainstorming sessions and collaborating with account management team members throughout client engagements

• Evaluating secondary data on markets, physicians, patients, and pharmacies

• Developing and working with reporting tools such as PowerBI to derive insights and forecasting

• Coordinating both directly with clients as well as through the PSS account team to manage the analytics needs of the clients for both scheduled and ad hoc requests

• Creating reports, presentations and other client deliverables

• Presenting to client audiences via teleconference, videoconference, or in face-to-face meetings

• Building professional relationships with internal and external members of the client team

• Proactively developing knowledge of the healthcare industry and client engagement methodologies

An ideal candidate will have:

• Minimum of 3+ years of experience with SQL, Microsoft Excel, & Microsoft PowerPoint - Strong SQL skills for querying and extracting data ; Advanced Excel (analysis, pivot tables, reporting) ; PowerPoint for executive/client presentations

• Experience with Power BI is a plus

• A strong analytical record, excellent problem-solving abilities, and strong quantitative skills

• Exceptional communication skills and be a proven team contributor

• An interest in and desire to learn about the constantly evolving healthcare industry

• Good project management, time management and organizational skills

• Excellent conversational and business English (written and orall)

• A willingness or ability to travel as needed (<10% on average)

This is a remote / WFH role open to candidates currently residing the United States.

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more athttps://jobs.iqvia.com

IQVIA is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law. https://jobs.iqvia.com/eoe

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.

The potential base pay range for this role, when annualized, is $56,100.00 - $140,300.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.