Data Engineer

SUMMARY: The Data Engineer at Hercules Industries is responsible for building, governing, and continuously improving the data foundation that powers decision-making across supply chain, operations, and commercial functions. This role serves as both a steward of data integrity and a builder of scalable data infrastructure, enabling accurate, connected, and actionable data across the organization. $90,000 - $107,000 per year, DOE

The Data Engineer directly supports advanced analytics, MRP optimization, and real-time decision-making, forming a critical component of Hercules' transition to a modern, data-centric enterprise.

PURPOSE: Own the design, integrity, and performance of Hercules' data ecosystem by establishing scalable architecture, governing data quality, and enabling accessible, reliable data that drives operational and strategic decision-making across the business.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

DATA INTEGRITY, GOVERNANCE & STEWARDSHIP

• Establish and enforce data governance standards across ERP, data warehouse, and connected systems
• Ensure accuracy, consistency, and reliability of core datasets (item master, lead times, safety stock, supplier and customer data)
• Identify and remediate data quality issues through structured audits and data initiatives
• Define ownership, workflows, and controls for maintaining high-quality master data
• Implement monitoring systems to proactively detect and resolve data anomalies

Performance Expectations:

• Establish high trust in enterprise data
• Eliminate systemic data errors impacting operations
• Ensure consistent, governed data definitions

DATA ARCHITECTURE & SYSTEM INTEGRATION

• Design and maintain scalable data architecture connecting ERP (Infor M3), data warehouse, CRM, and external systems
• Build and manage data pipelines (ETL/ELT) to ensure timely and accurate data availability
• Enable seamless data flow across systems to support real-time and near-real-time decisions
• Standardize data models to support analytics and operational processes

Performance Expectations:

• Deliver reliable, scalable, and efficient data pipelines

• Reduce latency and manual intervention across systems

• Enable seamless system integration MRP & OPERATIONAL SYSTEM ENABLEMENT

• Ensure MRP and planning systems are supported by accurate and structured data

• Partner with supply chain and operations to optimize lead times, safety stock, and planning parameters

• Identify and resolve data issues driving inefficiencies in purchasing, production, and inventory

• Support the evolution of MRP into a proactive, optimized planning system

Performance Expectations:

• Improve effectiveness of MRP and planning systems
• Reduce operational inefficiencies caused by poor data
• Enable proactive planning capabilities

DATA ACCESSIBILITY & DECISION ENABLEMENT

• Build data models that make data accessible for analysts, data scientists, and business leaders
• Develop datasets that enable rapid analysis and insight generation
• Support dashboards, reporting tools, and self-service analytics capabilities
• Ensure key business metrics are consistently defined and trusted

Performance Expectations:

• Improve accessibility and usability of enterprise data
• Enable faster, more informed decision-making
• Establish consistency in key business metrics

CROSS-FUNCTIONAL COLLABORATION

• Partner with Data Science to provide clean, structured datasets for modeling
• Translate business requirements into data architecture solutions
• Work with supply chain, operations, and finance leaders to prioritize data needs
• Serve as a bridge between technical systems and business application

Performance Expectations:

• Build strong cross-functional relationships
• Align data solutions with business needs
• Influence adoption of data-driven practices

TRANSFORMATION & CONTINUOUS IMPROVEMENT

• Lead initiatives to modernize data infrastructure and capabilities
• Identify opportunities to automate manual processes and eliminate workarounds
• Drive transition toward a fully integrated, data-driven operating model
• Establish best practices for data engineering within the organization

Performance Expectations:

• Drive measurable improvements in efficiency and data reliability
• Reduce reliance on manual processes and spreadsheets
• Contribute to long-term digital transformation

KEY PERFORMANCE FOCUS AREAS

Performance in this role is measured through contribution to:

• Data accuracy, integrity, and reliability across systems
• System integration and data pipeline performance
• MRP and planning system effectiveness
• Accessibility and usability of data for decision-making
• Reduction of manual processes and data issues
• Business impact including inventory, service levels, and operational efficiency

WHAT SUCCESS LOOKS LIKE

• Measurable business impact across supply chain, operations, and commercial performance
• Data-driven decision-making becomes embedded in daily operations
• Strong adoption of models and insights across the organization
• Continuous pipeline of high-value analytical initiatives
• Recognized as a key contributor to enterprise transformation

QUALIFICATIONS, EDUCATION AND/OR EXPERIENCE: To perform this job successfully, an individual must be able to perform each of the below essential duties satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability preferred. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree preferred (Data Engineering, Computer Science, Information Systems, or related field)
• Experience with data architecture, data pipelines, and system integration
• Experience working with ERP systems, data warehouses, and analytics platforms
• Strong understanding of data governance, data quality, and master data management
• Experience supporting supply chain, operations, or business analytics environments preferred
• Proficiency in data tools, SQL, and data modeling concepts
• Strong analytical and problem-solving skills
• Ability to translate business needs into technical solutions
• Experience working cross-functionally in a fast-paced environment

Why Hercules

• Opportunity to make a material impact; your work will matter
• Work in a company that is actively transforming and investing in data and analytics
• Employee-owned (ESOP), aligning effort with long-term value creation
• Right-sized organization: large enough for complexity, small enough for visibility and impact
• A culture that values curiosity, problem-solving, and continuous improvement

LANGUAGE SKILLS: Ability to effectively communicate with customers and staff to make an accurate assessment of customer needs.

MATHEMATICAL SKILLS: Ability to perform basic mathematical calculations required to accurately complete assigned tasks.

COMPUTER SKILLS: Intermediate/Advanced computer skills, including Microsoft Office and ability to learn any additional software needed to perform job duties.

REASONING ABILITY: Ability to interpret a variety of instructions furnished in oral or written form. Ability to use sound judgment and problem-solving skills.

ATTENDANCE DEMANDS: The attendance demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Attendance is required Monday through Friday 8:00 A.M. to 5:00 P.M. or within normal business hours as established by the supervisor. Employee may be required to work overtime, and occasional Saturday's and Sunday's.

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; walk and stand; use hands, handle, or feel; and required to speak, read, and hear English. The employee frequently is required to reach with hands and arms. The employee is occasionally required to climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include the ability to adjust focus.

WORK ENVIRONMENT: The work environmental characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• The noise level in the work environment is usually moderate but may be loud on occasion.
• This position may on occasion be exposed to extreme weather conditions that may affect a warehouse environment.
• This is a fast-paced environment.

DISCLAIMER: The preceding job description is designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

Hercules Industries is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, status as a qualified individual with disability, or other legally protected status.