National Accounts Analyst

POSITION SUMMARY:
The National Accounts Manager serve a variety of functions in the day-to-day operation of PharmaLink. This employee will work with National Accounts, sales leadership, and executives across the company in preparing reports, business reviews, and various other functions related to the day-to-day maintenance of specific customers. This includes identifying trends, finding appropriate solutions, and making the necessary recommendations to optimize service, pricing, proposals, and ROI for both the customer and company. This position will work with National Accounts and related departments to ensure service levels are met and to identify KPIs related to service and contract goals.
Additionally, this role may act as a shared resource across all departments to work on various projects related to reporting, dashboard creation, process analysis, and other projects that support the efficiency and profitability of the company overall.
ESSENTIAL DUTIES & RESPONSIBILITIES:

• Collect, analyze, and report data to meet internal and external customer needs.
• Identify new sources of data and methods to improve data collection, analysis, and reporting.
• Collect customer requirements, determine technical issues, and design reports to meet data analysis needs.
• Manage company-wide statistics across multiple systems and reporting platforms.
• Data extraction, analysis, and modeling from various sources to transform the data and information into actionable knowledge for the organization.
• Work closely with company stakeholders to establish new and evaluate existing reporting to find efficiencies that will maximize analytic capabilities for the business.
• Develop dashboards and general data visualization using Excel, Power BI, or other tools.
• Develop, implement, and maintain training documentation related to Business Intelligence tools.
• Collaborate with key lines of business to understand needs and identify opportunities defining analytical problems to build strategy recommendations.
• Demonstrated ability to analyze, evaluate, and interpret complex data with a strong understanding and application of analytical techniques.
• Analyzing internal data for accuracy, such as financials, accounting data, sales reports, and operational data, etc.
• Proactively analyzes data and deliver insights to customers and company leadership to deepen their understanding of key accounts, operational efficiency, and accuracy.
• Responsible for National Accounts, analysis, interpretation, and reporting of customer and sales data on a regular basis.
• Assess client's data and recommend enhancements, identify gaps, present findings and strategic recommendations to Internal and external customers.
• Acts as a liaison between clients and company departments.
• Explore data to discover patterns, meaningful relationships, anomalies, and trends to present to management.
• Assist in conducting business reviews with key accounts via web-conference, in-person meetings, and at trade events.
• Actively handle day-to-day communications with key accounts, internal, and external stakeholders.
• Other related duties as directed management.
• Maintain security and confidence over highly classified projects and company information.

OTHER JOB FUNCTIONS:

• Coaches and may train internal and external customers in the use of the business intelligence solutions to enhance business decision-making capability.
• Strong analytical abilities with both quantitative and qualitative data.
• Develop reporting using business intelligence tools, such as Excel, Access, Power BI, and SQL.
• Write detailed specifications for queries, data sets, and other information for the development of deep analytics.
• Present to groups including, employees, and potential or existing customers.
• Experience handling, interpreting & manipulating raw data sets.
• Perform additional duties as assigned.

Note: The above statements describe the general nature and level of the work being performed and are not an exhaustive list of all responsibilities of an employee in this job. Job duties can change at any time as directed by management. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.
Requirements
KNOWLEDGE SKILLS AND ABILITIES REQUIRED:

• Highly proficient using the complete suite of Office365 applications.
• Advanced knowledge of Microsoft Excel, including pivot tables, charts, formulas, macros, and data analysis extensions.
• Proficient skills in Microsoft SQL with knowledge including table structures, data relationships, the ability to write SQL query structures to sort and retrieve data, etc.
• Experience with Microsoft Power BI Pro
• Strong analytical skills, with a high level of attention to detail.
• Ability to work cross-functionally within the organization.
• Excellent organizational and planning skills, with the ability to multitask.
• Self-starter; able to work with minimal supervision.
• Strong interpersonal and communication skills.
• Strong presentation and project management skills
• Ability to collaborate and function well in a team environment.
• Solid understanding of relational data structures, Business Intelligence, and reporting formats.
• Ability to meet deadlines and timelines.

EDUCATION/EXPERIENCE REQUIREMENTS:

• 3 - 5 years of data analysis or related experience.
• Minimum of 2 years of experience manipulating data from various source systems using SQL.
• Bachelor's degree in Business, Marketing, Communications, or related degree.

PHYSICAL REQUIRMENTS:

• Additional hours as needed to complete projects, accomplish objectives, and goals.
• Travel may be required.

RELATIONSHIPS:
In performing the above responsibilities, this position maintains the following relationships:

• VP of Business Development & Corporate Strategy
• The incumbent is accountable to the VP of Business Development & Corporate Strategy for interpreting and fulfilling the above responsibilities and others that may be assigned.
• Internal and External Customer/Member Relationships
• As a service organization with a commitment to quality service, it is the responsibility of each employee to provide prompt, courteous, accurate, and professional service to both internal and external customers.

PharmaLink reserves the right to revise or change job duties and responsibilities as the need arises.