Operations and Database Analyst

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

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

• 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
• Adept at multi-tasking and responding to unplanned requests with minimal supervision

Benefits Of Working For Woodstream

• Competitive benefits package including 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

Company Information

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