Operations and Database Analyst
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 analysis of operations and material product costs, and provides ongoing support for departmental activities, accounting close, and budgeting processes. The analyst develops and analyzes product material costs for U.S. and Canadian operations, researches cost variances, identifies cost-saving opportunities, and helps maintain compliance with corporate policies, internal controls, and generally accepted accounting practices. The role also evaluates departmental database performance and accuracy, designs relational database structures and data collection methods, and develops analytical tools in collaboration with operational personnel. The analyst actively supports annual budgeting and month-end closing and works with IT on SAP S4/HANA structures, enhancements, and process changes.
Requirements
- Bachelor of Science 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 fundamental knowledge of consumer product production and processing with STEM disciplines to identify problem-solving opportunities.
- Technical expertise with data models, SQL databases, and business intelligence/data analysis software.
- Basic programming capabilities and experience using 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 multitask and respond to unplanned requests with minimal supervision.
Responsibilities
- Review and report operational performance to support decision-making.
- 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; help develop recommendations for tracking recurring variances.
- Lead analysis and identification of cost-saving projects related to the purchase network, particularly items that drive tariff mitigation.
- Lead evaluation of departmental database performance and accuracy.
- 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 on implementation.
- Support the annual budget process and month-end closing.
- Develop an understanding of daily departmental activities to provide support with transaction processing and closing procedures when required.
- Perform other duties as assigned.
- Lead or participate in interdepartmental teams reviewing and improving controls and processes.
- Work closely with IT to understand SAP S4/HANA table structures, programming enhancements, and process changes.
- Maintain regular attendance and punctuality.
Benefits
- 401k with company match
- Health insurance effective on the first day of employment
- Dental insurance effective on the first day of employment
- Vision insurance effective on the first day of employment
- Stable, growing working environment with a 150-year history
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Entry Level
