Technical Solutions Analyst
- Support, configure, and enhance Epicor Prophet 21 ERP functionality across order management, inventory, purchasing, finance, pricing, warehouse, and customer service processes.
- Support integrations between Epicor P21, Magento ecommerce, Azure services, SQL databases, APIs, third-party applications, and internal business tools.
- Troubleshoot system, data, reporting, and integration issues across ERP, ecommerce, database, cloud, and business application environments.
- Write, troubleshoot, and optimize SQL queries, views, scripts, reports, data extracts, and related database objects.
- Assist Finance and business teams with reporting, data validation, reconciliation, and process improvement.
- Use tools such as SQL Server Management Studio, Visual Studio Code, Git, PowerShell, Postman, browser developer tools, and scripting environments to diagnose issues and implement solutions.
- Develop or maintain scripts, automations, scheduled jobs, imports, exports, and lightweight utilities using appropriate tools such as SQL, PowerShell, Python, JavaScript, or similar technologies.
- Assist with Microsoft Azure administration, monitoring, security, identity/access control, storage, networking, and cloud-based integrations.
- Apply data security best practices, including least privilege access, credential protection, secure data handling, and proper permission management.
- Partner with business users to understand requirements, improve workflows, reduce manual processes, and support system changes.
- Create technical documentation, process documentation, and user training materials as needed.
- Support testing, validation, deployment, and post-deployment troubleshooting for system changes and enhancements.
- Bachelor’s degree in Computer Science, Information Systems, Business Information Systems, or a related field; equivalent experience will also be considered.
- 5+ years of experience in IT systems analysis, ERP support, systems integration, application support, solutions engineering, or a similar technical role.
- Hands-on SQL experience, including writing queries and working with relational databases.
- Experience supporting ERP systems, preferably Epicor Prophet 21 in a distribution, wholesale, manufacturing, or ecommerce environment.
- Experience troubleshooting integrations between ERP, ecommerce, databases, APIs, cloud services, or third-party business applications.
- Familiarity with scripting or programming tools such as PowerShell, Python, JavaScript, C#, or similar technologies.
- Practical experience with technical tools such as SQL Server Management Studio, Visual Studio Code, Git, Postman, browser developer tools, or similar development and troubleshooting tools.
- Understanding of data security principles, including access control, least privilege, credential management, encryption, and secure handling of business/customer data.
- Strong analytical, troubleshooting, communication, and documentation skills.
- Epicor Prophet 21 experience as a technical analyst, administrator, developer, super-user, or implementation team member.
- Experience with Magento, Adobe Commerce, Shopify, or other ecommerce platforms.
- Experience with Microsoft Azure services, including identity, networking, storage, monitoring, automation, security, or integration services.
- Experience with APIs, EDI, middleware, scheduled jobs, data imports/exports, or file-based integrations.
- Experience with Power BI, SSRS, Tableau, Crystal Reports, or other reporting and business intelligence tools.
- Experience supporting ERP-based financial, inventory, sales, purchasing, or operational reporting.
- Familiarity with source control, change management, CI/CD concepts, or DevOps practices.
- Experience using AI-assisted coding or productivity tools in a controlled, secure, and professional environment.
- Understanding of distribution, wholesale, ecommerce, warehouse, inventory, purchasing, and order-fulfillment processes.
- Relevant certifications such as Microsoft Azure Administrator, Azure Solutions Architect, Azure Security Engineer, CompTIA Security+, or similar credentials.
- Able to translate business problems into technical solutions.
- Comfortable working directly with users to gather requirements, diagnose issues, and validate solutions.
- Strong written and verbal communication skills.
- Detail-oriented when working with data, reporting, security, and production systems.
- Able to manage multiple priorities across support requests, projects, enhancements, and urgent issues.
- Collaborative across IT, operations, finance, sales, ecommerce, purchasing, warehouse, and customer service teams.
- Proactive, accountable, and willing to take ownership of complex issues through resolution.
- Location: Madison Heights, MI
- Work Arrangement: On-site
- Department: IT
- Reports To: Solutions Architect
- Level: Mid-level technical role
Recommended Jobs
Help Desk Level 2
Job Description Job Description Help Desk Agent The Help Desk role at K Group is a pivotal position responsible for efficiently coordinating and resolving technical issues reported by custom…
Construction/Installation Manager
Founded in 1956, the Jacuzzi® Brand has grown to become the modern-day Jacuzzi Group-- the premier manufacturer of functional products for the home and outdoor space found in more than 60 countries. …
Specimen Collector II- 1689
Full Time Specimen Collector II Location: Walled Lake, MI Schedule: Full-Time | Monday-Thursday 1pm to 9pm, Friday 9am-5pm Help make a positive impact in your community! Millennium Heal…
Membership Desk Services
Job Description Job Description Position : Member & Guest Services Associate Classification : Part-time Hourly, Non-Exempt Entity : The Christian Family Centre Reports To : Assis…
Metal Framing and Drywall Estimator
Metal Framing and Dry Wall Estimator Home Office Location: Grand Rapids, Michigan Position Classification: Full-time Regular About This Opportunity As a Metal Framing and Drywall Estima…
Business Development Associate
About Veryable At Veryable, our mission is to accelerate next generation capabilities in the manufacturing and logistics space by enabling businesses to scale production in real-time to changing nee…
Tax Associate
Tax Associate Hantz Group is a Michigan-based financial company that works with individuals and businesses to help them achieve their financial goals. We are a Family Office that manages over $11B…
Meat Team Member (Service Counter) - Part Time
Provides support as a member of the meat team to include duties related to counter service, stocking, and sanitation in the meat department. All Whole Foods Market Retail jobs require ensuring a pos…
Internal Client Care Coordinator
Job Title: Internal Client Care Coordinator Reports To: General Manager Location: Burton, MI Position Summary: The Internal Client Care Coordinator plays a vital role in ensuring exceptiona…
Education Professionals | Leadership-Focused Remote Opportunity
Summer Break Education Leadership Transition Opportunity | Remote & Flexible For many educators across the USA, the period leading into summer break — or the opportunity to reflect during it — can b…