Financial Reporting & Data Analyst

About Us

Eat Well, Live Well. At Ajinomoto Cambrooke, we build careers grounded in helping improve people’s health through nutritional therapies.

Ajinomoto Cambrooke (ACI) was founded by parents looking to develop better solutions for their children with PKU. Over the subsequent 20+ years, we have expanded into additional therapeutic areas with a focus on enjoyable nutrition as a core part of normalizing the life for people living with medical conditions.

Joining ACI means becoming part of a diverse team of talented people who want to build their careers while contributing back to society in a positive way. We seek individuals who bring an entrepreneurial mindset with a bias for action and finding solutions. We provide an environment based in mutual respect and collaboration to support you and give you opportunities to learn and develop.

Join us to find a rewarding work experience that lets you be at your best and have an impact on our patient communities.

Overview

The Financial Reporting & Data Analyst role requires an inquisitive and analytical leader to act as key liaison to the Commercial and Executive Leadership Team in planning and executing business strategy based on data driven results. Core responsibilities include market and financial data analysis and reporting to determine results and trends to support business initiatives. The Business Analyst reports to the VP Finance/Treasurer and will interface with sales, marketing, client services, reimbursement, finance, and senior leadership.

Qualifications

EDUCATION, CERTIFICATIONS AND EXPERIENCE:
• Bachelor’s Degree required preferably in Finance, Accounting, Data Analytics, Business or related field.
• 3 years of 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.

KNOWLEDGE, SKILLS AND ABILITIES:
• 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.
• Superior interpersonal abilities. Ability to work with diverse personalities at all organizational levels in pursuit of the company’s goals; tactful, mature and flexible.
• Accustomed to working collaboratively in a team setting.
• Demonstrated organization skills and accuracy skills.
• Ability to work independently with minimal direction, take initiative within scope of work responsibilities.
• Able to prioritize work, anticipate department needs, plan accordingly for needs, multi-task and adapt to change.

Working Conditions / Physical Requirements

WORKING CONDITIONS:
• Majority of work is completed in an office setting working inside a temperature-controlled environment.
• Occasional work outside may be required to support employee events.
• May perform activities in an environment containing hazardous elements and requiring safety awareness and adherence to all safety and GMP policies and guidelines.
• Work must be performed in a safe manner for personal protection and for the protection of other team members.

PHYSICAL REQUIREMENTS:
• Position requires the ability to sit for a minimum of 6 hours per day.
• Ability to stand, walk, bend over, and reach above head on a regular basis.
• Ability to lift or carry up to 25 pounds occasionally.
• Repetitive use of hands/arms for writing, filing, and computer work.
• Ability to use a phone, utilizing a headset as required.
• Ability to wear personal protective equipment to enter the manufacturing areas.

Responsibilities

• 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 stagging tables within databases and present data via Visualization Tools.
• Other duties as assigned.

Salary Range

yes

EEO Statement

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-1938.

#J-18808-Ljbffr