Business System Analyst
6 - 10 years
Hickman, CA
Full-time
Hybrid
1 month ago
About the role
Dave Wilson Nursery is seeking an ERP & Business Systems Analyst to support the modernization of our operational systems during a major ERP and business systems transformation. This role bridges business operations and technology, partnering with teams across production, inventory, sales, and administration to improve workflows, migrate data from legacy applications, and build reporting and automation tools using Microsoft technologies.
The ideal candidate combines strong analytical and systems skills with a practical, hands-on approach to solving operational problems. Experience in modernizing legacy or highly customized business processes is highly valued. This is an opportunity to play a key role in transforming how data and systems support one of the country’s leading nursery operations.
Responsibilities
ERP & Business Process Support
Requirements
Benefits:
The ideal candidate combines strong analytical and systems skills with a practical, hands-on approach to solving operational problems. Experience in modernizing legacy or highly customized business processes is highly valued. This is an opportunity to play a key role in transforming how data and systems support one of the country’s leading nursery operations.
Responsibilities
ERP & Business Process Support
- Serve as the day-to-day technical liaison between Admin, Accounting, Sales, Inventory, and Production teams and the ERP implementation team
- Gather and document business requirements; map current-state processes and help design future-state workflows in ERP
- Configure ERP modules, screens, lists, and user roles in coordination with the Director of Business Operations and ERP consultants
- Build, validate, and load master and transactional data during cutover and ongoing operations, including:
- Items, varieties, and blocks
- Customers, vendors, and pricing
- Bills of materials and inventory
- Participate in test planning and execution (unit, integration, UAT, and parallel runs) and track issues to resolution
- Develop user training materials, quick-reference guides, and SOPs; train users on-site or in classroom settings, or coordinate outside trainers as needed
- Provide hyper-care support during and after go-live; triage tickets, document fixes, and escalate to vendors when appropriate
- Microsoft Business Applications & Legacy Modernization
- Partner with business users to document what our custom-built legacy applications do today — the workflows, business rules, data, and edge cases that have built up over the years
- Help evaluate whether each legacy capability should be retired, absorbed into ERP, or rebuilt on the Microsoft stack
- Write and maintain SQL against SQL Server and related databases to migrate, transform, and validate data moving off legacy systems
- Plan and execute data migrations from legacy applications, including mapping, cleansing, cutover, and reconciliation
- Coordinate parallel runs and phased cutovers so the business is never left without a working tool
- Data Migration & Reporting
- Write and maintain SQL queries, views, and stored procedures against ERP and related databases to support reporting and data validation
- Design, build, and maintain Power BI dashboards and reports for admin, sales, inventory, and production users
- Partner with department and division leaders to define meaningful, measurable metrics tied to source-of-truth systems
- Monitor data quality, identify root causes of data issues, and work with process owners to correct them at the source
- Provide ad-hoc analytical support on inventory, production, sales, and operational questions as they arise
- Systems Integration
- Support integrations between ERP and adjacent systems, including:
- APIs and web services
- EDI connections with customers and vendors
- Label, barcode, and printing systems
- Handhelds and other devices used in the yard and shipping
- Prepare detailed specifications from which integrations and reports can be built or modified
- Coordinate with internal stakeholders and external vendors to scope, test, and deploy integrations
Requirements
- 5+ years of experience in a business systems analyst, ERP support, or business applications role, ideally in manufacturing, agriculture, distribution, or inventory-driven operations
- Technical & Systems Experience
- Hands-on experience with the Microsoft business technology stack, including some combination of:
- Power Apps (canvas and/or model-driven)
- Power Automate
- Power BI
- Dataverse and/or SharePoint
- Microsoft 365 administration basics
- Proficiency writing SQL against SQL Server or comparable relational databases
- Experience migrating users and data off custom-built or legacy applications onto modern platforms is strongly preferred
- Familiarity with integration concepts and tools such as APIs and file-based interfaces
- Advanced Excel skills and comfort working with large datasets
- Experience with ERP systems (Agriware, Business Central, NetSuite, SAP, Microsoft Dynamics, or similar)
- Light scripting or development experience (PowerShell, C#, Python, or similar) is a plus.
Benefits:
- 401(k)
- Dental insurance
- Flexible schedule
- Health insurance
- Paid time off
- Vision insurance
Skills
FarmingInformation Technology