Open Farm Pet

Open Farm Pet

Data and Business Systems Engineer

Toronto, ON · Full-time

Sponsorship not specified$100k-$130kDetected 22 days ago
PythonGitSQLSnowflakeRESTOAuthdbtData EngineeringLLMsSupply ChainERPSystems EngineeringShopifyCommunicationPlain LanguageNetSuite

About the role

  • 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.
  • This is a full-time internal role reporting to the IT Director.

Responsibilities

  • What You Will Own and Drive
  • 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
  • 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)
  • Maintain and extend existing integrations between NetSuite and Shopify, Salsify, EDI partners, and WMS
  • Build and maintain saved searches and reporting workbooks within the ERP to support reporting needs
  • 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

Requirements

  • basic literacy required, advanced development is owned by another team member

Skills

  • Open Farm may use AI tools to help organize and review applications efficiently.
  • Use Claude, Claude Code, and equivalent tools as active components of the development workflow

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.

Company info

  • 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.
  • 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
  • Replace fragile FTP and CSV-based data exchanges with direct, auditable system-to-system connections
Apply directly at Open Farm Pet →Create a free account for alerts like thisView Open Farm Pet immigration profile

This listing is sourced directly from Open Farm Pet's careers page and normalized into a canonical job model.