Senior DBT Consultant
Trility Consulting
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Job Level
Tech Stack
About the role
- 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
Requirements
- 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
Benefits
- Work remotely anywhere in the United States with flexible work hours
- Sponsored and supported learning opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
dbtSQLdata modelingautomated testingdata validationdata transformationperformance optimizationdata pipeline troubleshootingdata quality assurancemodularization
Soft Skills
communicationindependenceknowledge transfercollaborationproblem-solving