Data Coordinator
Location: El Segundo, CA
Pay Rate: $43.87/hr W2
Duration: 1 Year
Shift: Hybrid
Job Description
-
Support operations and data activities across MSC, S&OP, Development, and General Operations.
-
Clean, consolidate, format, and maintain large datasets from multiple operational systems for daily, weekly, and monthly reporting.
-
Maintain and enhance Power BI dashboards and operational reports.
-
Identify manual data processes and streamline workflows using Excel formulas, Power Query, and basic VBA/Macros.
-
Support inventory tracking, supply chain metrics, and supply plan file maintenance.
-
Enter and maintain packaging, formulation, and master data specifications in internal systems.
-
Audit transactional data, investigate discrepancies, and maintain accurate operational records.
-
Perform system transactions, document uploads, checklist tracking, and data repository maintenance.
Education
-
Bachelor’s degree in Business, Supply Chain, Information Systems, or a related field preferred.
Required Skills
-
Advanced Microsoft Excel
-
XLOOKUP
-
INDEX/MATCH
-
Nested IF statements
-
Pivot Tables and Power BI
-
Power Query
-
Excel VBA/Macros
-
Large Dataset Management
-
Data Cleaning and Consolidation
-
Operational Data Reporting
-
Data Integrity and Reconciliation
-
Transactional Data Auditing
Preferred Skills
-
Power BI Dashboard Maintenance
-
Basic DAX
-
Power BI Data Source Connections
-
Supply Chain Operations
-
Inventory Tracking
-
S&OP Data Support
-
Supply Plan Maintenance
-
Packaging and Formulation Master Data
-
Master Data Management
-
Operational Systems/Data Platforms