About the role
Harney & Sons has been making and selling fine tea from Millerton, New York for over four decades. We are family-owned, we are growing, and we run our business through a single ERP system: tea production and blending, direct-store-delivery truck distribution, a Shopify storefront, and wholesale accounts across the country and overseas.
This role sits at the center of that. You will work inside SAP Business One to build the processes, reports, and tools the business runs on, and you will learn how tea gets blended, packed, loaded onto a truck, and delivered.
A meaningful share of the work is hands-on building. Our systems have to talk to each other — the ERP, the storefront, the shipping and distribution side — and the automations that connect them need someone who can write the queries and scripts behind them and prove they actually work.
You will report directly to the Director of ERP and Manufacturing Operations. The team is small, so your work is visible and you will see the results of what you build.
What you will do
- Develop and maintain processes in SAP Business One to support and streamline business operations..
- Build, test, and maintain automated workflows and integrations that move data between SAP Business One and the other systems in the tech stack, including writing the SQL and scripts they depend on.
- Continually validate results of queries, workflows, dashboards, and other automations to ensure that business decisions are being made with accurate information.
- Analyze operational data to surface trends and track down anomalies, then explain what you found.
- Spot gaps and friction in operations and proactively develop tech-driven solutions to streamline processes.
- Create reports and dashboards for increased business insights, while tracking adoption and end-user usage.
- Train end users, write the documentation, and measure adoption rates.
- Learn the Harney & Sons operation (production, distribution, ecommerce, and wholesale) well enough to spot problems before anyone files a ticket.
- When we work with outside implementation consultants, document requirements, track deliverables, and flag slippage early.
- Write clear progress updates and brief the departments affected by what you are building.
Who we are looking for
- You like taking apart how something works and figuring out why it breaks.
- You thrive in a cross-functional, collaborative work environment.
- You have already outgrown spreadsheets for the harder problems and reach for code when it is the better tool.
- You have strong communication skills and can communicate technical information in simple terms.
- You follow through: a small improvement that actually ships beats a big plan that never does.
- You can proactively spot and address errors and inefficiencies.
- You do not trust your own output until you have tested it. You care about data being right, and about keeping it secure.
- A bachelor’s degree in computer science, information systems, business, accounting, supply chain, or a related field — or equivalent hands-on experience.
Technical skills we need
- SQL. You can write joins and aggregations, read someone else’s query, and work out why a result set has the wrong row count. You do not need to be a database administrator.
- Scripting, ideally Python. Enough to read, modify, and debug a script that transforms data or calls an API, and enough appetite to write your own from scratch.
- APIs. A working understanding of requests and responses, authentication, pagination, and what happens when a call fails halfway through a batch.
- A testing instinct. When you build something that moves data, you should already be wondering how you would prove it moved the data correctly.
Helpful, but not required
- ERP exposure. Any system counts: SAP Business One, NetSuite, Dynamics, Acumatica, Epicor, or even a warehouse or accounting system you had to bend to your will.
- Integration or workflow automation platforms. Any low-code tool where you assemble a data flow visually but still write the logic and the queries underneath it.
- SAP Business One Service Layer or DI API, or any ERP’s API for reading and writing records programmatically.
- Reporting tools. Power BI, Tableau, or similar.
- Crystal Reports or SAP Business One Query Manager.
- Manufacturing, food and beverage, or distribution experience, particularly anything involving lot codes, expiration dating, or traceability.