Technical Solutions Analyst

Technical Solutions Analyst Galco Industrial Electronics - 2.7 Madison Heights, MI Job Details Full-time 1 hour ago Qualifications Systems integration Authorization controls implementation Software coding Database security hardening Enterprise software support Database security management Development environments Programming languages Data access controls implementation Integration with Third-Party Services (system development) Systems analysis Access control management Data encryption implementation Query management Developer tools Shell Scripting Production troubleshooting Full Job Description G alco 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. T he 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 ecommerce, Microsoft Azure, SQL databases, reporting tools, and related business applications. T his 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. D ata security, system reliability, and clear communication are essential. This position works closely with IT, operations, finance, sales, ecommerce, warehouse, purchasing, and customer service teams. T his position is on-site in Madison Heights, MI, and reports to the Solutions Architect within the IT department. K ey Responsibilities S upport, configure, and enhance Epicor Prophet 21 ERP functionality across order management, inventory, purchasing, finance, pricing, warehouse, and customer service processes. S upport integrations between Epicor P21, Magento ecommerce, Azure services, SQL databases, APIs, third-party applications, and internal business tools. T roubleshoot system, data, reporting, and integration issues across ERP, ecommerce, database, cloud, and business application environments. W rite, troubleshoot, and optimize SQL queries, views, scripts, reports, data extracts, and related database objects. A ssist Finance and business teams with reporting, data validation, reconciliation, and process improvement. U se 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. D evelop or maintain scripts, automations, scheduled jobs, imports, exports, and lightweight utilities using appropriate tools such as SQL, PowerShell, Python, JavaScript, or similar technologies. A ssist with Microsoft Azure administration, monitoring, security, identity/access control, storage, networking, and cloud-based integrations. A pply data security best practices, including least privilege access, credential protection, secure data handling, and proper permission management. P artner with business users to understand requirements, improve workflows, reduce manual processes, and support system changes. C reate technical documentation, process documentation, and user training materials as needed. S upport testing, validation, deployment, and post-deployment troubleshooting for system changes and enhancements. R equired Qualifications B achelor'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. H ands-on SQL experience, including writing queries and working with relational databases. E xperience supporting ERP systems, preferably Epicor Prophet 21 in a distribution, wholesale, manufacturing, or ecommerce environment. E xperience troubleshooting integrations between ERP, ecommerce, databases, APIs, cloud services, or third-party business applications. F amiliarity with scripting or programming tools such as PowerShell, Python, JavaScript, C#, or similar technologies. P ractical experience with technical tools such as SQL Server Management Studio, Visual Studio Code, Git, Postman, browser developer tools, or similar development and troubleshooting tools. U nderstanding of data security principles, including access control, least privilege, credential management, encryption, and secure handling of business/customer data. S trong analytical, troubleshooting, communication, and documentation skills. P referred Qualifications E picor Prophet 21 experience as a technical analyst, administrator, developer, super-user, or implementation team member. E xperience with Magento, Adobe Commerce, Shopify, or other ecommerce platforms. E xperience with Microsoft Azure services, including identity, networking, storage, monitoring, automation, security, or integration services. E xperience with APIs, EDI, middleware, scheduled jobs, data imports/exports, or file-based integrations. E xperience with Power BI, SSRS, Tableau, Crystal Reports, or other reporting and business intelligence tools. E xperience supporting ERP-based financial, inventory, sales, purchasing, or operational reporting. F amiliarity with source control, change management, CI/CD concepts, or DevOps practices. E xperience using AI-assisted coding or productivity tools in a controlled, secure, and professional environment. U nderstanding of distribution, wholesale, ecommerce, warehouse, inventory, purchasing, and order-fulfillment processes. R elevant certifications such as Microsoft Azure Administrator, Azure Solutions Architect, Azure Security Engineer, CompTIA Security+, or similar credentials. S oft Skills A ble to translate business problems into technical solutions. C omfortable working directly with users to gather requirements, diagnose issues, and validate solutions. S trong written and verbal communication skills. D etail-oriented when working with data, reporting, security, and production systems. A ble to manage multiple priorities across support requests, projects, enhancements, and urgent issues. C ollaborative across IT, operations, finance, sales, ecommerce, purchasing, warehouse, and customer service teams. P roactive, accountable, and willing to take ownership of complex issues through resolution. P osition Details L ocation: Madison Heights, MI W ork

Arrangement:

On-site D epartment: IT R eports

To:

Solutions Architect L