Support and enhance a heavily customized, SQL-based Sage ERP system to maintain and advance core business operations in a wholesale distribution environment.
Requirements
- 5+ years of hands-on ERP development experience with SQL-based platforms—preferably Sage 500 with significant customization.
- Proven expertise in .NET (C-Sharp or VB.NET) development for ERP extensions and integrations.
- Deep proficiency in T-SQL, including complex queries, indexing strategies, and performance tuning.
- Hands-on experience with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
- Strong understanding of VBScript within ERP scripting and automation contexts.
- Proven ability to work with REST/SOAP APIs for system integration.
- Proficiency with version control systems (e.g., Git), deployment pipelines, and basic DevOps practices.
Responsibilities
- Lead the design and architecture of ERP customizations using .NET, SQL (T-SQL), and VBScript in a Sage-based environment.
- Build and optimize high-performance stored procedures, triggers, views, and functions to support complex ERP functionality and reporting.
- Create and manage enterprise-grade data flows and integrations using SSIS and external APIs (REST/SOAP) for third-party platforms (e.g., WMS, EDI, eCommerce).
- Design and deliver advanced operational and financial reports using SSRS, Power BI, and other BI/reporting tools, with focus on performance and usability.
- Act as technical lead for ERP enhancement projects, managing solution design, task breakdown, peer reviews, and implementation.
- Troubleshoot and resolve ERP issues, conduct root cause analysis, and implement preventative improvements for performance and data integrity.
- Guide and support ERP system upgrades, patching, and rollout of new modules with minimal business disruption.
Other
- Collaborate with business stakeholders to analyze cross-departmental processes and propose technical solutions that align with business strategy.
- Produce and maintain clear technical documentation, including system architecture, development standards, and SOPs.
- Mentor junior developers and provide leadership in coding standards, problem-solving, and ERP best practices.
- Demonstrated ability to lead by example, with strong mentorship and code review practices.
- Excellent communication skills—able to translate business needs into technical solutions and vice versa.
