← Search all jobs

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

Similar jobs

Where Lancaster, PA ranks

Where Lancaster, PA placed in our monthly rankings, month by month. Each month stays online at its own address.

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.

Check how this applies to your own job

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.

  • SQL
  • Budgeting
  • SAP

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.