Operations & Data Specialist

Title: Operations & Data Specialist

Industry: Beauty

Location: El Segundo, CA

Duration: 12 months

Responsibilities

• Clean, consolidate, format, and audit large datasets from multiple operational systems to support recurring reporting and ensure data accuracy.
• Maintain and enhance Power BI dashboards, connect data sources, and identify opportunities to improve reporting efficiency.
• Use advanced Excel, Power Query, VBA/macros, and simple automation to streamline repetitive processes and reduce manual work.
• Support inventory tracking, supply chain metrics, supply planning, MSC, and S&OP activities.
• Manage packaging, formulation, and master data specifications; maintain organized repositories and complete system transactions, document uploads, and process tracking.

Requirements

• 5+ years of experience in operations support, supply chain, data analysis, or a highly analytical coordination role.
• Expert-level Excel skills, including XLOOKUP, INDEX/MATCH, nested IF statements, PivotTables, Power Query, and basic VBA/macros.
• Power BI experience strongly preferred, including data-source connections, dashboard editing, and basic DAX.
• Strong analytical, organizational, problem-solving, communication, and collaboration skills, with exceptional attention to detail.
• Ability to quickly learn new systems and processes and work independently in a detailed, task-oriented environment; a bachelor’s degree in Business, Supply Chain, Information Systems, or a related field is a plus.

Skills

• Operations Support
• Data Analysis
• Supply Chain
• Microsoft Excel
• Power Query
• VBA/Macros
• Power BI
• DAX
• Inventory Tracking
• S&OP

Hourly rate is commensurate with experience and is an estimated range provided by WorkGenius.

ref_id: 5a3ee995-937b-4af9-a79a-357f4a92ec62