Overview
Work History
Education
Skills
Timeline
Generic

ZACHARY JENSEN

Pittsburgh,PA

Overview

12
12
years of professional experience

Work History

Space & Inventory Analytics Manager

01.2021 - 01.2023
  • Provide category teams analytical support as an “expert user” of Playbooks (Excel Templates), ERP Tools(Internal, SAS/SQL), & Giant Eagle Tools (including a tool built on Tableau and experience with PowerBI)
  • Develop deep, focused expertise on customer behavior, market trends and competitive intelligence for assigned categories
  • Develop the standard analytics and deliverables as well as the creation of training documents as part of the creation of the Space and Inventory Analytics Team
  • Leadership
  • Responsible for leading a team of analysts to provide quality analytical support to our category teams in the areas of customer insights, assortment, pricing and promotions
  • Act as project lead on key assignments, ranging from tool implementation and training, to process adoption, to cross category analysis and strategy
  • Lead the creation of a space and Inventory Analytics Team with team members working across multiple time zones
  • Communication
  • Monitor plan implementation, provide monthly status updates and support Category Teams in preparation for Quarterly reviews and assist in implementation of plans
  • Create a working schedule and communication plan to support a space and inventory analytics team with analysts spread across multiple time zones
  • Partner with the Space Planning and Merchandising Team in the execution of Space and Inventory Decisions impacting categories with sales between $15 - $100 million dollars each.

Senior Accountant

Software Engineering Institute
01.2011 - 01.2015
  • Analytics
  • Prepare and maintain financial data needed to model the Other Direct Expense (ODE) rate proposal and the Paid Time Off (PTO) rate proposal to maintain proper cost allocations across functional areas
  • Prepare, maintain, and analyze financial and personnel data trends as part of the annual ODE study as well as the monthly ODE reviews given to the board
  • Process Improvement
  • Automated an existing spreadsheet that is used to maintain financial data that cut the time needed to update by over 12 hours (90%) and increased the accuracy and depth of the data
  • Teamwork
  • Prepared a mix of financial data, charts, and memos needed to renew a new multiple year contract with the government worth over $1.8 billion dollars.

Education

Masters - Business Administration

Carnegie Mellon University
Pittsburgh, PA
05.2015

Master of Science - Accounting

Juniata College
Huntingdon, PA
05.2011

Skills

  • Microsoft Office Suites – Excel, Word, PowerPoint, Publisher, One Note, Teams
  • Expert in SQL and SAS
  • Proficient User of Tableau

Timeline

Space & Inventory Analytics Manager

01.2021 - 01.2023

Senior Accountant

Software Engineering Institute
01.2011 - 01.2015

Masters - Business Administration

Carnegie Mellon University

Master of Science - Accounting

Juniata College

Similar Profiles

CREATE PROFILE
ZACHARY JENSEN