Sql programmer Jobs in Fontana, CA

Position Overview
Our client, an established organization in the Aerospace & Defense manufacturing industry, is seeking an experienced Epicor Kinetic Analyst for an initial 3+ month remote contract engagement.

The ideal candidate will have strong hands-on experience with Epicor Kinetic ERP, including post-go-live support, data migration, system configuration, BAQs, BPMs, troubleshooting, and continuous process improvement.

This individual will play a critical role in stabilizing and optimizing the Epicor Kinetic environment following a recent implementation. The consultant will work closely with business users, IT teams, and functional stakeholders to resolve outstanding issues, clean up migrated data, improve system performance, and ensure the ERP platform supports day-to-day manufacturing and financial operations.

This is a hands-on technical-functional role, not a project management position. We are looking for someone who can independently investigate issues, recommend solutions, and execute necessary system changes.
Key ResponsibilitiesEpicor Kinetic Post-Go-Live Support

• Provide hands-on application support and troubleshooting within Epicor Kinetic.
• Identify and resolve outstanding post-implementation issues, configuration gaps, and system errors.
• Investigate problems involving transactions, business processes, data integrity, and system functionality.
• Support users across manufacturing, inventory, purchasing, sales, and finance.
• Analyze root causes of recurring issues and implement sustainable solutions.
• Work through an existing backlog of ERP support tickets, system enhancements, and cleanup activities.
• Assist with system stabilization, performance improvements, and user adoption.

Data Migration, Validation & Cleanup

• Analyze and correct data migration issues resulting from the Epicor Kinetic implementation.
• Utilize Epicor Data Management Tool (DMT) for data imports, updates, corrections, and cleanup.
• Validate master data, transactional data, and system relationships.
• Troubleshoot data inconsistencies involving customers, vendors, parts, BOMs, inventory, and financial transactions.
• Develop and execute data reconciliation and validation processes.
• Assist with SQL-based data analysis, reporting, and troubleshooting.
• Ensure data accuracy and integrity across integrated business processes.

Epicor Configuration & Customization

• Review, troubleshoot, and modify existing Epicor Kinetic configurations.
• Create, maintain, and optimize Business Activity Queries (BAQs).
• Develop, troubleshoot, and maintain Business Process Management (BPM) directives.
• Support Epicor Application Studio configurations and Kinetic user interface customizations.
• Troubleshoot Epicor Functions, business rules, and automated workflows.
• Review existing customizations for compatibility, performance, and usability.
• Assist with personalization, dashboards, user-defined fields, and role-based configurations.
• Identify opportunities to replace unnecessary customizations with standard Epicor functionality.

Manufacturing & Business Process Support

• Support core manufacturing processes, including:
  • Bill of Materials (BOM) and routing management
  • Job management and production reporting
  • Inventory control and warehouse transactions
  • Material Requirements Planning (MRP)
  • Purchasing and supplier management
  • Sales order processing and fulfillment
  • Engineering and manufacturing workflows
  • Costing, WIP, and inventory reconciliation
• Work with business users to identify process inefficiencies and recommend improvements.
• Support cross-functional troubleshooting involving manufacturing, supply chain, and accounting.
• Help users understand proper system functionality and transaction processing.

Reporting, Integrations & Technical Support

• Develop and troubleshoot BAQ reports, dashboards, and operational reporting.
• Support SSRS reporting and Epicor reporting tools.
• Investigate integration failures, data synchronization issues, and interface errors.
• Assist with REST API integrations and Epicor Automation Studio workflows where applicable.
• Utilize SQL Server and SQL queries to investigate system issues.
• Support system testing, regression testing, and validation of configuration changes.
• Document system changes, troubleshooting procedures, and recommended improvements.

Required Qualifications

• 5+ years of Epicor ERP experience, including substantial hands-on experience with Epicor Kinetic.
• Proven experience supporting Epicor Kinetic implementations and post-go-live environments.
• Strong hands-on experience with BAQ development, BPM configuration, and DMT data migration.
• Experience troubleshooting and modifying Epicor configurations and customizations.
• Strong understanding of manufacturing ERP processes and transactional workflows.
• Experience with SQL Server, SQL queries, and relational data structures.
• Ability to troubleshoot data integrity issues, system errors, and complex business process problems.
• Working knowledge of Epicor Application Studio and the web-based Kinetic interface.
• Experience supporting inventory, purchasing, production, and financial processes.
• Ability to work independently with limited supervision in a remote environment.
• Strong communication skills and experience working directly with end users.
• Ability to prioritize multiple support requests and deliver solutions quickly.
• Availability to support business operations during Pacific Time Zone working hours.

Preferred Qualifications

• Previous experience supporting Aerospace & Defense manufacturing organizations.
• Familiarity with aerospace manufacturing requirements, traceability, lot/serial tracking, and quality management.
• Experience with ITAR/EAR-controlled environments and applicable data access restrictions.
• Experience with Epicor Kinetic versions 2023, 2024, or 2025.
• Knowledge of Epicor REST APIs, Epicor Functions, and Automation Studio.
• Experience with C# or .NET for troubleshooting legacy Epicor customizations.
• Experience with Epicor MES, Advanced MES, or shop floor data collection.
• Familiarity with Epicor MRP, scheduling, engineering change management, and job costing.
• Experience with Epicor Security Groups, Menu Maintenance, and user access management.
• Knowledge of Epicor SSRS reports and dashboard development.
• Experience supporting multi-site or multi-company Epicor environments.
• Experience with Epicor Kinetic cloud or on-premises deployments.
• Ability to create user documentation, technical specifications, and knowledge transfer materials.

Ideal Candidate Profile
We are seeking a well-rounded Epicor Kinetic technical-functional analyst who understands both the technical configuration of Epicor and how the software supports real-world manufacturing operations.

The ideal consultant has successfully supported an Epicor Kinetic go-live and understands the challenges organizations face immediately after implementation, including data cleanup, unresolved customizations, user errors, workflow issues, and process optimization.

This person should be comfortable working directly with business users, identifying the root cause of issues, and making hands-on changes within Epicor to improve system functionality.

Most importantly, we need someone who can hit the ground running, take ownership of outstanding issues, and help stabilize the Epicor environment.
Contract Details

• Duration: Initial 3+ month contract with potential extension
• Location: 100% Remote
• Time Zone: Pacific Time Zone preferred;candidates in other time zones must be able to support Pacific business hours
• Industry: Aerospace & Defense Manufacturing
• Work Authorization: U.S. Citizenship or U.S. Lawful Permanent Resident status required, subject to the client's applicable export-control and regulatory requirements
• Start Date: As soon as possible

Equal Opportunity: All candidates will be considered in accordance with applicable employment and export-control laws. Any citizenship or permanent-residency restriction must be validated against the specific regulatory and contractual requirements of the engagement.