Data Warehouse Engineer

Hamilton Company; Reno (NV); On-site; USD 90,000 - 130,000; Full time

Job summary

Hamilton Company, a worldwide leader in precision fluid measurement technologies, seeks a hands-on data engineer to design and maintain ETL/ELT pipelines, support data warehousing, and build analytics tools. You will work with SQL, Python, and ML approaches to improve data capture, validation, and business decisions.

The role involves collaborating with stakeholders, implementing models, and integrating outputs into dashboards and reporting workflows. Onsite in Reno, NV with competitive benefits.

Qualifications

• Bachelor’s degree required.
• 2+ years of relevant experience in data engineering, data warehousing, BI, analytics, or technical business analysis.
• Strong SQL, Python, and data pipeline experience.
• Foundational understanding of data warehousing, relational modeling, and ETL/ELT concepts.
• Interest in applying ML to record linkage, forecasting, and classification.

Responsibilities

• Build and maintain ETL/ELT pipelines transforming data from databases and applications.
• Contribute to data warehouse development with data models and datasets.
• Clarify requirements with stakeholders and translate into technical tasks.
• Develop integrations, automation, and components to improve data capture and use.
• Implement record-linkage solutions using rules-based, probabilistic, and ML approaches; validate results.
• Prepare datasets and help develop forecasting and classification models.
• Integrate model outputs into data pipelines, dashboards, and reporting workflows.
• Implement data validation and reconciliation checks; troubleshoot issues.
• Collaborate with DevOps to test, deploy, and monitor solutions.

Skills

SQL

Python

Data modeling

Machine learning

Problem solving

Communication

Education

Bachelor’s degree

Tools

Power BI

DAX

APIs

Version control

Automated testing

Job description

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.

This position is located onsite in Reno, Nevada.

Qualifications

• 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).

EEO - It is the policy of this organization to provide equal employment opportunities to all qualified applicants without regard to race, creed, color, national origin, sex, age 40 and over, disability, marital status, sexual orientation, gender identity, genetic information, citizenship status, religious preference, or veteran status in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations.