Business Systems Analyst & Developer

Handy Distribution•Lynchburg, VA

1d•$95,000 - $120,000

About The Position

The Business Systems Analyst & Developer is a hybrid business analysis and technical development role that translates business needs into practical technology solutions. The position partners with stakeholders across Operations, Supply Chain, Warehouse, Production, Finance, Sales, and other functional areas to understand processes, identify opportunities for improvement, and design, develop, integrate, and support solutions that improve efficiency, data visibility, and decision-making. The role spans business systems analysis, application development, systems integration, process automation, reporting and business intelligence, and enterprise application support. It also contributes to modernizing legacy processes and advancing digital transformation initiatives. The position provides advanced functional and technical support for ERP and other business-critical applications, including IBM i-based systems and integrated enterprise solutions. It develops and maintains applications, integrations, data solutions, reports, and automation; investigates production issues; and supports enhancements, upgrades, migrations, and third-party solutions. The role also works with business stakeholders to establish useful operational metrics and provides technical guidance and training to users. The work is primarily performed seated, in a usually quiet work environment. Travel may be requested; if so, a valid government driver’s license and an acceptable driving record are required.

Requirements

Bachelor’s degree in Computer Science, Management Information Systems, Information Systems, Software Engineering, Data Analytics, or a related field; equivalent relevant experience may be considered.
3–5+ years of combined experience in business systems analysis, application development, systems integration, enterprise application support, reporting/data analytics, or a related technology role.
Proficiency in one or more programming or scripting technologies such as RPG, CL, C#, .NET, Python, JavaScript, Java, PowerShell, SQL, or comparable technologies.
Strong SQL and relational database skills, including complex queries, stored procedures, views, data modeling, optimization, data validation, and troubleshooting.
Experience developing or supporting APIs, web services, REST/SOAP integrations, webhooks, ETL processes, data pipelines, and system interfaces.
Experience supporting ERP and enterprise business applications.
Familiarity with integrated business systems such as WMS, MES, EDI, CRM, PIM, eCommerce, shipping, barcode, labeling, and reporting platforms.
Experience developing reports, dashboards, operational metrics, and data models using a business intelligence platform.
Working knowledge of software development lifecycle practices, source control, testing methodologies, deployment practices, and change management.
Strong requirements gathering, process mapping, business analysis, troubleshooting, and root-cause analysis skills.
Ability to understand business processes and translate business needs into effective functional and technical solutions.
Ability to analyze processes and identify opportunities for system improvement, integration, automation, and modernization.
Strong written and verbal communication skills and ability to communicate with technical and non-technical audiences.
Ability to manage multiple priorities and projects while maintaining attention to detail, documentation quality, system accuracy, and operational stability.
Ability to learn new technologies and business processes and apply them to practical business needs.
Strong collaboration skills and ability to work effectively with business users, IT team members, management, and external vendors.

Nice To Haves

Experience supporting business-critical systems in a manufacturing, distribution, warehousing, or similar operational environment.
Relevant certifications or experience with IBM i, Microsoft technologies, business analysis, database platforms, cloud platforms, or application development.
Experience with IBM i-based systems, Smart Distributor, Microsoft Dynamics, Infor, or comparable ERP and enterprise application platforms.
Experience with Phocas BI, Power BI, or comparable business intelligence platforms.
Familiarity with process automation, low-code solutions, cloud technologies, and modern integration platforms.

Responsibilities

Partner with business users and leaders to understand objectives, processes, challenges, and technology needs.
Gather, analyze, document, and refine business and functional requirements, user stories, workflows, and acceptance criteria.
Map current- and future-state processes and identify opportunities for improvement, automation, integration, and system enhancement.
Translate business requirements into functional specifications, technical requirements, data flows, and solution designs.
Design, develop, configure, test, implement, and maintain business applications, scripts, web services, database solutions, and supporting components.
Design, develop, and maintain secure integrations among enterprise and third-party platforms, including ERP, CRM, PIM, eCommerce, WMS, EDI, shipping, labeling, and BI systems.
Develop and support APIs, web services, data pipelines, ETL processes, file-based interfaces, middleware integrations, and automated data exchanges.
Enhance and modernize applications and legacy solutions to improve functionality, reliability, maintainability, performance, and user experience.
Troubleshoot application and integration issues, conduct root-cause analysis, and implement sustainable corrective solutions.
Evaluate manual, repetitive, and legacy processes and identify opportunities for automation and modernization.
Design and implement scripted, workflow-based, low-code, or application-based solutions that reduce manual effort and improve consistency.
Participate in digital transformation initiatives involving enterprise applications, integration, data, reporting, eCommerce, CRM, PIM, and other business technologies.
Evaluate existing solutions and recommend improvements to efficiency, scalability, reliability, and business value.
Develop and optimize SQL queries, stored procedures, views, data extracts, and data pipelines for applications, integrations, reporting, and analytics.
Design and maintain data models, dashboards, operational metrics, and automated reports using Phocas BI and other approved platforms.
Maintain data integrity and consistency across systems and troubleshoot data discrepancies and reporting issues.
Work with business stakeholders to define operational metrics and provide accurate information for business and leadership decisions.
Provide advanced functional and technical support for ERP and other business-critical applications, including IBM i-based systems.
Support application enhancements, configuration changes, upgrades, data migrations, new modules, interfaces, and third-party solutions.
Investigate production application, integration, reporting, and data issues and coordinate resolutions with internal resources and external vendors.
Provide technical guidance and training to users and support system enhancements as business requirements evolve.
Develop test plans and test cases and perform unit, integration, system, regression, and user acceptance testing.
Follow software development lifecycle, change management, security review, source control, testing, and deployment practices.
Maintain technical and functional documentation, including designs, diagrams, data mappings, interface documentation, test results, deployment procedures, and support documentation.
Apply appropriate security, logging, monitoring, error handling, and coding practices to improve solution reliability and supportability.