Abbott Sales Data & Insights Analyst in Lake Forest, Illinois
At Abbott, we're committed to helping people live their best possible life through the power of health. For more than 125 years, we've brought new products and technologies to the world -- in nutrition, diagnostics, medical devices and branded generic pharmaceuticals -- that create more possibilities for more people at all stages of life. Today, 99,000 of us are working to help people live not just longer, but better, in the more than 150 countries we serve.
Primary Objective of Position
The Sales Data and Insights Analyst enables commercial decision making by analyzing market, customer, product, revenue, territory and sales execution metrics and providing insights that inform scenario planning. The incumbent partners with commercial management to ensure sales excellence tools are being used and processes are being implemented as designed. Also, is responsible for driving data quality and integrity.
Core Job Responsibilities
Subject matter expert for sales excellence tools and processes relative to data management and associated KPIs.
Responsible for total available market and served available market reconciliation with the Market Insights and Finance teams. Partners with the commercial team to identify gaps or opportunities for expansion.
Custodian of territory coverage model and assignment as well as commercial opportunity management.
Responsible for sales performance excellence reporting as well as win/loss and acquisition opportunities analytics.
Provide analytics and insights that help commercial teams improve or maximize execution and results.
May perform special projects upon request and on occasion may provide guidance to less experienced Business Analysts
Bachelor’s Degree required
Experience and Skills
• Strong experience using Microsoft Office and the extended VB Scripting Library.
• Deep understanding and practical experience using reporting tools such as Tableau or
• Overall knowledge of DB Schema and basic SQL commands. Know the logic of how a Database is set up and how to build one. Experience performing queries to analyze the data.
• Demonstrated ability to operate in a cross-functional matrixed environment.
Ideal/Highly Preferred Experience:
Strong analytical skills: i.e. ability to gain insights from data, effectively summarize insights to Senior Sales Management
Ability to design effective data models that support dynamic commercial strategies
Experience with support of Commercial Teams, either in financial analyst role, sales operations support.
Proficient in MS Excel, comfortable building complex formulas
Good knowledge of SQL queries for relational database models
VBA programming is a plus
Advanced Microsoft Power BI development is a big plus, but not required
Above work experience-- but with Latin American countries.
An Equal Opportunity Employer
Abbot welcomes and encourages diversity in our workforce.
We provide reasonable accommodation to qualified individuals with disabilities.
To request accommodation, please call 224-667-4913 or email email@example.com