Business Analyst

Active Duty Staffing; West Fargo (ND); On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive benefit package

Opportunities for professional development

Job summary

A prominent staffing agency in West Fargo, ND, is seeking a Business Analyst to enhance their Sales, Inventory, and Operations Planning (SIOP) processes. The role involves analyzing needs, implementing technology solutions, and managing the SIOP database. Candidates should have a Bachelor’s Degree in Business Administration and 2+ years of relevant experience. The company offers a competitive salary and a comprehensive benefits package. Travel may be required, but is less than 10%.

Qualifications

• 2+ years of relevant experience in a business analyst role.
• Must have an understanding or ability to learn the SIOP Process and ERP Systems.
• IT Development and Database administration experience preferred.

Responsibilities

• Analyze and implement technology solutions for SIOP processes.
• Administer the SIOP database and generate planning reports.
• Support IT and Sales teams in technology and application development.

Skills

Understanding of Sales, Inventory & Operations Planning (SIOP)

Effective Communication and presentation skills

User of Lean Six Sigma Tools

VBA Programming

Advanced Oracle User

Education

Bachelor’s Degree in Business Administration

Tools

MS Office (including Microsoft Access)

Toad for SQL access to Oracle Databases

Job description

If you are looking for a company that offers a competitive salary, a comprehensive benefit package, and an opportunity to enhance your personal professional development, then this might be the perfect place for you.

Job Description

Business Analyst

OBJECTIVE

The purpose of this position is to analyze the Sales, Inventory & Operations Planning (SIOP) business process and needs and recommend and implement technology solutions, and support the back-end systems for the forecast process.

Key to this role is the development and administration of the Sales, Inventory & Operations Planning (SIOP) Database and corresponding Oracle and Manufacturing Resource Planning (MRP) applications. Generating the technical option forecast, maintaining the planning %s within Oracle. Support data flows (imports/exports) to support multiple systems. Perform data discrepancy analysis and implement solutions. Must possess skills in order to maintain, administer and build databases and data structures based on the needs of the business.

RESPONSIBILITY

Administration of the Information Technology (IT) Solutions supporting Sales, Inventory & Operations

Administer Sales, Inventory & Operations Planning (SIOP) database. Generate data extracts from database. Generates Monthly Sales, Inventory & Operations Planning (SIOP) Reports. Perform functional testing at the database and extract level (e.g., must understand how data is written to the database and subsequently extracted). Design, develop and implement Sales, Inventory & Operations Planning (SIOP) data warehouse, Oracle, and Manufacturing Resource Planning (MRP) processes to match the Resource Planning (ERP) software's core functionality. Develop/Administer tools to be used by the Sales, Inventory & Operations Planning (SIOP) Team to streamline current process. Perform data discrepancy analysis and implement solutions. Entering NAO Heavy forecasts into SAP. Support Item Maintenance.

SIOP Key Performance Indicator Reports

Develop and maintain SIOP KPI reports including pulling data from proper systems, validation of data accuracy and integrating automating updating where required.

Partner with Information Technology (IT) staff. Liaison between Information Technology (IT) and Sales, Inventory & Operations Planning (SIOP) Teams. Manage all aspects of technology and application development projects of varying sizes in support of assigned clients.

Key Support of the America’s Sales, Inventory & Operations Planning (SIOP) Process.

Update Forecasts in Sales, Inventory & Operations Planning (SIOP) Database. Support Demand Class Scheduling Project. Support Heavy Business. Support Compact Business. Support Attachment Business (Compact & Heavy). Support Portable Power Business. Lead root cause analysis on data issues. Support the Annual Operating Plan (AOP). Support the Long Range Plan (LRP). Support month end SIOP activities. Support the daily SIOP reports. Support SIOP data flows in/out of database to support multiple systems.

Generating Option Forecast

Generate technical Option Forecast for North America Supplied Options. Generate technical Option Forecast for North America Products supplied out of Dobris Plant. Perform Root Cause Analysis on Option Forecast gaps. Administer the North American option forecast. Work with Product Management on developing forecasts for new Options. Maintain the planning %s within Oracle.

Special Projects

Assist other areas where needed to support credit rebills, consignment, documentation needs, and other special requests.

Qualifications

KNOWLEDGE / EDUCATION / EXPERIENCE

Education Required: Bachelor’s Degree in Business Administration

Experience Required: 2+ years

Must have an understanding or ability to learn the Sales, Inventory & Operations Planning (SIOP) Process, Business Structure, Enterprise Resource Planning (ERP) Systems and BOM Structure

Effective Communication and presentation skills

User of Lean Six Sigma Tools

IT Development and Database administration preferred

Understanding of Bill of Material Structure, Material Requirements Planning, and the Global Sales, Inventory & Operations Planning (SIOP) Process a plus

Ability to use MS Office (incl. Microsoft Access), VBA Programming, Toad for SQL access to Oracle Databases, Advanced Oracle User.

Travel Required: < 10%

Additional Information

All your information will be kept confidential according to EEO guidelines.