This site uses cookies. To find out more, see our Cookies Policy

Senior Data Analyst in Tampa, FL
Masonite Corporation

Date Posted: 7/19/2018

Job Snapshot

Job Description

Our vision is to be the best provider of building products in the eyes of our customers, employees, shareholders, suppliers and communities.

At Masonite, we understand that people are key. We are a composite of diverse people who come together by showing support and respect to one another.

We hire people that demonstrate integrity under pressure. Integrity is at the foundation of everything we do. It is in each door we make, in our commitment delivery and in our honest and sincere communication.

Our employees are flexible, versatile and resilient. Our ability to weather any storm, to bend without breaking, is what allows us to hear the knock and open the door with confidence, no matter what's on the other side.

At Masonite, we hold the door open for each other and for new ideas. We want everyone to freely contribute ideas and add value, so we are positive and encouraging. This collaborative environment is what makes Masonite a transparent, fair company- one that doesn't hide behind closed doors.

We continuously strive to improve both our products and our customers' experiences. This drive leads us to revolutionize the door industry and help people walk through walls.

Responsibilities
  • Consolidate direct & indirect raw material spend data from multiple ERPs, standardize & clean the data, and report on monthly inflation & purchase price variance (PPV).
  • Develop quarterly forecasts for inflation & PPV by creating templates for the Procurement Category Managers then consolidating & reviewing their results with them.
  • Lead the production of the Supply Chain VP’s Quarterly Performance Management Presentation.
  • Manage the creation of material cost standards in the yearly budgeting process.
  • Optimize the calculation methodologies for price, volume, mix, and Foreign Exchange impacts on inflation reporting.
  • Project Manage the conversion of Excel-based databases to a data warehouse (Hyperion) based system.
  • Optimize the calculation methodologies, processes, and tools used to track procurement savings.
  • Manage supplier rebates: requirements, backup data & supporting documentation, forecasts, actuals, budgets, and collections.
  • Future projects will include:
  • Analysis of intercompany material costs.
  • Consolidation of raw material costs from external suppliers from other countries / business units with the data from the base business.
  • Analysis of cash flow and working capital metrics such as weighted average payment terms and DPO.

Key Attributes of a Successful Candidate:

  • Highly Organized
  • Strong excel skills / several year’s experience working in Excel with large volumes of data
  • Experience managing very large volumes of data including data cleaning, manipulation, and analysis
  • Mathematical problem solving
  • Project Management
  • Good communication skills
  • Teamwork
Qualifications
    • BS in finance, supply chain management or other quantitative degree
    • MBA strongly preferred
    • ~10-15% Travel Anticipated
    • Very strong proficiency & experience using Microsoft Excel
    • Knowledge of Lean Sigma a plus
    • Experience with financial systems (e.g. Microsoft Dynamics, HFM, Hyperion, Essbase) is most helpful

Salary & Benefits

  • Competitive salary commensurate with experience and performance.
  • Company funded HSA.
  • 100% Company paid life insurance and short/long term disability insurance.
  • 401(k) benefit with 5% Company match.
  • 3 weeks of vacation, 8 holidays and 2 floating holidays
  • College tuition reimbursement
  • Ongoing career training and development.