The Senior DBT Consultant will transform data into analytics-ready datasets, optimize existing dbt models, and ensure data quality, requiring strong SQL and DBT skills.
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
- 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
Top Skills
Dbt (Data Build Tool)
SQL
Similar Jobs
Software • Defense
The Senior Manager of Contracts, Strategy will lead the Contracting Team, focusing on contract management, negotiation, and building effective workflows to align contracting with business goals. This role requires a deep understanding of federal contracting and strong leadership skills to drive high-quality outcomes across various functions.
Software • Defense
The Principal Product Manager will drive the vision and strategy for Onebrief's core application, oversee multiple teams, and ensure product quality and user experience, focusing on high-impact outcomes.
Top Skills:
AirtableAtlassianCodaDropboxFigmaGoogle DocsMicrosoft 365MiroNotionSlackSmartsheetTeams
Software • Defense
As a Data Engineer, you will design and maintain data pipelines, build data storage systems, and support analytics workflows, ensuring data reliability and performance. You will collaborate with engineers to define data structures and improve data management practices.
Top Skills:
AWSAzureGCPPythonSQL
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
