Business Systems Analyst & Developer

Description

SUMMARY

The Business Systems Analyst & Developer is a hybrid business analysis and technical development role responsible for translating business needs into practical technology solutions. This position partners with stakeholders across Operations, Supply Chain, Warehouse, Production, Finance, Sales, and other functional areas to understand business processes, identify opportunities for improvement, and design, develop, integrate, and support solutions that improve efficiency, data visibility, and decision-making. The role combines business systems analysis, application development, systems integration, process automation, reporting and business intelligence, and enterprise application support. It also plays an important role in modernizing legacy processes and advancing the organization’s digital transformation initiatives.

ESSENTIAL DUTIES AND RESPONSIBILITIES (Other duties may be assigned)

Business Systems Analysis & Solution Design

• Partners with business users and leaders to understand business objectives, processes, challenges, and technology needs.

• Gathers, analyzes, documents, and refines business and functional requirements, user stories, workflows, and acceptance criteria.

• Maps current-state and future-state processes to identify opportunities for process improvement, automation, integration, and system enhancement.

• Translates business requirements into functional specifications, technical requirements, data flows, and practical solution designs.

Application Development & Systems Integration

• Designs, develops, configures, tests, implements, and maintains business applications, scripts, web services, database solutions, and supporting components.

• Designs, develops, and maintains secure integrations among ERP, CRM, PIM, eCommerce, WMS, EDI, shipping, labeling, BI, and other enterprise or third-party platforms.

• Develops and supports APIs, web services, data pipelines, ETL processes, file-based interfaces, middleware integrations, and automated data exchanges.

• Enhances and modernizes existing applications and legacy solutions to improve functionality, reliability, maintainability, performance, and user experience.

• Troubleshoots application and integration issues, performs root-cause analysis, and implements sustainable corrective solutions.

Digital Transformation & Process Automation

• Evaluates manual, repetitive, and legacy business processes and identify opportunities for automation and modernization.

• Designs and implements scripted, workflow-based, low-code, or application-based solutions that reduce manual effort and improve process consistency.

• Participates in digital transformation initiatives involving enterprise applications, systems integration, data, reporting, eCommerce, CRM, PIM, and other business technologies.

• Evaluates existing solutions and recommends improvements that increase efficiency, scalability, reliability, and business value.

Data, Reporting & Business Intelligence

• Develops and optimizes SQL queries, stored procedures, views, data extracts, and data pipelines supporting applications, integrations, reporting, and analytics.

• Designs and maintains data models, dashboards, operational metrics, and automated reports using Phocas BI and other approved reporting and analytics platforms.

• Maintains data integrity and consistency across interconnected systems and troubleshoot data discrepancies and reporting issues.

• Works with business stakeholders to define meaningful operational metrics and provide accurate information that supports business and leadership decision-making.

Enterprise Applications & Operational Support

• Provides advanced functional and technical support for ERP and other business-critical applications, including IBM i-based systems and integrated enterprise solutions.

• Supports application enhancements, configuration changes, upgrades, data migrations, new modules, interfaces, and third-party solutions.

• Investigates production application, integration, reporting, and data issues and coordinate resolution with internal resources and external vendors as appropriate.

• Provides technical guidance and training to users and supports ongoing system enhancements as business requirements evolve.

Testing, Quality Assurance & Documentation

• Develops test plans and test cases and perform unit, integration, system, regression, and user acceptance testing.

• Follows established software development lifecycle, change management, security review, source control, testing, and deployment practices.

• Maintains accurate technical and functional documentation, including solution designs, system diagrams, data mappings, interface documentation, test results, deployment procedures, and support documentation.

• Applies appropriate security, logging, monitoring, error handling, and coding practices to improve the reliability, maintainability, and supportability of solutions.

SUPERVISORY RESPONSIBILITIES

None required.

EDUCATION & EXPERIENCE

• 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.

• Experience supporting business-critical systems within a manufacturing, distribution, warehousing, or similar operational environment preferred.

CERTIFICATION, LICENSES, REGISTRATIONS

Relevant certifications or experience with IBM i, Microsoft technologies, business analysis, database platforms, cloud platforms, or application development are preferred.

SKILLS & ABILITIES

Technical Skills

• 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, preferably including IBM i-based systems, Smart Distributor, Microsoft Dynamics, Infor, or comparable platforms.

• 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 Phocas BI, Power BI, or comparable business intelligence platforms.

• Working knowledge of software development lifecycle practices, source control such as Git, testing methodologies, deployment practices, and change management.

• Familiarity with process automation, low-code solutions, cloud technologies, and modern integration platforms is preferred.

Business Systems & Analytical Skills

• 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 existing processes and identify opportunities for system improvement, integration, automation, and modernization.

• Strong written and verbal communication skills with the ability to communicate effectively 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 with the ability to work effectively with business users, IT team members, management, and external vendors.

PHYSICAL DEMANDS

Work involves standing and walking for brief periods of time, but most duties are performed from a seated position. There is potential for eye strain from reading detailed materials and looking at a computer screen. Work normally requires finger dexterity and eye-hand coordination to operate computer keyboards at a moderate skill level. The employee frequently is required to talk or hear.

TRAVEL REQUIREMENTS

If travel is requested, a valid government driver’s license and an acceptable driving record, as determined by company standards and insurer requirements, are required. All vehicles operated for Company purposes must be legally registered with appropriate government authorities.

WORK ENVIRONMENT

The noise level in the work environment is usually quiet. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

FLSA: Exempt