Design, develop, and maintain dbt models to transform raw data into analytics-ready datasets
Refactor and modularize existing dbt implementations, simplifying complex SQL into reusable, testable components
Implement and enforce dbt best practices, including folder structure, macros, seeds, incremental models, and environment promotion patterns
Translate business reporting requirements into structured data models and transformation logic
Ensure data quality through dbt testing, documentation, lineage, and source freshness monitoring
Troubleshoot and resolve issues across the data pipeline, from ingestion through transformation and reporting layers
Optimize SQL queries and dbt models for performance, maintainability, and scalability
Support reporting go-live efforts and contribute to long-term data support planning
Partner with internal teams for knowledge transfer, documentation, and integration alignment

Must reside within the United States
Must be authorized to work in the United States without sponsorship now or in the future
Must be able to pass a background check
5+ years of experience in data engineering or data consulting roles
Advanced SQL skills with demonstrated experience writing complex, performance-optimized queries
Strong hands-on experience with dbt in production environments
Experience refactoring and modularizing legacy SQL into maintainable transformation layers
Deep understanding of data modeling concepts, including staging, intermediate, and mart layer design
Experience implementing automated testing and data validation within dbt
Ability to work independently in established data environments and improve structure without full re-architecture
Strong communication skills and ability to translate business reporting needs into data solutions

Senior DBT Consultant

Key skills