Data Warehouse Engineer

Company Overview: Hamilton Company is a worldwide leader in the design and manufacture of manual, semi-automated and robotic products for precision fluid measuring. We specialize in the development, manufacturing and customization of precision measurement devices, automated liquid handling stations, and sample management systems. For more than 60 years, Hamilton has been satisfying customer needs by combining quality materials with skilled workmanship, ensuring the highest level of performance of every precision fluid measuring device we manufacture. Responsibilities:

Hamilton Company is seeking a motivated, hands-on builder to help develop the data pipelines, integrations, and business systems that connect information and support better business decisions. This role combines data engineering, analytics, and technical business analysis, with opportunities to turn business requirements into working solutions.

Using a variety of skills and methods including SQL, Python, and Machine Learning you will build and maintain ETL/ELT pipelines, connect existing databases and applications, and contribute to new systems that capture, organize, and analyze business information. This position is suited to someone with strong SQL and Python skills who enjoys solving practical problems, learning new techniques, and building tools that people use.

Responsibilities:

• Build and maintain ETL/ELT pipelines that extract, transform, and integrate data from existing databases, business applications, and newly developed systems.
• Contribute to data warehouse development by implementing and maintaining tables, data models, and analytical datasets with architectural guidance.
• Work with business stakeholders and the technical manager to understand workflows, clarify requirements, and translate needs into defined technical tasks.
• Develop integrations, automation, and business system components that improve how information is captured, connected, and used.
• Help implement record-linkage and entity-resolution solutions using rules-based, probabilistic, and machine learning approaches; investigate uncertain matches and validate results.
• Prepare datasets and help develop, test, and evaluate forecasting and classification models.
• Integrate approved model outputs into data pipelines, business systems, dashboards, and reporting workflows.
• Implement data validation and reconciliation checks; investigate discrepancies and troubleshoot pipeline and integration issues.
• Collaborate with the technical manager and DevOps engineer to test, deploy, and monitor solutions using established engineering practices.
• Document data flows, business rules, integration logic, and changes so solutions are understandable and maintainable.
• Take ownership of assigned deliverables, communicate progress and blockers, and incorporate feedback from technical reviews.

Data Warehousing, Manufacturing, Specimens/Samples, Customer Satisfaction, Data Management, Business Solutions, Business Analysis, Data Analysis, Business Support, Database Extract Transform and Load (ETL), * Strong SQL skills for querying, transforming, validating, and troubleshooting relational data.

• Strong Python skills for data processing, analysis, and automation.
• Foundational understanding of data warehousing, relational data modeling, and ETL/ELT concepts.
• Foundational understanding of machine learning concepts and an interest in applying them to record linkage, forecasting, and classification.
• Strong problem-solving skills and the ability to work independently on assigned tasks while seeking guidance when needed.
• Clear communication skills and the ability to collaborate with technical and business colleagues.

Education/Experience:

• Bachelor’s degree.
• 2 + years of relevant experience in data engineering, data warehousing, business intelligence, analytics, or technical business analysis.

Preferred Skills

• Experience with Power BI, DAX.
• Exposure to record matching, deduplication, forecasting, or classification through work, coursework, or personal projects.
• Experience connecting applications or databases through APIs.
• Familiarity with version control, automated testing, and deployment workflows.

About Hamilton:

• Diverse portfolio of exciting and innovative design projects.
• Tremendous opportunities for professional growth.
• Commitment to sustainable design.
• Competitive compensation.
• Excellent benefit package includes medical, dental, vision insurance, paid vacation time, paid sick time, disability insurance, 401k, tuition reimbursement and more.
• Solid stable company.
• Must pass drug and background screens.
• May be required to wear Personal Protective Equipment (provided by employer).