Job Description
Must have experience in UKG, SQL, Excel, and Power BI
Data extraction: Pull labor details from UKG and PKMS using SQL.
Building-level analysis: Build independent analysis for each building. Examples include labor productivity, cost per unit and variance by site.
Framework redesign: Modify the existing AOP and budgeting model. The data feeding it will likely need restructuring.
Stakeholder support: Share findings with building managers who are operations leaders rather than finance or data people.
Must Have:
SQL - Writes their own queries with joins and aggregations
Excel - Advanced. Pivots, lookups and building models from raw data
UKG & PKMS - Has extracted data from UKG or Kronos and from PKMS or another WMS. Knows how labor and warehouse data are structured
Data Extraction – UKG, PKMS & P&L Forecasting experience
Supply Chain Finance – understands how operational data ties to cost and financial results
Power BI
Has supported budget or AOP cycles with data and analysis. Does not need to have owned the full cycle
Nice to have:
Industry: Goods, Retail, Apparel
Has worked with Distribution Center or plant data
Day to Day Responsibilities:
Design, build, and maintain dashboards and reports in Power BI and Excel to include advanced formulas and automation
Extract, transform, and analyze large datasets using SQL including joins, CTEs, and query optimization, and DAX to support business and financial needs
Develop and maintain analytical and financial models for forecasting, labor planning, cost analysis, KPI tracking, and performance analysis.
Proactively identify trends, anomalies, cost drivers, and opportunities to improve operational and financial performance.
Ensure all reporting is accurate, timely, and structured for clarity and usability across technical and non-technical audiences, including financial stakeholders
Continuously improve reporting frameworks to enhance efficiency, scalability, and visual effectiveness
Collaborate with cross-functional stakeholders to understand business and financial needs and translate them into analytical solutions
Deliver actionable insights that support both day-to-day operations and financial/strategic decision-making
Support recurring executive reporting, including KPI summaries, financial performance insights, and QBR materials
Identify and implement opportunities to streamline manual processes through automation and improved data workflows
Contribute to the development and standardization of datasets, metrics, and reporting structures, including financial definitions where applicable
Support data quality initiatives, ensuring consistency, accuracy, and reliability across all outputs
Validate data sources and outputs to maintain high standards of accuracy, integrity, and financial reliability
Document data definitions, logic, and reporting methodologies to ensure transparency and repeatability
Assist in maintaining structured and scalable data environments for reporting and analysis
Proactively analyze and interpret database tables and fields to ensure data completeness and integrity
Never miss an opportunity! Create an alert based on the job you applied for.
