Operations and Database Analyst

Lancaster, PA
Temporary
Entry Level

Our Brands will deliver innovate, effective, market leading pest, animal control & bird feeding solutions, while creating value for our shareholders.

Are you looking for a temporary role in Operations Finance within the CPG industry to enrich your experience and resume? We have an immediate 4-month opportunity for an Operations and Database Analyst in Lancaster, PA.


Benefits of Working for Woodstream:
  • Competitive benefits package include:
    • 401k with Company Match
  • 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:
  • 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.
  • Regular attendance and punctuality 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.
  • Performs other duties as assigned

Successful Candidate Profile:
  • BS in accounting, mathematics/statistics or business analytics required
  • 0-4 years of experience with the collection, management and analysis of significant amounts of information with attention to detail and accuracy
  • Advanced Excel skills
  • Ability to manage mass amount of data
  • 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.
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Human Check*