We are seeking an experienced Prophet 21 SQL Developer to support a large-scale ERP implementation and data migration initiative involving the transition from Microsoft Great Plains (GP) to Epicor Prophet 21 Cloud. This is a hands-on technical role focused heavily on data build activities, SQL development, troubleshooting, and backend ERP data support.
This is a remote, part-time contract opportunity expected to last 6+ months, with the potential for extension based on project needs.
Key Responsibilities
- Support data build and migration efforts from Great Plains (GP) into Prophet 21 Cloud
- Develop, troubleshoot, and optimize complex SQL queries, stored procedures, views, and triggers
- Assist with data validation, cleansing, transformation, and reconciliation activities
- Work closely with ERP implementation teams, business users, and technical resources to support data conversion requirements
- Identify and resolve data integrity and performance issues within the P21 environment
- Support reporting and backend data structures related to the implementation
- Participate in testing activities and provide ongoing troubleshooting support throughout the implementation lifecycle
- Document development work, data mappings, and technical processes as needed
Required Experience
- Strong hands-on experience with Epicor Prophet 21 (P21)
- Advanced Microsoft SQL Server development skills
- Extensive experience building and supporting ERP-related data structures
- Strong experience with:
- SQL queries
- Stored procedures
- Triggers
- Data troubleshooting and performance tuning
- Experience supporting ERP implementations or migrations
- Prior experience working with data conversions from Great Plains (GP) or similar ERP systems
- Ability to work independently in a remote consulting environment
- Strong communication and problem-solving skills
Preferred Qualifications
- Experience with SSIS (SQL Server Integration Services)
- Experience with Prophet 21 Cloud environments
- Background supporting manufacturing, distribution, or supply chain organizations
- Familiarity with ERP reporting and integrations
Project Details
- Remote opportunity
- Part-time consulting engagement
- 6+ month project
- Focused on a new Prophet 21 Cloud implementation and data migration effort
- Immediate need for an experienced resource who can contribute quickly
If you have deep SQL expertise combined with hands-on Prophet 21 experience and enjoy solving complex ERP data challenges, we would like to speak with you.