Senior Business Intelligence Analyst

Summary of Job Description:
Reporting to the AEM Customer Excellence Manager, the specialist will be a key enabler in driving the high performance of the brand and in field teams to support organizational growth in Thailand. Overall responsibility for the administration and system maintenance for sales database integrity including monthly data reconciliation, system support dashboard solution, and performance tracking.
The successful candidate will have the ability to thrive in an environment of rapid change and work effectively with cross-functional teams.

Major roles and responsibilities

1. Business performance analysis & reporting:
   • Provide support in sales target setting, and design and populate sales target models as well as incentive calculation process.
   • Prepare regular reports to measure sales vs target results and SFE KPIs for representatives and managers across the various products and geographies.
   • Ensure validity and accuracy of distributor/ internal data used in sales reporting systems and reports.
   • Involve in the implementation of the sales database, maintain, and generate the report for the sales team.
   • Lead and Implementation on business intelligence (BI) and CRM-related solutions.
   • Gathering and analyzing relevant competitor data, both company and product related.
   • Complete ad hoc analysis and reporting for sale and other data through the agreed request process.
   • Other tasks/projects will be assigned from time to time.

2. Sales force effectiveness (SFE) analytics & management:
   • Recommend, and support to implement methods and techniques to improve analytical procedures within the sales force via Veeva CRM & BI tool.
   • Function as the admin contact for any discrepancies with sales data in the Abbvie BI platform and CRM platform.
   • Support the Commercial team in developing a database related to sales force effectiveness and sales data to improve the efficiency of in field as requested.
   • Support IFTs to deliver valuable interactions with stakeholders that change their behaviors via SFE KPIs.
   • Other tasks/projects will be assigned from time to time.

Requirements

Education and Experience:
• Over 4-5 years of experience in business analysis and sales force effectiveness (SFE), preferably pharmaceutical/ medical device experience.
• Bachelor’s degree in accounting or finance or business admin or Mathematics
• Expertise in Microsoft Excel, Power BI, Tableau, and database management is preferable.
• Experience in reporting and analytics tools (e.g. Veeva and CRM solution and sales data etc.) is preferable.
• Demonstrated experience in at least 2 of the areas:
o System analysis
o Sales information/ data management
o Sales operations
o Business analysis/reporting including Power BI Dashboard
o Project management
o Business process management system

Essential Skills and Abilities:
• Computer skills esp. Microsoft Office, Excel and PowerPoint, Microsoft Power BI, SAP, Tableau, SQL
• Strong business acumen and an understanding of commercial imperatives.
• Demonstrate ability to integrate from multiple sources and is able to effectively interpret data.
• Fluent in English, both speaking and writing.
• Able to adapt to dynamic environments and to work under pressure and tight timelines.
• Experienced in working cross-functionally. Ability to get work done through people, irrespective of reporting relationships, able to influence peers and upwards.
• Excellent communication and presentation skills with the ability to articulate (internally and externally) strategies and tactics that drive change.
• Strong analytical and problem-solving skills.
• High level of analytical skills including experience in the development of dashboards, KPIs, and measurements in CRM systems.

Competencies:
• Planning & Organizing
• Good communication skills
• Strong analytical & Problem-solving skill
• Ability to influence people