Microsoft Access Database Developer Jobs in California

Description

Overview:

Jensen Meat Company is seeking an ERP Business Systems Analyst to support and enhance the business applications that drive daily operations across the organization. This role serves as the primary technical owner of the company's Plex ERP environment and in-house Microsoft Access applications, ensuring system reliability, operational efficiency, and seamless integration across departments.

The ideal candidate will have strong experience supporting ERP systems in a manufacturing or distribution environment, with advanced technical expertise in SQL reporting, API integrations, Microsoft Access development, and process automation. This position works closely with Operations, Production, Finance, Shipping, and Sales leadership to translate business needs into scalable and reliable technical solutions.

This is not a help-desk or infrastructure role. Desktop support, network administration, and end-user hardware support are managed by the internal IT department. 

Primary Responsibilities:

ERP System Administration & Support

Administer and support the Plex ERP system, including user setup, workflows, system configurations, screen customizations, and issue resolution.
Maintain system integrity and ensure ERP processes align with operational and business requirements.
Support ongoing ERP optimization initiatives to improve workflow efficiency and reporting accuracy.
Assist with troubleshooting system issues and collaborate with internal stakeholders to implement sustainable solutions.

Microsoft Access Application Development

Maintain, enhance, and develop in-house Microsoft Access applications supporting production, inventory management, shipping, and operational reporting.
Develop and modify forms, queries, reports, VBA scripts, macros, and linked tables within Access databases.
Ensure long-term maintainability, reliability, and scalability of internally developed applications.

SQL Reporting & Data Analytics

Write, optimize, and maintain SQL queries, views, and stored procedures to support operational reporting and business intelligence initiatives.
Build and maintain recurring dashboards and reports for Production, Quality, Finance, Inventory, and Shipping teams.
Analyze business data and identify opportunities to improve reporting accuracy, visibility, and operational decision-making.

API Integrations & Process Automation

Design, build, and maintain API integrations between Plex ERP and third-party or internal systems using REST/SOAP APIs, JSON, and XML.
Support integrations involving EDI partners, customers, scales, label printers, reporting systems, and other operational platforms.
Identify opportunities to automate manual processes and improve system efficiency across departments.
Ensure proper documentation, testing, release management, and version control practices are maintained for integrations and custom solutions.

Cross-Functional Collaboration & Documentation

Partner with department leaders to gather business requirements and translate operational needs into practical technical solutions.
Train and support power users on Plex ERP functionality, reporting tools, and custom applications.
Develop and maintain technical documentation, workflows, system procedures, and process maps to support long-term operational continuity.
Collaborate with leadership on continuous improvement initiatives related to systems, automation, and operational scalability.

Requirements

Qualifications:

3+ years of hands-on experience supporting and developing ERP systems within a manufacturing or distribution environment.
Strong experience with Microsoft Access development, including forms, reports, queries, VBA, macros, and linked tables.
Advanced knowledge of SQL and relational databases, preferably Microsoft SQL Server.
Experience developing and supporting API integrations using REST/SOAP protocols, JSON, and XML.
Strong analytical, organizational, and problem-solving skills with attention to detail.
Ability to communicate technical concepts effectively to operational and non-technical stakeholders.
Experience with Plex ERP strongly preferred.
Experience within food manufacturing, meat processing, or regulated manufacturing environments strongly preferred.
Familiarity with Power BI, SSRS, or similar business intelligence tools preferred.
Familiarity with .NET, Python, or PowerShell scripting preferred.
Bachelor's degree in Information Systems, Computer Science, Business Technology, or a related field preferred; equivalent practical experience will also be considered.