Essential Duties:

• Sales Forecasting – Forecast anticipated sales by region, distribution channel, and product division.
• Commercial Analysis – Prepare quarterly sales commission reports. Analyze Sales, COGs/Margin data, to make pricing recommendations. Analyze trends in geographic regions, distribution channels, product categories.
• Performance Reporting – Prepare financial performance reports across the US and International businesses. Track sales performance against budget, determine marketing promotion effectiveness (digital and non-digital channels), and identify key drivers of performance from within cross functional datasets
• Financial Analysis and Dashboards – Prepare financial analysis on the success of new products, provide financial support on special projects, and develop dashboards which highlight KPIs for Senior Leadership
• Variance Analysis – Research, automate via analytics tools and report on variances from standard data such as cost and time.
• Marketing Campaigns – Collect, analyze, and provide results on various marketing campaigns and initiatives.
• SalesForce Opportunities – Retrieve, analyze and report patient loyalty trends as well as report conversion data from sample to new patient starts.
• Customer Satisfaction Analytics – Leverage attitudinal data by administering our annual healthcare professional and patient satisfaction surveys.
• Build Analytical Infrastructure – Work closely with team members to create end to end data pipelines, clean (ETL) existing data sources from APIs/CSVs/Databases, set up staging tables within databases and present data via Visualization Tools
• Other duties as assigned.

Education and/or Experience:

• Bachelor’s Degree required preferably in Finance, Statistics, Economics or Business.
• A minimum of 3 years’ work-related experience in a sales, finance, analytics, or marketing analyst role.
• Expert Level with Microsoft Applications including PowerPoint and Excel. Must know pivot tables, VLOOKUP functionality, automation methods, dynamic charts/graphs, workflow diagrams. Working knowledge of Excel Power Query, Power Pivot, DAX Calculations. Must be proficient in developing reports and management presentations.
• Minimum of 2 years' experience with Python/Pandas (Preferred), R, SQL (Preferred), SAS, Jupyter Notebooks or other analytical coding language.
• Minimum of 2 years' experience with data visualization tools like Power BI (Preferred), Tableau or Data Studio
• Able to programmatically connect data sources together via APIs or other automated methods
• Working knowledge of SalesForce, QuickBooks, and SAP a plus.

Minimum Qualification Requirements:

To perform this job successfully, an individual must be able to develop reporting, understand, analyze, interpret and present market and financial data to determine results and trends to support business initiatives. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the duties of the Business Analyst.

• Excellent analytical skills required. Ability to analyze/reconcile large amounts of data (in memory) and see gaps or trends that may impact anticipated results or identify that a change or new solution is required.
• Proven problem solving, critical thinking and evaluation skills. Ability to teach themselves new analytical skills without much manager oversight.
• Passionate about documentation. Ability to create clear and concise documentation that is reusable and reproduceable.
• Strong communication and presentation skills. Must be able to facilitate working meetings, ask questions and apply active listening skills, and convey data driven results.
• Ability to collaborate with cross-functional teams and get along with diverse personalities at all levels of the organization.
• Must maintain information security with regard to all company’s proprietary information

• Superior interpersonal abilities. Ability to work with diverse personalities at all organizational levels in pursuit of the company’s goals; tactful, mature and flexible.
• Resourceful, insightful self-starter with the ability to work independently with limited supervision.

Ajinomoto Cambrooke, Inc. is an Equal Opportunity Employer-Vets/Disabled, committed to a diverse workforce. If you need assistance with completion of an application for employment, please contact Human Resources Department at 978-862-1980.

Ajinomoto Cambrooke, Inc. strongly encourages employees to be vaccinated against COVID-19.

Skills

• Tableau
• SAS
• QuickBooks
• Excel Access
• Excel VLOOKUPs
• Python/Pandas
• Microsoft Office Suite
• Excel Pivot Tables
• Excel Power Query

• SAP

Behaviors

• Innovative: Consistently introduces new ideas and demonstrates original thinking
• Team Player: Works well as a member of a group
• Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well
• Enthusiastic: Shows intense and eager enjoyment and interest
• Functional Expert: Considered a thought leader on a subject

Motivations

• Flexibility: Inspired to perform well when granted the ability to set your own schedule and goals
• Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization
• Self-Starter: Inspired to perform without outside help

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)