The Data Coordinator will support a critical data cleanup and preparation initiative focused on enabling USMCA product qualification activities. This role is responsible for improving the accuracy, completeness, and organization of product and supplier data across multiple business systems. The position will work closely with cross-functional teams to identify, validate, and compile information necessary to establish a reliable data foundation for future trade compliance qualification efforts.
This is a project-based assignment focused on data integrity and readiness rather than performing trade compliance or USMCA qualification analysis.
CORE FUNCTIONS
- Review, organize, and cleanse Bills of Material (BOMs) to ensure data accuracy and completeness.
- Identify, investigate, and resolve missing, inconsistent, or inaccurate product and material master data.
- Validate supplier information and compile supplier contact information for purchased components.
- Partner with Purchasing, Engineering, Finance, Operations, and other business functions to collect and verify missing information.
- Assist in validating material costs and compiling required cost elements, including labor and manufacturing overhead data.
- Extract, consolidate, and reconcile data from multiple ERP systems and other business applications.
- Develop tracking tools, dashboards, and status reports to monitor project progress and data completion.
- Document data sources, assumptions, and validation processes to ensure transparency and repeatability.
- Create a clean, organized, and well-documented dataset suitable for handoff to a future Trade Compliance Analyst or third-party USMCA qualification provider.
- Recommend opportunities to improve data quality and governance where appropriate.
- Perform other project-related analytical duties as assigned.
QUALIFICATIONS & REQUIREMENTS
Education and Experience
- Associate's degree in Business, Supply Chain, Data Analytics, Information Systems, or a related field, or equivalent combination of education and experience.
- 2+ years of experience in data analysis, manufacturing, supply chain, procurement, or a related analytical role.
Required Licenses
None
Skills, Abilities, and Knowledge
- Advanced Microsoft Excel skills, including PivotTables, XLOOKUP, Power Query, formulas, filtering, and data manipulation.
- Experience extracting, organizing, validating, and analyzing large datasets.
- Experience working with Bills of Material (BOMs), product master data, or manufacturing data.
- Strong analytical and problem-solving skills with exceptional attention to detail.
- Ability to manage multiple priorities while meeting project deadlines.
- Strong communication skills and the ability to work effectively with cross-functional teams.
- Experience analyzing data within manufacturing or distribution environments.
- Experience with multiple ERP systems (such as Manhattan, Great Plains, Infor, or similar) preferred
- Experience with supplier or procurement data preferred
- Experience using Power BI or similar business intelligence and reporting tools preferred
- Knowledge of product costing concepts.
- Familiarity with USMCA, trade compliance, or customs data (preferred but not required).
Travel
No travel required.
COMPETENCIES
- Analytical – Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs workflows and procedures.
- Attention to Detail – Produces accurate, high-quality work by carefully reviewing data for completeness, consistency, and errors. Maintains a high level of precision when validating information across multiple systems.
- Technical Proficiency – Demonstrates advanced proficiency in Microsoft Excel and experience working with ERP systems, Bills of Material (BOMs), and large datasets. Effectively extracts, manipulates, validates, and reports data using appropriate tools.
- Cross-Functional Collaboration – Builds productive working relationships with Purchasing, Engineering, Finance, Operations, and other stakeholders to gather information, resolve data discrepancies, and achieve project objectives.
- Planning and Execution – Organizes work effectively, manages multiple priorities, and monitors progress to ensure project milestones are achieved. Produces complete, accurate, and well-documented deliverables within established timelines.
- Initiative – Works independently with minimal supervision while proactively identifying tasks, anticipating obstacles, and driving projects to completion.
SUPERVISOR RESPONSIBILITIES
Individual Contributor: working team member with no oversight of others and no management responsibilities.
PHYSICAL REQUIREMENTS
This position is subject to sedentary work; exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time. Walking and standing are required only occasionally.
Physical Activities
This position is subject to the following physical activities: standing, walking, talking, hearing, and the use of hands, wrists, or fingers in a repetitive motion.
Visual Acuity
The worker is required to have close visual acuity to perform an activity such as preparing and analyzing data and figures; transcribing; viewing a computer terminal; expansive reading; visual inspection involving small defects, small parts and/or operation of machines (including inspection); using measurement devices; and/or assembly of fabrication of parts at distances close to the eyes.
Working Conditions
This position primarily operates in an office environment. This role routinely uses standard office equipment.
RealTruck is the premier manufacturer and digital destination of accessories for truck, Jeep®, Bronco® and off-road enthusiasts around the world. Globally headquartered in Ann Arbor, Michigan, RealTruck’s 6,000+ associates operate from 35+ facilities across four continents. RealTruck’s industry leading product portfolio, which includes the Husky Liners total vehicle protection brand, boasts over 1,000 patents and pending applications. The company’s omni-channel retail approach delivers a seamless consumer experience online at RealTruck.com, as well as through its 12,000+ dealer network and automotive (OEM) partnerships.