Business Data Analyst

Ajinomoto Cambrooke, Inc. • Full-time • Ayer, MA, US • 5d ago

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

The Business Data Analyst role requires an inquisitive, analytical, and self-motivated professional 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 gathering, cleaning, analyzing, interpreting and presenting data to identify trends, patterns, and insights that help shape future business decisions. The position focuses on financial and commercial data models but will provide support across the organization. The Business Data Analyst reports to the VP Finance/Treasurer and will interface with sales, marketing, client services, reimbursement, finance, and senior leadership.

EDUCATION, CERTIFICATIONS AND EXPERIENCE

Bachelor’s Degree required preferably in Data Analytics, Business or Finance related fields.
1-2 years’ experience in analytics or consulting analyst role.
1-2 years’ experience with data visualization tools like Power BI (Preferred), Tableau, etc.

KNOWLEDGE, SKILLS AND ABILITIES

Must be able to independently write scripts/code using Python/Pandas (Preferred), SQL (Preferred), or other analytical coding language.
Expert Level knowledge with Microsoft Applications including Excel and PowerPoint. Must know pivot tables, joins (VLOOKUP and SQL), dynamic cell references, charts/graphs, and workflow diagrams. Working knowledge of Power Query, Power Pivot, DAX Calculations.
Able to programmatically connect data sources via APIs or other automated methods
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.
Superior interpersonal abilities. Ability to work with diverse personalities at all organizational levels in pursuit of the company’s goals; tactful, mature and flexible.
Strong communication and presentation skills. Must be able to facilitate working meetings, ask questions and apply active listening skills, and convey data driven results. Must demonstrate ability to design dashboards with complex information in a clean user-friendly manner
Passionate about documentation. Ability to create clear and concise documentation that is reusable and reproduceable.
Ability to work independently with minimal direction, take initiative within scope of work responsibilities
Ability to prioritize and organize in order to manage multiple projects, analyze multiple data sets simultaneously Analysts may face competing workflows, managing multiple projects at once, or analyzing multiple data sets simultaneously.

WORKING CONDITIONS

Fast paced environment.
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

Ability to be present in the corporate office environment
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 use a variety of office equipment, including keyboards
Ability to lift or carry up to 25 pounds occasionally.
Build a Modern Data Stack/Analytical Infrastructure - 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
Data Collection - Gather data from various sources using Python/Pandas, build data mart tables of aggregated information, leverage APIs to streamline insights, and then clean, transform, and prepare it (ETL) for analysis.
Analysis - Draw meaningful conclusions from the data, identify key insights, and understanding the implications for the business. Prepare quarterly reports, analyze financial data, and recommend sales predictions based on statistical models
Data Visualization - Create visualizations like dashboards and reports to communicate findings to stakeholders using tools like Tableau, Power BI, and Python.
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.
SalesForce Opportunities - Re-architect data schemas, integrate information from CRM and eCommerce platforms, analyze and report patient loyalty trends as well as report conversion data from sample to new patient starts.
Sales Forecasting - Forecast anticipated sales by region, distribution channel, and product division.
Other duties as assigned.

$64,500.00 - $70,000.00 plus 12.5% potential bonus

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.