Operations and Database Analyst

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.