Arrowhead Engineered Products
  • Jasper, IN, USA
  • Full Time

Summary:

Responsible for supporting the Company's Product Information Management (PIM) activities including data loading, extractions and data transformations.  Enthusiast in Agriculture, Automotive or Powersports preferred.

 

Duties:

  • Support the Product Information Management (PIM) System and item related data in the Arrowhead ERP System.
  • Assist business units with data intensive projects and loading large datasets into PIM and ERP Systems according to the set standards.
  • Analyze and Transform Excel Spreadsheet of Product Data into standard formats for PIM tool importing.
  • Utilize Microsoft Excel and other internal data management systems to build and enhance templates used for data gathering and data manipulation.
  • Contribute to data quality standards and guidelines and provide feedback to ensure standards are met.
  • Define requirements documents for PIM changes, reporting expectations, and other needs within the PIM systems.
  • Establish clear project expectations and requirements, timelines, and provide regular updates to key stakeholders.
  • Analyze Product Data for quality and enhancement opportunity to meet data quality standards and expectations of data channels (NetSuite, Websites, Catalogs, Channel Advisor).
  • Generate ad-hoc SQL Queries to extract relevant data from PIM tools to standard formats (CSV, Excel, Text).
  • Design and develop SQL Server Report Services Reports for standard reports.
  • Support rollout of PIM to additional channels and business units through:
    • Analysis of Legacy PIM tools
    • Documenting data maps and translations
    • Validating converted data
  • Create and maintain data mapping and translations used with PIM tools and Channels.
  • Ability to write and implement quality code in the PIM systems for the assigned system changes, adhering to established IT Policies and Procedures.
  • Provide IT Support for programmatically gathering product related data from external sources and effectively transforming product data into the PIM database.
  • Provide assistant to IT for hardware and software support for local personnel and systems.
  • Other duties as assigned.

 

Education and Qualifications:

High school diploma or GED required.

Bachelor's degree preferred.

3+ years of similar experience.

Strong communication skills and ability to interact with users to gather data and resolve issues.

Ability to develop effective working relationships across the organization.

Ability to lead and present in group settings.

Ability to understand master data relationships and rollups.

Strong attention to detail.

Excellent technical documentation.

Change management and user training experience.

Strong analytical skills and problem-solving ability.

Proficient in: Word, Excel and PowerPoint.

Strong Excel abilities (complex formulas, pivot tables, queries, data validations, etc.).

SQL server abilities (create tables, ad-hoc queries, procedures, functions, SSRS Reports).

General understanding of Ecommerce terminology and concepts.

 

Physical Demands:

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is frequently required to walk and reach with hands and arms. The employee is occasionally required to stand. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.  Specific vision abilities required by this job include close vision, color vision, depth perception and ability to adjust focus.

Arrowhead Engineered Products
  • Apply Now

    with our quick 3 minute Application!

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Follow Jobs:
  • Follow Our Jobs On Facebook
  • Share This Page
  • Facebook Twitter LinkedIn Email
.
logo stens logo jn logo