Operations and Database Analyst

Woodstream•Lancaster, PA

22d•Onsite

About The Position

Woodstream is hiring a temporary Operations and Database Analyst in Lancaster, Pennsylvania. The role reviews and reports operational performance to support decision-making, optimizes departmental databases for operational and material-cost analysis, and provides ongoing support for departmental activities, accounting close, and budgeting. The analyst develops and controls product material costs for U.S. and Canadian operations, researches cost variances, and identifies cost-saving opportunities, including tariff mitigation. The role also evaluates departmental database performance and accuracy, designs relational database structures and data-collection methods, and creates analytical tools in collaboration with operational personnel. The successful candidate supports the annual budget and month-end close, assists with transaction processing when needed, and works with IT to understand SAP S4/HANA table structures, programming enhancements, and process changes. Regular attendance and punctuality are required.

Requirements

Bachelor of Science degree in accounting, mathematics/statistics, or business analytics.
0–2 years of experience collecting, managing, and analyzing significant amounts of information, with attention to detail and accuracy.
Ability to combine knowledge of consumer-product production and processing with STEM education to identify problem-solving opportunities.
Technical expertise with data models, SQL databases, and business intelligence or data-analysis software.
Basic programming capabilities and experience using database reporting software.
Fundamental understanding of cost and general accounting.
Proficiency with SQL queries, data organization, and presentation.
Strong interpersonal, communication, and problem-solving skills.
Ability to learn quickly and solve complex problems.
Strong focus on process improvement and customer service.
Ability to multitask and respond to unplanned requests with minimal supervision.
Must be authorized to work for any U.S. employer.

Responsibilities

Develop, analyze, and control product material costs for U.S. and Canadian operations.
Ensure conformance with corporate policies and internal controls, and maintain records in accordance with generally accepted accounting practices.
Research and analyze material cost variances related to product sourcing, manufacturing, and logistics; recommend ways to track recurring variances when appropriate.
Lead analysis and identification of cost-saving projects related to the purchase network, particularly opportunities for tariff mitigation.
Evaluate the performance and accuracy of departmental databases.
Design relational database structures and data-collection methods using internal and external data sources.
Assist in recommending potential purchases of external database products used in analysis.
Use operational knowledge to create analytical tools and statistical techniques, and work with operational personnel to implement them.
Support the annual budget process and month-end closing.
Develop an understanding of daily departmental activities and provide additional support for transaction processing and closing procedures when needed.
Perform other duties as assigned.
Lead or participate in interdepartmental teams reviewing and improving controls and processes.
Work with IT to understand SAP S4/HANA table structures, programming enhancements, and process changes.
Maintain regular attendance and punctuality.