Business Analyst, Revenue Operations

ABOUT KATE FARMS

Kate Farms is a company with heart. Our company was founded on the belief that good nutrition leads to good health, and good health opens the door to endless possibilities. That’s why our mission is to make nutrition the cornerstone of healthcare so people can live their best lives. We are a medical food company that makes complete nutrition formulas for people who have a medical need for liquid nutrition. 

Kate Farms works to be the place where a diverse mix of talented individuals want to come, stay, and do their best work. Ensuring a diverse and inclusive workplace where we learn from each other is at the core of Kate Farms’ values. We are an equal-opportunity employer and fully focused on equality; we believe deeply in diversity of race, gender, sexual orientation, religion, ethnicity, national origin, and all the other fascinating characteristics that make us different. We invite you to do the best work of your life with us at Kate Farms.

POSITION OVERVIEW

The Business Analyst will be a key member of the Revenue Operations team. Reporting to the team leader and directly supporting the Business Operations team as well as senior leaders across the company, the Analyst’s primary responsibility is to ensure that each customer is receiving the correct contract price and track contract fees and rebates.  The business analyst will also have the opportunity to work with key sales leaders across the company to understand their key business questions and the KPIs that drive them. The Business Operations & Pricing Analyst will work heavily with tools such as Excel, Power BI, and other licensed software.  This is an opportunity for a young professional who wants to have immediate impact at a small, fast-growth mission-driven company.  

WHAT YOU WILL DO

·        Lead the chargeback reconciliation process for the medical distributor business, working closely with other members of the business operations and finance teams.

·        Lead the monthly/quarterly/annual fee audit and rebate calculation process for distribution and channel partners.  Work across the team to ensure accruals are made, and payments are processed on time.

·        Assist in the creation and maintenance of automated reports and dashboards using Power BI, Excel, and proprietary software.

·        Work across the team and with other Kate Farms pricing and contract stakeholders to understand their core business challenges and utilize data to help uncover opportunities through data mining, mapping, modeling, and testing.

·        Coordinate with channel partners to validate and reconcile contract pricing discrepancies in a timely manner.

·        Work closely with all members of the Pricing and Contract Strategy team to prioritize projects across supporting the company while also completing work with efficiency and accuracy.

·        Complete ad hoc data requests for field account and channel leadership to help drive customer engagement and commercial growth.

·        Work at the center of the Kate Farms mission: use data and resulting models to uncover opportunities to serve more people and help them live their best lives.

WE ARE LOOKING FOR SOMEONE WITH

·        Strong commitment to company mission and values.

·        BS/BA in Business Administration, Finance, Economics, Accounting, Analytics, Mathematics, Statistics, Computer Science, or related fields with 0-2 years of experience in Marketing/Sales Analytics, Data Science, Operations Research, Consulting, or other work history/internships in relevant field.

·        Advanced knowledge of Excel (nested formulas including xlookup, sumifs, index/match, pivot tables, and power query).

·        Ability to present detailed but simple stories from complex data.

·        Ability to translate business questions and data into visualizations using Power BI, Tableau, or other visualization tools.

·        Curiosity and ability to understand not just the “Why?” but the “What now?” behind the data and trends.

·        Experience in Healthcare, biopharma, supply chain, and pricing experience preferred (experiential classes and internships count).

·        Python, R, SQL, Microsoft Visual Basic, or other programming experience preferred (class assignments and internships count).

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by the employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

·        Possess the ability to sit or stand at a computer for extended periods of time.