Operations and Database Analyst
Woodstream
Lancaster, PA · Posted October 16, 2026
Just laid off? Start here: a plan for the first weeks
See every open role at Woodstream
More in Pennsylvania job market · Retail & E-commerce · Operations jobs
More roles at Woodstream
- Brand Manager Terro · Lancaster, PA
- Project Manager, Product Enhancement Engineering · Lancaster, PA
- Project Manager, New Product Development · Lancaster, PA
- Mechanical Design Engineer II, Product Enhancement Engineering · Lancaster, PA
- Electrical Design Engineer III, New Product Development · Lancaster, PA
- Manager, Sourcing & Procurement - Operations & Manufacturing · Lancaster, PA
Similar jobs
- ERP Developer / Functional Analyst - Seedway - Elizabethtown, PA · Growmark · Elizabethtown, PA
- Senior IT Business Systems Analyst - Computing Services · Carnegie Mellon University · Pittsburgh, PA
- Exchange Fee Data Analyst | Experienced Hire · Susquehanna International Group · Bala Cynwyd, PA
- Senior Business Systems Analyst · Centene · PA
- Lead Business Systems Analyst · Centene · PA
- Technical Business Systems Analyst · LinkedIn · Point Marion, PA
Where Lancaster, PA ranks
Where Lancaster, PA placed in our monthly rankings, month by month. Each month stays online at its own address.
November 2026
- #2Best college towns for junior jobs in the Northeast40% · of 50
- #2Best cities for junior jobs in the Northeast41% · of 64
- #5Best cities for junior jobs in the Mid-Atlantic41% · of 80
- #9Best college towns for junior jobs in the Mid-Atlantic40% · of 55
- #12Cities where the biggest share of jobs do not need a four-year degree in the Northeast17% · of 38
- #14Cities where the biggest share of jobs do not need a four-year degree in the Mid-Atlantic17% · of 53
Rankings about operations jobs
- Best cities for operations jobs #1 New York (1,468 openings)
- Best cities for operations pay after cost of living #1 Waltham ($138k)
- Most requested AI skills in operations jobs #1 AI tools in daily work (2.5%)
- AI tools named most often in operations jobs #1 Claude (0.28%)
- Employers with the most operations jobs #1 Amazon (1,065 roles)
How AI is used in this kind of work
Among computer systems analysts, AI is already used for some of the tasks. Measured exposure for computer systems analysts: 28% (some).
Share of this job’s tasks that AI is already used for at work, from real usage. It is not a forecast of job loss, and a low number means no use seen yet. Source: Anthropic Economic Index.
Skills this job asks for
Say which you have and which you want to build. We use it to match you to jobs like this one.
About the job
Woodstream is the largest independent pest & animal control platform in North America, offering innovative brands with industry-leading efficacy and safety.
Looking to grow your financial experience in the Consumer Products Industry? We have an immediate opportunity for a temporary Operations and Database Analyst in Lancaster, PA.
At Woodstream, our values drive everything we do:
Consumer is the Boss – We are committed to listening to and understanding our customers’ needs!
Invent the Future – Challenge the status quo: Think boldly and creatively!
Execution is Everything – We are committed to deliver with excellence, speed, and accuracy.
Collaborate Confidently – We trust, respect, and empower each other to win together.
Play to Win – We’re bold, ambitious, and relentless in our pursuit of success.
Benefits of Working for Woodstream:
Competitive benefits package include: 401k with Company Match
Health, Dental & Vision Insurance Effective on First Day of Employment
Stable, growing working environment with a history of 150 years of doing business.
Overview of the Role:
Review and reporting of operational performance to support decision-making
Optimization of departmental databases to support the analysis of operations and material product costs
On-going support of departmental activities, accounting close and budgeting processes
Essential Functions & Responsibilities:
Regular attendance and punctuality required
Develop, analyze and control Product Material Costs for US, and Canadian operations.
Ensure conformance with corporate policies, internal controls, and record maintenance in accordance with generally accepted accounting practices.
Research and analyze material cost variances for sourcing products as well as manufacturing, and logistical activities. Where necessary assist in developing recommendations to track recurring variances.
Take the lead in analyzing and identifying cost savings projects related to purchase network, particularly items that drive tariff mitigation
Assume the lead role in evaluating the performance and accuracy of the departmental databases.
Design relational database structures and data collection methods using internal/external data sources.
Assist in recommendation of any potential purchase of externally database products used in analysis.
Leverage operational knowledge to create new analytical tools and statistical techniques. Work with operational personnel to implement.
Actively support the annual budget process and month-end closing.
Develop a comprehensive understanding of the full range of daily departmental activities to provide additional support with transaction processing and closing procedures when required.
Other Functions:
Performs other duties as assigned
Lead/participate in inter-departmental teams to assist in the review and improvement of controls and processes.
Work closely with the IT department to understand SAP S4/HANA table structures, programming enhancements and process changes.
Successful Candidate Profile:
BS in accounting, mathematics/statistics or business analytics required
0-2 years of experience with the collection, management and analysis of significant amounts of information with attention to detail and accuracy
Ability to combine fundamental knowledge of the production and processing of consumer products with STEM educational disciplines to identify problem-solving opportunities
Technical expertise with data models, SQL databases and business intelligence/data analysis software
Basic programming capabilities and use of database reporting software
Fundamental understanding of Cost and General Accounting
Adept at SQL queries, data organization and presentation
Strong interpersonal, communication, and problem-solving skills
Aptitude for quick learning and complex problem solving
Strong focus on process improvement and customer service
Ability to multi-task and respond to unplanned requests with minimal supervision
Woodstream is an Equal Employment Opportunity employer committed to recruit, hire, train and promote without regard to race, color, religion, creed, age, sex, national origin, marital status, union affiliation, disability, sexual orientation, or any other legally protected characteristic .
Note: If hired, Employment Eligibility Verification will be carried out upon selection. Applicants must be authorized to work for any U.S. employer.
We retain employment applications for a minimum of 2 years from date of receipt for non-hire applicants or from date of termination for employees/contractors and possibly longer if legally required.