Product Management Data Analyst

Snap-On Tools; Kenosha (WI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Paid time off

401(k) Plan with matching employer

Employee Stock Purchase Plan

Dental coverage

Disability coverage

Wellness programs

Tuition Assistance Plan

Job summary

Snap-on Tools, corporate headquarters in Kenosha, WI, is seeking a data-driven professional to manage product management and supply chain reporting. The role focuses on turning data into actionable insights and managing Tableau data reporting portal for the division.

Responsibilities include creating and managing reporting, analyzing pricing, margins, supplier data, and enabling better decisions with Tableau and Power BI. A bachelor’s degree and experience with ERP systems and SQL are preferred.

Qualifications

• Bachelor’s degree or equivalent experience in IT, marketing, business admin, or related field.
• Experience across marketing, supply chain, finance, purchasing and sales preferred.
• Ability to create SQL queries to generate ERP/MRP reports.
• Familiar with SQL Server, Oracle, VBA; proficient in Tableau and Power BI.
• Strong project management and problem-solving skills.

Responsibilities

• Coordinate, execute, and support product management and supply chain reporting with data analysis.
• Turn data into information, and information into business decisions.
• Manage Tableau data reporting portal for division.
• Create and manage reporting and data availability strategies for the Tools Group.
• Support pricing, margins, supplier data, and inventory reporting.

Skills

SQL queries

Tableau

Power BI

ERP reporting

Data analysis

Education

Bachelor’s degree in IT/Marketing/Business

Tools

Tableau

Power BI

SQL Server

Oracle DB

VBA

Job description

This position is onsite at the Corporate Headquarters located in Kenosha, WI.

Who We Are:

As part of the Snap‑on Tools team, you'll be joining an extraordinary company that has been the industry standard for over 105 years! People know Snap‑on for the quality of our products, but we know that it is the passion and character of our people that make our company a global leader. With our diverse talents and deep pride in the Snap‑on family of brands, we drive innovation and create value. We work hard together. We grow together. We are one Snap‑on team.

Working With Snap‑on has Benefits!!

Company‑paid benefits include:

• Paid time off, vacation and paid holidays
• Market competitive compensation
• Retirement programs including 401(k) Plan with matching employer contributions
• Employee Stock Purchase Plan – annual optional enrollment period
• Basic dental, Basic life, Basic accidental death and dismemberment coverage
• Short term and long‑term disability, Employee Assistance Program
• Business travel accident insurance
• Other health education programs, including smoking cessation, annual wellness screening and seasonal flu shot
• Bonus, incentives depending on position and level
• Base pay progression through lateral & promotional development on both managerial and technical career paths
• Tuition Assistance Plan

Snap‑on is rooted in the dignity of work. From our founding 100years ago, we have been dedicated to this timeless principle. We celebrate this work and we celebrate our customers,the makers and the fixers, who perform day in and day out to move the world forward.

Snap‑on is an Equal Opportunity Employer (Minority/Female/Disabled/Veteran) and continually strives to be an employer of choice with a Great Place to Work culture.

Responsibilities

Position Summary:

Coordinate, execute, and support key product management and supply chain operations with critical information analysis and reporting. Ensure that processes are effectively documented and managed, and that opportunities for improvement are implemented and shared across team. Manage complex supplier, supply chain, and sales information reporting. The successful candidate will turn data into information, information into insight, and insight into business decisions. Provide ongoing financial and business case analysis to support team decisions. Help manage Tableau data reporting portal for division.

Key Tasks:

• General: Create and manage data reporting and availability strategy for the Tools Group. Use Tableau and other queries and reporting from ERP systems and data tables. Responsible for all aspects of product management and supply chain data reporting and analysis. Act as liaison for various departments regarding product management data related issues (customer service, warehouse, transportation, expediting, accounting and purchasing).
• Product Management: Weekly Sales reports and trends, warranty analysis and problem identificaiton, marketing funding amounts due, $1M new product tracking, supplier purchase information, and vendor repair database.
• Marketing: Support competitive pricing and gross margin analysis. Coordinate all price changes, printing of price lists, and review of new and promotional offers.
• Purchasing/Pricing: Generate supplier purchasing reports and perfom pricing analysis; perform sales analysis and manager special projects; generate inventory analysis; create open order, past order, new product, and discontinued product reports. Work to provide similar data to the manufacturing plants.
• Data availability – Use Tableau to improve availability and ease of use for user data in product management and supply chain areas to increase data availability and improve decision making.
• Power BI – Use of Power BI to create stock Product Management reports. Be the first line of quality review prior to requests going to IT. Control and manage requests to consolidate reporting to a few gold standard reports that are updated depending on use case.

Qualifications

Requirements:

• Bachelor’s degree in IT, Marketing, Business Administration, or related field, or equivalent experience or training.
• Prefer experience in a broad range of functions, including marketing, supply chain, finance, purchasing (domestic and global) and sales
• Ability to create Structured Query Language (SQL) queries to generate reports from Enterprise Resource Planning (ERP) and MRP based systems
• Familiarity with SQL Server, Oracle Database systems, and VBA programming
• Demonstrated proficiency in Tableau, Data Lake, and Microsoft Office: Access, Excel and Word
• Proven project management skills and the ability to solve complex problems