Business Analyst

Barry-Wehmiller•Spokane, WA

4d•Onsite

About The Position

Alliance Machine Systems International, LLC is seeking a Business Systems Analyst to support the organization's Visual ERP environment and its data, reporting, and process infrastructure. This on-site role in Spokane, WA involves supporting and training users, troubleshooting issues, and driving process improvement. The position initially focuses on ERP administration and support, with opportunities for growth into broader business analysis. This is a hands-on, detail-driven role where the analyst will spend significant time managing data, running reconciliation checks, resolving anomalies in inventory, labor, and financial transactions, and educating departments on ERP system functionality and data interpretation. While deep SQL expertise is not required at hire, strong data fluency and an understanding of how transactional data flows through an ERP system are essential. Query-writing skills will be developed on the job, with support from AI-assisted tools. The team's mission is to empower organizational success through responsive ERP support, data analytics, and innovative solutions, emphasizing empathy and integrity in connecting people and systems.

Requirements

1–5 years of experience supporting an ERP system (any industry; Visual ERP experience not required).
Strong data fluency: comfort with relational database concepts, table relationships, and joins.
Willingness to learn manufacturing operations and data (BOMs, work orders, routings, labor reporting).
Strong troubleshooting instincts, attention to detail, and comfort with a disciplined daily process.
Ability to translate technical/data findings into plain-language explanations for non-technical stakeholders.
Strong teamwork and collaboration skills; works closely, in-office, with other analysts daily.
Sound judgment for prioritizing and multi-tasking across a substantial, ongoing project backlog.

Nice To Haves

Experience with Infor Visual ERP specifically.
Experience writing SQL queries (SQL Server) and/or working in SSMS.
Experience with report-writing tools such as Power BI, SSRS, Power Query, Crystal Reports, or Gupta.
Prior exposure to a manufacturing or product engineering environment.

Responsibilities

Review daily reconciliation queries across inventory, labor, and financial transactions, resolving anomalies.
Investigate and address data issues such as orphaned records, shipment discrepancies, and transaction errors.
Research and test ERP functionality to validate fixes, evaluate new features, and support process changes.
Manage ERP user setup, access, and basic system administration, including user license management.
Manage and oversee test databases, coordinating with corporate teams, technical support, and service providers.
Assist with configuration file updates and installing report software.
Provide formal and informal training on Infor Visual ERP functionality, processes, and best practices.
Support month-end close, including same-day resolution of time-sensitive costing anomalies and reconciliation items.
Develop, maintain, and modernize reports using various tools (Excel, SSRS, Gupta, Crystal Reports, Power BI, Synoptix).
Write SQL Server queries to select, update, and insert records, utilizing AI-assisted tools.
Provide data and information to corporate entities as needed.
Collaborate with stakeholders across departments to define business process requirements.
Assist with existing process improvement projects, with potential for independent ownership.
Support software implementation and upgrade efforts, including data conversions and migrations.
Create and maintain IT documentation and process documentation for other departments.
Serve as backup for other team members, working towards full cross-coverage.