Technical Solutions Analyst

Galco Industrial Electronics is an authorized distributor for over one million products from more than 400 brands. We specialize in industrial, electrical, and electronic automation, control, and component solutions. Our distribution center stocks over 50,000 products and offers same-day shipping and emergency service. We also provide repair and engineering services that support integrations, retrofits, and upgrades.

The Technical Solutions Analyst is responsible for supporting, improving, and integrating core business systems for a growing distribution company. This role works across Epicor Prophet 21, Magento e‑commerce, Microsoft Azure, SQL databases, reporting tools, and related business applications.

This is a hands‑on technical role requiring strong troubleshooting skills, SQL experience, familiarity with coding and scripting tools, and the ability to translate business needs into practical system improvements. The ideal candidate can support users, analyze data, troubleshoot integrations, write queries or scripts, and work with technical tools used in modern application and systems support.

Data security, system reliability, and clear communication are essential. This position works closely with IT, operations, finance, sales, e‑commerce, warehouse, purchasing, and customer service teams.

This position is on‑site in Madison Heights, MI, and reports to the Solutions Architect within the IT department.

• 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 e‑commerce, Azure services, SQL databases, APIs, third‑party applications, and internal business tools.
• Troubleshoot system, data, reporting, and integration issues across ERP, e‑commerce, 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, Power Shell, 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, Power Shell, 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 e‑commerce environment.
• Experience troubleshooting integrations between ERP, e‑commerce, databases, APIs, cloud services, or third‑party business applications.
• Familiarity with scripting or programming tools such as Power Shell, 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…