Advance Excel (Remote)

Advance Excel

Job Summary

Client Services role involving direct communication with Pharma and Consumer Health clients. Candidates should possessGood analytical capability, strong secondary research skills and excellent communication (Verbal / Written),Have the skills to handle difficult conversations that may arise during customer dissatisfaction;Use technologies adapted to the types of customers to respond effectively; Easily connect with customers to fully meet their needs; Independent thinker, Share insights and observations with the stakeholders.Ability to understand customers wants, needs and expectations & attention to detailAdvanced excel knowledge as a dashboard developerResponsible for data extraction, validation, and analysis using various IQVIA databases. Analyze data from multiple sources to derive questions and insightsAbility to look at data and spot trends and/or anomalies in the data.Create Excel templates for data analysis and documentation (SOPs, Checklists) of projects Interact with clients to manage new client transitions, query resolution and ad-hoc requests Ability to work in a team and coordinate with team members in performing quality checks for the delivery of projects with tight turnaround timesAbility to successfully work together with a (“virtual”) team (including international teams as required) as well as independently.Ability to create Dashboards using Excel , VBA and Power query Should be able to manage the reporting workStrong organizational skills with the ability to multitask and work independently and efficiently to meet scheduled deadline.

Requirements / Qualifications

• Proven experience in using advanced Excel functionalities in a professional setting.
• Strong analytical skills with the ability to interpret complex data.
• Solid understanding of data management and processing techniques.
• Excellent problem-solving abilities and attention to detail.
• Effective communication skills to relay technical information to non-technical audiences.
• Experience in financial modeling is preferred.
• Ability to work independently and collaboratively in a fast-paced environment.
• Proficiency in creating advanced formulas and functions within Excel.
• Bachelor's degree in Finance, Business, or related field.
• Experience with other data analysis tools is a plus.
• Demonstrated ability to deliver projects on time and meet deadlines.
• Familiarity with Excel add-ins and third-party data tools.
• Strong organizational skills and the ability to manage multiple tasks.
• Resourceful and adaptable with a strong willingness to learn.
• Previous experience in a similar role is an advantage.