About Us
At Open Farm we are transforming the way people feed their pets, with a focus on producing premium, healthy food and treats, all ethically sourced from farm-to-bowl. Headquartered in Toronto and with team members across the US, Open Farm is one of the fastest growing CPG companies in North America. We believe that the best foods are made with consciously sourced, top-quality ingredients from farmers and fisheries who believe in doing good for all animals and the environment.
The Opportunity
Open Farm's data currently lives across NetSuite, NSAW, Shopify, and Salsify, with too much of the business still running on manual spreadsheet tracking. That is the problem you would be solving.
We are looking for a Business Systems Data Engineer to build the data infrastructure that gives the business consistent, reliable reporting. This is a full-time internal role reporting to the IT Director. You will be the primary technical owner of our data pipelines, data models, and reporting layer relied on by Operations, Finance, and eCommerce, with a strong secondary focus on connecting our platforms through API-based integrations. AI tooling is a core part of how this role operates, not an afterthought.
What You Will Own and Drive
Data Architecture and Engineering
Build and maintain ELT pipelines moving data from NetSuite, Shopify, Salsify, and other source systems into the reporting environment
Develop and maintain data models, workbooks, and SuiteAnalytics reports in NSAW as the primary near-term reporting layer
Apply data transformation practices (dbt or equivalent) to keep logic version-controlled, tested, and documented
Replace manual spreadsheet-based tracking with system-driven, auditable data flows
Document data models, pipeline logic, and reporting structures clearly for stakeholders and future developers
Platform Connectivity and Integrations
Design and build integrations connecting Open Farm's platforms, with the data warehouse as the central hub
Develop and consume REST APIs and webhook-based integrations with proper authentication (OAuth 2.0, API keys, tokens), error handling, retry logic, and monitoring
Manage and troubleshoot existing integration pipelines built on Celigo and NetSuite Oracle Integrator (NSIP)
Replace fragile FTP and CSV-based data exchanges with direct, auditable system-to-system connections
Maintain and extend existing integrations between NetSuite and Shopify, Salsify, EDI partners, and WMS
ERP Working Knowledge
Read, troubleshoot, and make minor modifications to existing configurations and scripts within the organization's ERP (currently NetSuite); basic literacy required, advanced development is owned by another team member
Build and maintain saved searches and reporting workbooks within the ERP to support reporting needs
Understand the ERP's core data model in sufficient depth to model it accurately downstream
AI-Driven Automation
Use Claude, Claude Code, and equivalent tools as active components of the development workflow
Build API-level integrations with LLM services to embed AI capability into data workflows and broader business processes
Identify manual, repetitive processes across the business that are strong candidates for AI-assisted automation and develop the solution
Apply a practical, grounded approach to AI adoption that accounts for both capabilities and limitations
Development Practices
Write clean, maintainable, well-documented SQL and Python for data pipeline and automation work
Manage all code through Git/GitHub including branching, pull requests, and documented change history
Write unit and integration tests as a standard part of development
Respond to data and pipeline issues with urgency and structured troubleshooting
What You Bring to the Table
Required
4+ years of hands-on experience in data engineering, analytics engineering, or a business systems role with a significant data component
Strong SQL proficiency for data extraction, transformation, and reporting
Hands-on experience building ELT/ETL pipelines with dbt or equivalent
Experience with NSAW or Snowflake for data modeling and reporting; both is a strong plus
Working proficiency in Python for scripting, automation, and pipeline development
Substantial experience designing and building integrations using REST APIs and webhook-based patterns, including authentication and end-to-end delivery
Practical experience using AI/LLM tools in a development or business workflow
Ability to work independently as a primary technical resource and deliver without close oversight
Clear written and verbal communication, including translating technical decisions into plain language for business stakeholders
Strong Asset
SuiteScript literacy, from basic ability to read and modify existing scripts up to development experience with SuiteScript 2.0/2.1
Git/GitHub proficiency applied as a standard development practice
Hands-on experience with Celigo, NSIP, or a comparable middleware platform
Experience evaluating or migrating between data warehouse platforms
SOAP API integration experience in addition to REST
Experience with MCP (Model Context Protocol) for connecting AI tools to internal systems
EDI systems experience (e.g. TrueCommerce) and WMS integration
Shopify integration experience at the API level beyond connector configuration
Salsify or other PXM platform integration experience
NetSuite SuiteFoundation or SuiteCloud Developer certification
Background in consumer goods, food and beverage, or supply chain-intensive industries
AI Statement:
Open Farm may use AI tools to help organize and review applications efficiently. While technology supports our process, every hiring decision is made by our team, with care and intention. We also prioritize meaningful human connection, which is why our interview process includes in-person conversations—because technology can support the process, but can’t replace the impact of human connection.
Compensation:
The hiring range for this role is $100,000 - $130,000 annually, with final compensation thoughtfully aligned to your experience, skills, and the value you bring. At Open Farm, we know great people don’t always fit a mold, so role scope and compensation may evolve to reflect your unique strengths. This position may also include additional rewards such as performance-based bonuses and other incentives. We believe in growing together through a pay-for-performance approach that recognizes impact over time. Beyond compensation, we’re proud to offer a comprehensive benefits and perks package designed to support your well-being and help you feel connected, supported, and inspired at work.
Hybrid Work
At Open Farm, we believe in the power of collaboration, meaningful connections, and enjoying our work together—furry friends included! That’s why we’ve adopted a structured hybrid approach that allows you the benefit of a reduced commute while still building strong workplace relationships. Currently, all employees are expected to be in the office two days per week at minimum, with Tuesday and Thursday as our anchor days. In addition to this, each month our Leadership team dedicates three consecutive days onsite to continue to foster alignment and connection across the team. During this time we expect everyone to join us in person to do the same. Please note: our hybrid approach may evolve over time as we adapt to the needs of our team and business.
Vacancy Type: New Vacancy
Our Values
We Raise the Bar | We Open the Barn Doors | We Graze Lightly | We Are Customer Obsessed | We Are One Team | Win-Win Partnerships
To learn more about Open Farm, follow us on Instagram and LinkedIn .
Open Farm values diversity in its workforce and encourages applications from all qualified individuals. Applicants requiring a disability-related accommodation at any stage of Open Farm's recruitment process should contact hr@openfarmpet.com. As required by legislation, Open Farm will consult with applications requesting such an accommodation to ensure that Open Farm's recruitment process takes into account their accessibility needs.