Data Warehouse Engineer

Hamilton Company

. Build and maintain ETL/ELT pipelines extracting, transforming, and integrating data from databases, business applications, and newly developed systems .

Posted 11/7/2026full-timeReno • Nevada • United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining ETL/ELT pipelines, data warehousing, and data modeling, with strong skills in SQL and Python for data processing and analysis. Capable of collaborating with stakeholders to translate business needs into technical solutions while ensuring data integrity and validation.

Highest-signal resume keywords

SQLPythonETL/ELTData WarehousingMachine Learning

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonETLELTData ModelingData WarehousingData ValidationData IntegrationMachine LearningForecasting

Soft Skills

Problem-SolvingClear CommunicationCollaboration

Industry Keywords

Data EngineeringBusiness IntelligenceAnalyticsTechnical Business AnalysisRecord Linkage

Tech Stack

Tools & technologies

ETLPythonSQL

About the role

Key responsibilities & impact

Build and maintain ETL/ELT pipelines extracting, transforming, and integrating data from databases, business applications, and newly developed systems
Contribute to data warehouse development by implementing and maintaining tables, data models, and analytical datasets
Work with business stakeholders and the technical manager to understand workflows, clarify requirements, and translate needs into technical tasks
Develop integrations, automation, and business system components
Implement record-linkage and entity-resolution solutions using rules-based, probabilistic, and machine learning approaches
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
Document data flows, business rules, integration logic, and changes
Own assigned deliverables, communicate progress and blockers, and incorporate feedback from technical reviews

Requirements

What you’ll need

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 ability to work independently on assigned tasks while seeking guidance when needed
Clear communication skills and ability to collaborate with technical and business colleagues
Bachelor’s degree
2+ years of relevant experience in data engineering, data warehousing, business intelligence, analytics, or technical business analysis
Must pass drug and background screens
May be required to wear Personal Protective Equipment

Benefits

Comp & perks

Tremendous opportunities for professional growth
Commitment to sustainable design
Competitive compensation
Medical insurance
Dental insurance
Vision insurance
Paid vacation time
Paid sick time
Disability insurance
401k
Tuition reimbursement
Personal Protective Equipment provided by employer