This is a remote position.
Key Responsibilities:
Operations: OEE, Yield, Downtime, Shrink, Drum Beat, Blending Scorecard, Real-Time Stuffing, Bin Transfer, etc.
Finance: Labor statistics, inventory valuation, AP/AR scorecards, capital spend, item history.
Sales & Supply Chain: Forecasting, customer pricing, sales projections, freight analysis.
Quality: Non-conformance, QA checks, foreign matter, HACCP logs.
HR: Overtime, turnover, headcount by position.
ESG & Utilities: Water, gas, electric usage, recycling, donations.
Executive Dashboards: EBITDA, yield, man spend, non-conformance, profitability by plant.
Data Modeling & Transformation:
Design and optimize data models using Power BI Desktop.
Perform complex data transformations using Power Query (M).
Create calculated columns, measures, and KPIs using DAX.
Integration & Automation:
Connect to diverse data sources including SQL Server, Excel, SAP, Ignition, and cloud platforms.
Implement row-level security and role-based access controls.
Performance Optimization:
Optimize report performance and ensure scalability for large datasets.
Collaboration & Documentation:
Work closely with business stakeholders to gather requirements.
Document data models, transformation logic, and report specifications.
Required Skills:
Proficiency in Power BI Desktop, Power BI Service, and DAX.
Strong understanding of data modeling, ETL processes, and data warehousing.
Experience with SQL, Excel, and integrating data from multiple sources.
Ability to create interactive dashboards, custom visuals, and paginated reports.
Familiarity with data governance, security, and compliance best practices.
Strong analytical, problem-solving, and communication skills.
Genpact
Pernod Ricard
Hempel A/S
Boombit
SynergisticIT