Operations and Database Analyst

Woodstream•East Lampeter Township, PA

6d•Onsite

About The Position

Woodstream is seeking an Operations and Database Analyst for a temporary role in Operations Finance within the CPG industry. This position is based in Lancaster, PA. The role involves reviewing and reporting on operational performance, optimizing departmental databases for analysis of operations and material product costs, and supporting departmental activities, accounting close, and budgeting processes.

Requirements

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

Responsibilities

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.
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.