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