Application Administrator (Epicor P21 Focus)

Job Title: Application Administrator (Epicor P21 Focus)

Location: Livonia, MI (Local Candidates Only) Employment Type: Full-Time & On-Call

About E & E Tech

E & E Tech is a fast-growing Managed Services Provider (MSP) dedicated to delivering cutting-edge IT solutions with rapid response times and expert service. Our team thrives on innovation, efficiency, and delivering superior technology solutions that go beyond quick fixes.

We are specifically looking for a highly detail-oriented and technically skilled Application Administrator with deep expertise in Epicor Prophet 21 (P21). This role will serve as the subject matter expert for the P21 ERP environment while supporting integrations, SQL backends, and workflow automations.

Key Responsibilities

Epicor P21 Management & Administration:

• Serve as the primary administrator for Epicor Prophet 21, managing user security, role-based access, and system settings.
• Manage P21 application environments (Smart Client and Web Client), including coordination of upgrades, patches, and service pack installations.
• Utilize DynaChange Rules and Screen Designer to customize the user interface and logic to fit business requirements.
• Manage environments including Development (Dev), Testing (Test), and Production (Prod), ensuring smooth promotion of code and configurations.

Data, Reporting & SQL Optimization:

• Manage Microsoft SQL Server specifically for P21, including writing complex queries, views, and stored procedures to extract data.
• Develop and maintain reports using Crystal Reports, SSRS, and Power BI, ensuring accurate financial and inventory data representation.
• Monitor database performance and troubleshoot locking or latency issues within the ERP.

Integrations & API Management:

• Build, configure, and maintain the P21 API for system integrations (e.g., connecting P21 to e-commerce platforms, shipping software, or CRM tools).
• Read, interpret, and configure workflows using XML and JSON for data interchange.
• Manage ODS (Operational Data Store) connectors and ensure accurate data synchronization between P21 and third-party tools.

Microsoft & Cloud Administration:

• Administer and support Azure environments hosting application resources.
• Work with Windows Server environments to support the P21 middleware and database servers.

Workflow Automation & Support:

• Analyze business processes (Order Entry, Inventory, Purchasing) and implement automation solutions to enhance efficiency within the ERP.
• Troubleshoot and resolve application errors, acting as the Tier 2/3 support for internal P21 issues.
• Create comprehensive documentation for P21 configurations, DynaChange rules, and custom integrations.

Qualifications & Skills

Required Technical Skills:

• Demonstrated experience administering Epicor Prophet 21 (P21) is required.
• Strong understanding of Microsoft SQL Server, with the ability to write complex T-SQL queries and perform performance tuning.
• Experience with DynaChange Business Rules, Screen Designers, and UD (User Defined) tables.
• Proficiency in reporting tools, specifically Crystal Reports and Power BI.
• Experience with P21 API configuration and general API concepts (REST/SOAP, JSON, XML).
• Experience with Azure administration and Windows Server management.

Preferred Skills:

• Background in distribution or manufacturing environments.
• Experience integrating P21 with e-commerce platforms (e.g., Magento, BigCommerce) or shipping solutions (e.g., WorldShip, ShipStation).
• Familiarity with ITSM platforms such as Autotask, ServiceNow, or ConnectWise.

Soft Skills:

• Highly detail-oriented with strong problem-solving skills.
• Ability to work independently and prioritize multiple tasks effectively.
• Strong communication skills to collaborate with technical teams and non-technical business stakeholders (accounting, sales, warehouse).

Why Join E & E Tech?

• Work with a growing and innovative IT solutions provider.
• Be part of a collaborative and forward-thinking team.
• Competitive salary and opportunities for professional development.
• Exposure to cutting-edge cloud, automation, and integration technologies.

If you are a detail-driven Administrator with a background in Epicor P21 who thrives on optimizing workflows and automating processes, we'd love to hear from you!