Data Analyst II - Retail Distribution & 3PL Operations
Golden Pet Brands · Chatsworth, California, United States · 1 mo ago
Information Technology$9/hrFull-time
We need to output HTML fragment with sections: About the role? The posting includes description after "What You’ll Be Doing:" which is responsibilities. Also "Qualifications" section includes bullet list of qualifications and then "Preferred Education" etc. Also "Golden Perks & Benefits" is benefits. Also salary info: "The base salary range is $34.62hr-$43.27hr, plus bonus potential." So we need Pay section. Schedule? Not mentioned. So we include sections: About the role? Could be a short paragraph summarizing role? The posting includes "Creating a world where pets live longer..." but that's intro fluff maybe not needed? The instruction: "Do NOT repeat the job title as a heading (the page already shows it) and do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have About the role heading with a paragraph describing the role and mission. Then Responsibilities heading with list. Then Qualifications heading with list (including preferred education, experience, skills). Then Benefits heading with list. Then Pay heading with paragraph.
We must not include Schedule section because not mentioned.
We need to ensure we don't include filler like "commensurate with experience". Not present.
Now extract details.
About the role: Could combine first sentences: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A(n): Data Analyst II Location: Onsite (Chatsworth, CA)". But we shouldn't repeat job title as heading; but we can include it in paragraph. So About the role paragraph: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A(Data Analyst II) Location: Onsite (Chatsworth, CA)." Might be okay.
But maybe better: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A Data Analyst II. Location: Onsite (Chatsworth, CA)."
Now Responsibilities: bullet list from "What You’ll Be Doing:" paragraph and subsequent sentences.
Let's extract responsibilities:
- Supports the operational performance of an omni-channel pet product distribution network, with primary focus on operational reporting and analytics, situational analysis, and continuous improvement.
- Transforms logistics, inventory, order, transportation, and customer data into actionable reporting and insights that monitor and improve delivery performance, inventory management, distribution efficiency, capacity management, and cost performance for a DTC and retail fulfillment network.
- Works cross-functionally with warehouse operations, supply chain partners, service providers, customer service, IT, and other stakeholders to drive continuous improvement.
- Identifies, root-causes, and resolves operational issues through the implementation, testing, and validation of reporting and process workflow solutions.
- Reviews shipment materials prior to distribution and collaborates with transportation and supply chain teams to ensure timely pick-ups and expedited shipments.
- Develops, maintains, and enhances dashboards, scorecards, and recurring reports that measure fulfillment, transportation, inventory, retailer compliance, delivery performance, cost, and distribution center capacity.
- Analyzes operational and transportation data to identify performance gaps, quantify and prioritize improvement opportunities, conduct root-cause analysis, and recommend practical solutions.
- Supports inventory planning, replenishment, capacity planning, and demand analysis while resolving inventory discrepancies in partnership with Sales Operations and other stakeholders.
- Validates and troubleshoots data across ERP, warehouse management, and reporting systems to ensure information is accurate, consistent, and reliable.
- Coordinates with distribution centers, supply chain teams, vendors, and transportation providers to plan, schedule, and track inbound, outbound, and transfer shipments.
- Optimizes shipping schedules and load consolidation to improve vehicle utilization, reduce empty miles, control costs, and support on-time delivery.
- Partners with Operations, Customer Service, Supply Chain, Finance, and Sales Operations to implement process improvements and present actionable findings and performance trends to management.
Now Qualifications: The bullet list under "Qualifications (Note: We strongly encourage you to apply even if you don’t tick ALL of these boxes.):" includes:
- Inventory Accuracy
- Fulfillment Operations KPIs
- Continuous Improvement in Cost and Performance
- Freight Cost Performance
- Retailer Compliance Scores
- Reporting Accuracy & Timeliness
- Process Improvement Recommendations
Then "Preferred Education" bullet: Bachelor's degree in Business Analytics, Industrial Engineering, Supply Chain, Data Analytics, Statistics, Mathematics, or related field.
Then "3-4 years of experience in data analysis, industrial engineering, logistics, distribution, or supply chain."
Then "Advanced Excel skills including Pivot Tables, XLOOKUP, and data visualization."
Then "Experience with PowerBI, google scripts, SQL, and AI prompting"
Then "Advanced analytical, problem-solving, and communication skills."
Then "Ability to manage multiple priorities in a fast-paced distribution environment."
Then "Preferred Experience" bullet list:
- Retail distribution, warehouse, logistics, or 3PL operations.
- ERP and WMS systems such as NetSuite, Deposco, Logiwa, SAP, or similar platforms.
- Reporting for major retail customers including Walmart, PetSmart, Petco, Amazon, or Chewy.
We can combine all into Qualifications section as a list.
Now Benefits: "Golden Perks & Benefits" list:
- Comprehensive healthcare coverage – We cover 100% of premiums for medical, dental, and vision plans for employee-only plans.
- Annual bonus
- We match up to 3.5% of your 401k contributions, ensuring your retirement savings grow alongside your career.
- 6 paid sick and mental health days, an Employee Assistance Program, free weekly yoga and meditation classes, and additional mental health benefits, because we take a holistic approach to your well-being.
- Invest in your future with our Employee Stock Ownership Plan, where company contributions fund your retirement plan with company stock. Learn more.
- Reimbursements for a portion of personal cell phone and internet usage for eligible employees.
- Professional development opportunities with mentorship, continuous learning programs, and performance-based pay increases, empowering you to progress and excel in your career.
- Through our charity sponsorships, you can make a positive impact on communities worldwide. We’ve donated over $9 million to date.
- Potential for quarterly KPI bonuses.
Now Pay: "The base salary range is $34.62hr-$43.27hr, plus bonus potential. The posted salary range in this job posting reflects data based on California's cost of labor analysis. This salary range is subject to change per state; please click here to find the pay differential in your state of residence if the role is remote. Salary is based on a wide range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geographical location."
We should keep the substantive info: base salary range $34.62hr-$43.27hr, plus bonus potential. Also note it's based on California cost of labor analysis, subject to change per state. Could include that.
Now we must exclude recruiting agency note, candidate safety, etc.
Now output HTML fragment with
or drop it." We can include a short
for location maybe? The location is "Onsite (Chatsworth, CA)". Could be placed in a paragraph after the heading? Probably we can include a
with location and maybe brief intro. But we need to preserve all substantive information. So we need to include the description of role, responsibilities, qualifications, benefits, pay. Also maybe "Preferred Education" etc can be part of Qualifications section. We must not include boilerplate like EEO, safety note, recruiting agency note, candidate safety, etc. Remove those. We must not invent sections. So we will have sections: Responsibilities, Qualifications, Benefits, Pay. Possibly also "About the role" could be a brief paragraph before responsibilities. But we already have responsibilities covering what you'll be doing. The intro "Creating a world where pets live longer..." is fluff but maybe considered "About the role"? It's not specific to role. Might be considered boilerplate? It's generic company mission. Could be omitted? The instruction: Preserve ALL substantive information; do NOT invent or summarize away detail. The mission statement is substantive? It's about company but not role specifics. Might be considered fluff but still part of posting. However they said remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. Mission statement not those. Could keep as a
before sections. But they said "Prefer a few substantive sections over many thin ones." So maybe combine mission and responsibilities into About the role? But they said use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have About the role heading with a paragraph describing the role and mission. Then Responsibilities heading with list. Then Qualifications heading with list (including preferred education, experience, skills). Then Benefits heading with list. Then Pay heading with paragraph.
We must not include Schedule section because not mentioned.
We need to ensure we don't include filler like "commensurate with experience". Not present.
Now extract details.
About the role: Could combine first sentences: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A(n): Data Analyst II Location: Onsite (Chatsworth, CA)". But we shouldn't repeat job title as heading; but we can include it in paragraph. So About the role paragraph: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A(Data Analyst II) Location: Onsite (Chatsworth, CA)." Might be okay.
But maybe better: "Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A Data Analyst II. Location: Onsite (Chatsworth, CA)."
Now Responsibilities: bullet list from "What You’ll Be Doing:" paragraph and subsequent sentences.
Let's extract responsibilities:
- Supports the operational performance of an omni-channel pet product distribution network, with primary focus on operational reporting and analytics, situational analysis, and continuous improvement.
- Transforms logistics, inventory, order, transportation, and customer data into actionable reporting and insights that monitor and improve delivery performance, inventory management, distribution efficiency, capacity management, and cost performance for a DTC and retail fulfillment network.
- Works cross-functionally with warehouse operations, supply chain partners, service providers, customer service, IT, and other stakeholders to drive continuous improvement.
- Identifies, root-causes, and resolves operational issues through the implementation, testing, and validation of reporting and process workflow solutions.
- Reviews shipment materials prior to distribution and collaborates with transportation and supply chain teams to ensure timely pick-ups and expedited shipments.
- Develops, maintains, and enhances dashboards, scorecards, and recurring reports that measure fulfillment, transportation, inventory, retailer compliance, delivery performance, cost, and distribution center capacity.
- Analyzes operational and transportation data to identify performance gaps, quantify and prioritize improvement opportunities, conduct root-cause analysis, and recommend practical solutions.
- Supports inventory planning, replenishment, capacity planning, and demand analysis while resolving inventory discrepancies in partnership with Sales Operations and other stakeholders.
- Validates and troubleshoots data across ERP, warehouse management, and reporting systems to ensure information is accurate, consistent, and reliable.
- Coordinates with distribution centers, supply chain teams, vendors, and transportation providers to plan, schedule, and track inbound, outbound, and transfer shipments.
- Optimizes shipping schedules and load consolidation to improve vehicle utilization, reduce empty miles, control costs, and support on-time delivery.
- Partners with Operations, Customer Service, Supply Chain, Finance, and Sales Operations to implement process improvements and present actionable findings and performance trends to management.
Now Qualifications: The bullet list under "Qualifications (Note: We strongly encourage you to apply even if you don’t tick ALL of these boxes.):" includes:
- Inventory Accuracy
- Fulfillment Operations KPIs
- Continuous Improvement in Cost and Performance
- Freight Cost Performance
- Retailer Compliance Scores
- Reporting Accuracy & Timeliness
- Process Improvement Recommendations
Then "Preferred Education" bullet: Bachelor's degree in Business Analytics, Industrial Engineering, Supply Chain, Data Analytics, Statistics, Mathematics, or related field.
Then "3-4 years of experience in data analysis, industrial engineering, logistics, distribution, or supply chain."
Then "Advanced Excel skills including Pivot Tables, XLOOKUP, and data visualization."
Then "Experience with PowerBI, google scripts, SQL, and AI prompting"
Then "Advanced analytical, problem-solving, and communication skills."
Then "Ability to manage multiple priorities in a fast-paced distribution environment."
Then "Preferred Experience" bullet list:
- Retail distribution, warehouse, logistics, or 3PL operations.
- ERP and WMS systems such as NetSuite, Deposco, Logiwa, SAP, or similar platforms.
- Reporting for major retail customers including Walmart, PetSmart, Petco, Amazon, or Chewy.
We can combine all into Qualifications section as a list.
Now Benefits: "Golden Perks & Benefits" list:
- Comprehensive healthcare coverage – We cover 100% of premiums for medical, dental, and vision plans for employee-only plans.
- Annual bonus
- We match up to 3.5% of your 401k contributions, ensuring your retirement savings grow alongside your career.
- 6 paid sick and mental health days, an Employee Assistance Program, free weekly yoga and meditation classes, and additional mental health benefits, because we take a holistic approach to your well-being.
- Invest in your future with our Employee Stock Ownership Plan, where company contributions fund your retirement plan with company stock. Learn more.
- Reimbursements for a portion of personal cell phone and internet usage for eligible employees.
- Professional development opportunities with mentorship, continuous learning programs, and performance-based pay increases, empowering you to progress and excel in your career.
- Through our charity sponsorships, you can make a positive impact on communities worldwide. We’ve donated over $9 million to date.
- Potential for quarterly KPI bonuses.
Now Pay: "The base salary range is $34.62hr-$43.27hr, plus bonus potential. The posted salary range in this job posting reflects data based on California's cost of labor analysis. This salary range is subject to change per state; please click here to find the pay differential in your state of residence if the role is remote. Salary is based on a wide range of factors that include relevant experience, knowledge, skills, other job-related qualifications, and geographical location."
We should keep the substantive info: base salary range $34.62hr-$43.27hr, plus bonus potential. Also note it's based on California cost of labor analysis, subject to change per state. Could include that.
Now we must exclude recruiting agency note, candidate safety, etc.
Now output HTML fragment with headings and - for lists,
for prose.
We need to ensure we don't include any extra text outside HTML.
Let's craft:
About the role
Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A Data Analyst II. Location: Onsite (Chatsworth, CA).
Responsibilities
- Supports the operational performance of an omni-channel pet product distribution network, with primary focus on operational reporting and analytics, situational analysis, and continuous improvement.
- Transforms logistics, inventory, order, transportation, and customer data into actionable reporting and insights that monitor and improve delivery performance, inventory management, distribution efficiency, capacity management, and cost performance for a DTC and retail fulfillment network.
- Works cross-functionally with warehouse operations, supply chain partners, service providers, customer service, IT, and other stakeholders to drive continuous improvement.
- Identifies, root-causes, and resolves operational issues through the implementation, testing, and validation of reporting and process workflow solutions.
- Reviews shipment materials prior to distribution and collaborates with transportation and supply chain teams to ensure timely pick-ups and expedited shipments.
- Develops, maintains, and enhances dashboards, scorecards, and recurring reports that measure fulfillment, transportation, inventory, retailer compliance, delivery performance, cost, and distribution center capacity.
- Analyzes operational and transportation data to identify performance gaps, quantify and prioritize improvement opportunities, conduct root-cause analysis, and recommend practical solutions.
- Supports inventory planning, replenishment, capacity planning, and demand analysis while resolving inventory discrepancies in partnership with Sales Operations and other stakeholders.
- Validates and troubleshoots data across ERP, warehouse management, and reporting systems to ensure information is accurate, consistent, and reliable.
- Coordinates with distribution centers, supply chain teams, vendors, and transportation providers to plan, schedule, and track inbound, outbound, and transfer shipments.
- Optimizes shipping schedules and load consolidation to improve vehicle utilization, reduce empty miles, control costs, and support on-time delivery.
- Partners with Operations, Customer Service, Supply Chain, Finance, and Sales Operations to implement process improvements and present actionable findings and performance trends to management.
Qualifications
- Inventory Accuracy
- Fulfillment Operations KPIs
- Continuous Improvement in Cost and Performance
- Freight Cost Performance
- Retailer Compliance Scores
- Reporting Accuracy & Timeliness
- Process Improvement Recommendations
- Preferred Education: Bachelor's degree in Business Analytics, Industrial Engineering, Supply Chain, Data Analytics, Statistics, Mathematics, or related field.
- 3-4 years of experience in data analysis, industrial engineering, logistics, distribution, or supply chain.
- Advanced Excel skills including Pivot Tables, XLOOKUP, and data visualization.
- Experience with PowerBI, google scripts, SQL, and AI prompting.
- Advanced analytical,
- for lists,
for prose. We need to ensure we don't include any extra text outside HTML. Let's craft:
About the role
Creating a world where pets live longer, healthier lives, from their very first meal. Learn more about our brands. We’re Looking For A Data Analyst II. Location: Onsite (Chatsworth, CA).
Responsibilities
- Supports the operational performance of an omni-channel pet product distribution network, with primary focus on operational reporting and analytics, situational analysis, and continuous improvement.
- Transforms logistics, inventory, order, transportation, and customer data into actionable reporting and insights that monitor and improve delivery performance, inventory management, distribution efficiency, capacity management, and cost performance for a DTC and retail fulfillment network.
- Works cross-functionally with warehouse operations, supply chain partners, service providers, customer service, IT, and other stakeholders to drive continuous improvement.
- Identifies, root-causes, and resolves operational issues through the implementation, testing, and validation of reporting and process workflow solutions.
- Reviews shipment materials prior to distribution and collaborates with transportation and supply chain teams to ensure timely pick-ups and expedited shipments.
- Develops, maintains, and enhances dashboards, scorecards, and recurring reports that measure fulfillment, transportation, inventory, retailer compliance, delivery performance, cost, and distribution center capacity.
- Analyzes operational and transportation data to identify performance gaps, quantify and prioritize improvement opportunities, conduct root-cause analysis, and recommend practical solutions.
- Supports inventory planning, replenishment, capacity planning, and demand analysis while resolving inventory discrepancies in partnership with Sales Operations and other stakeholders.
- Validates and troubleshoots data across ERP, warehouse management, and reporting systems to ensure information is accurate, consistent, and reliable.
- Coordinates with distribution centers, supply chain teams, vendors, and transportation providers to plan, schedule, and track inbound, outbound, and transfer shipments.
- Optimizes shipping schedules and load consolidation to improve vehicle utilization, reduce empty miles, control costs, and support on-time delivery.
- Partners with Operations, Customer Service, Supply Chain, Finance, and Sales Operations to implement process improvements and present actionable findings and performance trends to management.
Qualifications
- Inventory Accuracy
- Fulfillment Operations KPIs
- Continuous Improvement in Cost and Performance
- Freight Cost Performance
- Retailer Compliance Scores
- Reporting Accuracy & Timeliness
- Process Improvement Recommendations
- Preferred Education: Bachelor's degree in Business Analytics, Industrial Engineering, Supply Chain, Data Analytics, Statistics, Mathematics, or related field.
- 3-4 years of experience in data analysis, industrial engineering, logistics, distribution, or supply chain.
- Advanced Excel skills including Pivot Tables, XLOOKUP, and data visualization.
- Experience with PowerBI, google scripts, SQL, and AI prompting.
- Advanced analytical,