Business Data Analyst @ Ajinomoto Cambrooke

LIONSTEP • Full-time • Ayer, MA, US • $64.50k - $70k / year • 1d ago

We work directly on behalf of Ajinomoto Cambrooke and do not charge any agency fees.

📍 Location: Ayer, Massachusetts, United States

⏰ Workload: Full-time (100%)

🌍 Equal Opportunity Employer

What This Position Has To Offer

✨ Work for a global leader and innovator in the field of advanced medical nutrition

🌎 Work in a dynamic environment where your ideas drive real-world impact

💰 Competitive salary with growth and learning opportunities

🚀 Opportunity to grow within a global company environment

On behalf of Ajinomoto Cambrooke, we are searching for their next Business Data Analyst.

Job Summary

Are you ready to turn complex data into actionable insights that shape business strategy? 📊✨ Then this opportunity is for you!

As a recruiting partner of Ajinomoto Cambrooke Inc. (ACI), we are looking for you as Business Data Analyst at the location in Ayer, Massachusetts.

In this role, you will be the key link between Finance, Commercial, and Executive Leadership, using data to drive decisions across the organization. From building modern data pipelines to designing dashboards and forecasting sales, you will make sure that ACI has the right information to make the right decisions.

This is an exciting opportunity for an inquisitive and self-motivated analyst with strong technical skills, excellent communication abilities, and a passion for problem solving. You will work with multiple departments - including Sales, Marketing, Client Services, and Medical Reimbursement - and have a real impact on shaping the future of the business.

💡 You can expect a salary range of $64,500–70,000 plus a 12.5% potential bonus.

👉 If we sparked your interest, schedule your first interview with us today!

What You Will Be Doing

Build and manage end-to-end data pipelines, ensuring data is clean, accurate, and ready for analysis
Gather, transform, and prepare data (ETL) from multiple sources including APIs, databases, and CSVs
Create dashboards and reports with tools like Power BI or Tableau to communicate insights clearly to stakeholders
Analyze business, financial, and commercial data to identify trends, risks, and opportunities
Prepare quarterly and ad-hoc reports that inform sales predictions and business strategy
Conduct financial analysis on product performance and support special projects with data-driven insights
Research and automate variance analyses (cost, time, KPIs) via analytics tools
Re-architect and analyze CRM/eCommerce data, report on patient loyalty trends and conversion rates
Forecast anticipated sales by region, distribution channel, and product division
Collaborate with leadership teams and ensure data findings are documented, reproducible, and actionable

What You Bring To The Job

Bachelor’s degree in Data Analytics, Business, Finance, or related field
1–2 years’ experience in an analytics or consulting analyst role
1–2 years’ experience with data visualization tools (Power BI preferred, or Tableau)
Strong coding skills in Python/Pandas and/or SQL (must be able to write scripts independently)
Advanced Excel and PowerPoint knowledge (pivot tables, VLOOKUP/joins, dynamic references, charts, graphs)
Experience programmatically connecting data sources via APIs
Strong analytical and problem-solving skills, able to reconcile large data sets and spot trends or gaps
Excellent communication and presentation skills; ability to convey data-driven results to leadership
Passion for documentation and creating clear, reproducible analytical workflows
Ability to work independently, take initiative, and manage multiple projects simultaneously
English: C1 – Advanced

Team

Reports to: Director of Operations

Benefits

Contribution to health insurance
Wellness and mental health benefits
Employee life insurance
Discounts to selected external services (dry cleaning, technology, etc.)
3 Weeks Paid Time Off
Short and Long Term Disability coverage
Fitness reimbursement
Medical, dental, vision and life Insurance
Lyra
Wellthy
401K
Long Term & Short-Term Disability
Tuition Reimbursement
Paid Holidays
PTO (Paid time off)

You can expect a friendly team that always supports each other and maintains a very open and collegial atmosphere. The corporate culture is characterized by flat hierarchies, direct communication, and transparency at all levels. You will be given plenty of room for individual development, both professionally and personally, in an environment that leaves no room for cutthroat competition.

Ajinomoto Cambrooke, Inc. formerly Cambrooke Therapeutics, Inc. (expansion of Cambrooke Foods) was founded in 2000 by Lynn and David Paolella, the parents of two children diagnosed with a rare disease called phenylketonuria (PKU). PKU is one of the few genetic diseases, which is managed almost entirely with nutritional intervention. The Paolellas’ goal in forming Cambrooke was simple - to develop improved nutritional therapeutic options for those with serious medical disorders.

Today, Cambrooke produces medical formulas and foods for the management of a variety of medical conditions and we are continually innovating new nutritional options targeted at a wide array of diseases.