Data-Driven Operations Analyst (Power BI & Excel)

WorkGenius Group; El Segundo (CA); On-site; USD 55,000 - 96,000; Full time

Job summary

WorkGenius Group in El Segundo, CA, is seeking an Operations & Data Specialist to clean and consolidate large datasets, maintain Power BI dashboards, and support reporting while connecting diverse data sources.

You will leverage Excel, Power Query, VBA, and automation to streamline processes, support inventory tracking and S&OP activities, and improve data accuracy across the supply chain. This 12-month role emphasizes analytical rigor and independent work.

Qualifications

• 5+ years of experience in operations, data analysis, or a highly analytical coordination role.
• Expert Excel: XLOOKUP, INDEX/MATCH, nested IF, PivotTables, Power Query, VBA.
• Power BI experience with data-source connections, dashboards, and basic DAX.
• Strong analytical, organizational, problem-solving, communication, and collaboration skills with attention to detail.
• Bachelor’s degree in Business, Supply Chain, Information Systems, or related field preferred.

Responsibilities

• Clean, consolidate, format, and audit large datasets from multiple 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.

Skills

Operations Support

Data Analysis

Supply Chain

Microsoft Excel

Power Query

VBA/Macros

Power BI

DAX

Inventory Tracking

S&OP

Education

Bachelor’s degree in Business, Supply Chain, Information Systems, or related field

Tools

Power BI

Excel

Power Query

VBA/Macros

Job description

WorkGenius Group in El Segundo, CA, is seeking an Operations & Data Specialist to clean and consolidate large datasets, maintain Power BI dashboards, and support reporting while connecting diverse data sources.

You will leverage Excel, Power Query, VBA, and automation to streamline processes, support inventory tracking and S&OP activities, and improve data accuracy across the supply chain. This 12-month role emphasizes analytical rigor and independent work.