Prophet 21 Analyst with Dynachange

Position Title:

System Analyst

Job Description:

System analyst position providing DBA and system support for ERP (Prophet21), cloud-based reporting databases and document management software. API integration and development with ERP and outside solutions. Extensive report generation via SQL queries and data analysis will be required. Ability to work with end-user requirements to develop ad-hoc reports. Help to develop systems documentation and development roadmaps.

Job Requirements:

* Prophet 21

* 5+ years of Prophet 21/Epicor ERP required
* Must have ERP administrative experience, preferably with Prophet 21
* Experience with Dynachange Portals and Rules
* Knowledge of production, financial and supply chain management
* Distribution industry experience preferred.



* SQL/DBA knowledge in the following areas:

* Administer SQL Server backup and recover.
* Creation, scheduling, and monitoring of SQL Server jobs.
* Using SQL Profiler for troubleshooting and performance analysis.
* Using SQL Events for real-time monitoring and alerting.
* Database maintenance, including index, statistics, and storage management.
* Log shipping.

* Development/Reporting requirements:

* In-depth knowledge of writing TSQL code.
* Skilled in creating/using views, functions, and stored procedures.
* Creation/maintenance of SQL Server Reporting Services (SSRS) reports.
* Knowledge of Crystal Reports.

* Programming/Automation requirements:

* Creation/maintenance of SQL Server Integration Services (SSIS) data transformation packages.
* Writing SSIS Script Task code in C#.
* Familiar with the following languages: C#, VBScript, PowerShell.
* Familiar with the following tools: Visual Studio, Report Builder, Crystal Reports Designer, Postman.





Salary Range is 100-130k/year



This is a remote + Travel (25%) Position