Senior DBT Consultant

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. 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 • 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 • 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 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.