Description
Senior DBT Consultant
Team: Technology
Location: United States
Commitment: Independent Contractor (1099)
Workplace Type: remote
Who We Are
At Trility Consulting®, we’ve built a strong, remote-work culture where people thrive, grow, and support each other – earning us Great Place to Work® Certification. Headquartered in Central Iowa, we embrace flexible schedules and collaboration across geographically distributed teams serving clients from all corners of the United States and globally.
We seek team members with the grit necessary to forge paths where none previously existed, to get back up when circumstances knock them down, to adapt to the changing needs of the client even when it is uncomfortable, and to deliver on our commitments. Candidates must respect and value people, recognize that over-communication is barely good enough, thrive on solving complex problems, have a passion for building teams, and know that delivering what a client actually values is more important than their own predispositions. They understand value proposition, love delivering value, and take pride in learning the expansive and ever-changing business of clients. Candidates are self-motivated and relentlessly working to become more today than they were yesterday.
What You Will Do
We are seeking a Senior DBT Consultant with strong SQL and DBT (Data Build Tool) expertise to transform existing data into reliable, analytics-ready datasets that power critical business and SLA reporting.
In this role, you will take an established data environment and refine, structure, and optimize it for reporting and long-term scalability. This is not a ground-up platform build — the data exists. Your focus will be on making it clean, structured, performant, and trusted.
This is a hands-on role for someone who thrives on turning complex SQL into elegant, modular transformations and building scalable dbt models that other engineers can confidently maintain.
This is a remote 1099 position. Please no C2C.
Key Responsibilities
- 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
- Design, build, and maintain Apache Airflow DAGs to orchestrate dbt transformations and manage end-to-end data pipeline dependencies.
- 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
Qualifications
- 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
- Hands-on experience building and maintaining Apache Airflow DAGs to orchestrate dbt transformations and data pipelines
- 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
How We Put You First
Trility’s culture is built upon the journey, character, and work ethic of our team members. We are a team of honorable and professional lifelong learners who work together to solve problems proactively.
• Work remotely anywhere in the United States with flexible work hours
• Sponsored and supported learning opportunities
Job 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
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say