Operations and Database Analyst

Woodstream; Lancaster (Lancaster County); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

401k with Company Match

Health, Dental & Vision Insurance

Job summary

Woodstream is seeking an Operations and Database Analyst to support reports on operational performance and to optimize databases for cost analysis in the Lancaster, PA area. This temporary role offers exposure to purchasing networks and budgeting processes within a 150-year legacy consumer products company.

The ideal candidate has 0-2 years of data analysis experience, strong SQL skills, and a foundation in accounting or analytics. Join a team dedicated to accuracy, speed, and cost efficiency.

Qualifications

• BS in accounting, mathematics/statistics or business analytics.
• 0-2 years of data collection/analysis experience.
• Knowledge of production processes in consumer products.
• Proficient in SQL and data presentation.

Responsibilities

• Review and report operational performance for decision making.
• Optimize departmental databases to analyze costs.
• Support accounting close and budgeting processes.
• Lead cost savings analysis for purchase networks.
• Design database structures and data collection methods.

Skills

SQL queries

Data analysis

BI software

Interpersonal skills

Education

BS in accounting or related field

Tools

SAP S4/HANA

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Operations and Database Analyst

TEMP Professional Lancaster, PA, US

2 days ago Requisition ID: 1772

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.