Staff Data Engineer
Hauler Hero
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Job Level
About the role
- Own the end-to-end architecture of the data migration platform, from ingestion through validation to production deployment
- Design migration infrastructure that reduces per-customer engineering effort through reusable components and standardized patterns
- Build systems that evolve migrations from engineer-led to standardized and self-service
- Establish automated data quality frameworks including profiling, validation, and anomaly detection
- Instrument migration systems with dashboards, metrics, and alerts for observability and continuous improvement
- Architect self-service import workflows for customers and internal teams
- Design ingestion pipelines that align tightly with Hibernate entity models and lifecycle rules
- Build intelligent error handling and feedback loops that guide non-technical users through data correction
- Create Excel-based import templates with embedded validation, documentation, and formatting standards
- Maintain alignment with application changes by tracking Hibernate model evolution and updating pipelines proactively
- Design, build, and maintain ETL pipelines for migrating data from legacy waste management systems
- Analyze legacy datasets, reverse-engineer business logic, and implement transformation workflows
- Execute end-to-end customer migrations in coordination with technical and business stakeholders
- Build tooling to ingest data from legacy LAN-based systems common in the industry
- Optimize pipeline performance to handle large datasets efficiently and reduce migration timelines
- Drive technical decisions for data infrastructure, including build vs. buy evaluations
- Partner with Product, Engineering, and Customer Success to shape scalable solutions
- Mentor team members on data integration and migration patterns
- Create and maintain documentation, runbooks, and operational guides
- Lead code reviews and knowledge sharing to raise the bar across the team
Requirements
- Advanced SQL expertise including query optimization and schema design
- Advanced Python proficiency with:
- - SQLAlchemy (ORM and Core)
- - Pandas for transformation and profiling
- - Data validation frameworks (Pydantic or similar)
- Deep experience with Hibernate or similar ORMs, including lifecycle and performance implications
- Proven track record building frameworks and platforms, not just pipelines
- Strong Git and collaborative development practices
- Experience designing data architectures for transformation, metadata, and orchestration
- History working with large, disconnected datasets
- Strong computer science fundamentals and commitment to maintainable code.
Benefits
- Competitive salary + equity
- Health, dental, vision insurance
- Flexible PTO
- Remote-first culture
- Modern development tools and AI assistants
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLPythonSQLAlchemyPandasPydanticHibernateETLdata migrationdata validationdata architecture
Soft Skills
mentoringcollaborationtechnical decision-makingdocumentationcode reviewsknowledge sharingproblem-solvingcommunicationleadershiporganizational skills