Operations and Database Analyst

Posted Yesterday
Be an Early Applicant
Lancaster, PA, USA
In-Office
Junior
Marketing Tech
The Role
Analyzes operational performance, product material costs, cost variances, and cost-saving opportunities across U.S. and Canadian operations. Maintains and evaluates departmental databases, designs relational data structures, develops analytical tools, and supports budgeting, accounting close, controls, and transaction processing. Collaborates with IT on SAP S/4HANA structures and process changes while assisting with process improvement and cross-functional initiatives.
Summary Generated by Built In

Woodstream is the largest independent pest & animal control platform in North America, offering innovative brands with industry-leading efficacy and safety.


Looking to grow your financial experience in the Consumer Products Industry? We have an immediate opportunity for a temporary Operations and Database Analyst in Lancaster, PA.

 

At Woodstream, our values drive everything we do:

  • Consumer is the Boss – We are committed to listening to and understanding our customers’ needs!
  • Invent the Future – Challenge the status quo: Think boldly and creatively!
  • Execution is Everything – We are committed to deliver with excellence, speed, and accuracy.
  • Collaborate Confidently – We trust, respect, and empower each other to win together.
  • Play to Win – We’re bold, ambitious, and relentless in our pursuit of success.


Benefits of Working for Woodstream:

  • Competitive benefits package include:
    • 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.


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:

  • Regular attendance and punctuality required 
  • 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.



Other Functions:

  • Performs other duties as assigned
  • 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
  • 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.

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.

Skills Required

  • Bachelor’s degree in accounting, mathematics/statistics, or business analytics
  • 0–2 years of experience collecting, managing, and analyzing significant amounts of information
  • Knowledge of production and processing of consumer products combined with STEM-based problem solving
  • 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 data 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
  • Authorization to work for any U.S. employer
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Lancaster Park, IN
391 Employees
Year Founded: 1830

What We Do

Woodstream has been manufacturing and marketing consumer products for over a century. Nearly doubling in size in the past few years, Woodstream’s growth has been driven by a customer-driven approach to product development, a dedicated design organization that focuses on innovation, quality, and safety, and a commitment to an industry-leading level of service for retailers and end-user customers. Notably, we have executed numerous strategic acquisitions, successfully managed the subsequent integration activities, and assembled a robust portfolio of company-owned brands to better serve the market. Corporate management focuses on cross-segment and cross-business synergies that can increase overall company margins, operational efficiencies, market share, retail relationships, and revenue growth. Our strategies are straightforward – build brand awareness and acceptance of our superior products, continue to develop proprietary technologies, commercialize innovative new products, drive products through our diversified and growing distribution network, and maximize long-term profitability while increasing market share and revenues in key vertical markets. With our proven brands, efficient manufacturing and sourcing, consolidated distribution, strong customer relationships, and innovative products, we have created a solid foundation for continued growth from which we can expand market share and build competitive advantages in all markets.

Similar Jobs

General Motors Logo General Motors

Field Service Engineer - Albany, NY

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
70K-107K Annually

General Motors Logo General Motors

District Manager, OnStar & Loyalty - Syracuse, NY

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Remote or Hybrid
United States
165000 Employees
81K-109K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Sr. Manager MRO

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Hybrid
Lansdale, PA, USA
4600 Employees

T-Mobile Logo T-Mobile

Account Executive

Other • Utilities
In-Office
Allentown, PA, USA
89016 Employees
43K-78K Annually

Similar Companies Hiring

MFour Data Research Thumbnail
Marketing Tech • Software
Irvine, CA
98 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
30 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account