Business Data Analyst @ Ajinomoto Cambrooke

LIONSTEP; Ayer (MA); On-site; USD 64,000 - 70,000; Full time

Job summary

A global leader in advanced medical nutrition is seeking a Business Data Analyst in Ayer, Massachusetts. This role involves building data pipelines, creating dashboards, and conducting analyses to support business strategy. The ideal candidate has a BA in a relevant field, 1-2 years of experience, and strong skills in data visualization tools and programming. This position offers competitive pay and benefits including health insurance, paid time off, and a 401K.

Benefits

Contribution to health insurance

Wellness and mental health benefits

401K

Tuition Reimbursement

3 Weeks Paid Time Off

Qualifications

• 1–2 years’ experience in an analytics or consulting analyst role.
• Strong coding skills in Python/Pandas and/or SQL.
• Excellent communication and presentation skills.

Responsibilities

• Build and manage end-to-end data pipelines.
• Create dashboards and reports using Power BI or Tableau.
• Conduct financial analysis on product performance.

Skills

Data Analysis

Data Visualization (Power BI, Tableau)

Python Programming

SQL

Advanced Excel

Communication

Education

Bachelor’s degree in Data Analytics, Business, Finance, or related field

Tools

Power BI

Tableau

Excel

Job description

Overview

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

Salary: $64,500–$70,000 plus a 12.5% potential bonus

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.

Job Summary

Are you ready to turn complex data into actionable insights that shape business strategy? We are looking for a Business Data Analyst for Ajinomoto Cambrooke Inc. (ACI) at the Ayer, Massachusetts location. 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 ensure ACI has the right information to make the right decisions.

This role is ideal 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.

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
• 3 Weeks Paid Time Off
• Short and Long Term Disability coverage
• Fitness reimbursement
• Medical, dental, vision and life Insurance
• 401K
• Tuition Reimbursement
• Paid Holidays
• PTO (Paid time off)