Collation Planner: Data & VBA Specialist

Fanatics Commerce

Sunnyvale (TX)

On-site

USD 65,000 - 90,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Fanatics Commerce is seeking a Manufacturing Collation Planner to organize card mixes and sequences across the collation area. You will create layouts, reference files, and pick lists that guide production, ensuring accuracy and quality of the final product for customers.

The role requires strong Excel/Power Query and Power BI skills, VBA/macros proficiency, and attention to detail in a manufacturing setting. Collaboration with Process Engineering and Collation leads is essential.

Qualifications

  • Experience in manufacturing or production planning is preferred.
  • Proficient in Microsoft Excel and Access, preferably with Macros.
  • Proficient in VBA.
  • Skilled in Power Query.
  • Experienced with Power BI.
  • Strong numerical and analytical skills.
  • Teamwork and good communication.
  • Ability to follow written and verbal instructions.
  • Basic understanding of mathematics and ability to read and write.

Responsibilities

  • Receive direction from Area Managers on job priorities according to Job Scheduling.
  • Determine necessary Machine Operation or Manual Operation/QC reference files.
  • Prioritize jobs and coordinate with Collation Lead to complete the Deviation Log via Microsoft Form.
  • Utilize Collation Planner Checklist to validate each program prior to production.
  • Maximize use of resources and request assistance as needed.
  • Create and verify layouts using Pivot Tables and save files correctly.
  • Create Mix/Premix/Final Mix Reference Tables with Card details via Power Query.
  • Generate Characteristic and Picklist files and verify sequences before release.
  • Review layouts and ensure accuracy to ensure correct cards in each box.

Skills

Numerical skills
Analytical skills
Teamwork
Problem solving
Communication skills
Attention to detail

Education

High school diploma or equivalent

Tools

Excel
Access
VBA
Power Query
Power BI
Macros

Job description

Fanatics Commerce is seeking a Manufacturing Collation Planner to organize card mixes and sequences across the collation area. You will create layouts, reference files, and pick lists that guide production, ensuring accuracy and quality of the final product for customers.

The role requires strong Excel/Power Query and Power BI skills, VBA/macros proficiency, and attention to detail in a manufacturing setting. Collaboration with Process Engineering and Collation leads is essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Card Collation Lead: Precision & Process on Fast Line
Card Collation Lead: Precision & Process on Fast Line

Fanatics Betting & Gaming • Sunnyvale (TX)

On-site
USD 40,000 - 60,000
Collation Lead: Card Line Supervisor (On-Site)
Collation Lead: Card Line Supervisor (On-Site)

Fanatics • Dallas (TX)

On-site
USD 36,000 - 52,000
Collation Planner
Collation Planner

Fanatics Commerce • Sunnyvale (TX)

On-site
USD 65,000 - 90,000
Collation Lead: Card Line Supervisor
Collation Lead: Card Line Supervisor

Fanatics Collectibles • Sunnyvale (TX)

On-site
USD 42,000 - 62,000
Collation Lead
Collation Lead

Fanatics Betting & Gaming • Sunnyvale (TX)

On-site
USD 40,000 - 60,000
Card Collation Lead: Production, Quality & Team Leadership
Card Collation Lead: Production, Quality & Team Leadership

Mittera Creative + Tech • Arlington (TX)

On-site
USD 42,000 - 62,000
Medical
Dental
Vision
+5
Collation Lead: Card Production & Quality Lead
Collation Lead: Card Production & Quality Lead

Mittera Group • Arlington (TX)

On-site
USD 40,000 - 60,000
Medical
Dental
Vision
+5
Manufacturing Operations Coordinator & MRP Specialist
Manufacturing Operations Coordinator & MRP Specialist

Collins and Jewell • Fitchville (CT)

On-site
USD 60,000 - 75,000
Production Collator — Cabinet Parts & Quality Prep
Production Collator — Cabinet Parts & Quality Prep

Bellmont Cabinet Co. • United States

On-site
USD 22,000 - 30,000
Competitive compensation
Full health, dental, and vision
401(k) with company match
+3
Manufacturing Materials Planner – Finishing Ops
Manufacturing Materials Planner – Finishing Ops

Fanatics Inc. • Sunnyvale (TX)

On-site
USD 55,000 - 75,000