dbt Engineer II or III

Blue Cross of Idaho • Bozeman, MT

7d • $96,183 - $177,758 • Hybrid

About The Position

We're seeking out a dbt Engineer as an expert in data transformation and analytics engineering, responsible for leading the design, implementation, and optimization of our data pipelines using dbt (Data Build Tool) Cloud in a Snowflake environment. This role requires deep knowledge of dbt guidelines, ecosystem tooling, and continuous integration and delivery pipelines to deliver high-quality, trusted data models for analytics, reporting, and downstream applications. You will be instrumental in building a modern data platform that is scalable, reliable, and well-documented.

Requirements

• Bachelor's degree in quantitative or related technical field, or equivalent practical experience (two years’ relevant work experience is equivalent to one-year college).
• 2-4/+ in data engineering or analytics engineering, preferably in healthcare.
• 2-3+ years of extensive experience with dbt, including advanced concepts like Jinja macros, packages, and custom tests.
• Hands-on experience with dbt Cloud, including project setup, environment management, and job orchestration.
• Proven experience working with a cloud data warehouse, preferably Snowflake.
• Expertise in writing and optimizing complex SQL queries.
• Strong understanding of data modeling principles (e.g., Kimball, Data Vault).
• Experience with Python scripting for data-related tasks and automation.
• Familiarity with version control (Git) and CI/CD practices.
• Excellent communication, problem-solving, and collaboration skills.

Nice To Haves

• Leveraging AI-powered assistants is highly desired. (e.g., Claude Code, dbt Copilot, Cursor) to automate routine tasks, including generating documentation, authoring data quality tests, and scaffolding dbt models.
• Implementing AI-enhanced workflows is highly desired. (To streamline development, using intelligent code suggestions and state-aware orchestration to reduce manual refactoring and increase developer velocity, etc)
• dbt Certification (e.g., dbt Analytics Engineering Certification)

Responsibilities

• Build, develop, and maintain a robust dbt project using dbt Cloud, ensuring alignment with a layered approach (e.g., staging, intermediate, marts).
• Build and maintain optimized ELT/ETL pipelines within Snowflake using dbt, focusing on efficient SQL transformations, materializations (tables, views, incremental models), and performance tuning.
• Implement and manage CI/CD pipelines for dbt using dbt Cloud's native features or integrations with tools like GitHub Actions, ensuring that code changes are automatically tested and deployed.
• Develop and implement a comprehensive testing strategy using dbt's built-in and custom tests to ensure data quality, accuracy, and integrity. Leverage external integrations and dbt packages for advanced testing, data observability (e.g., Metaplane), and data quality monitoring.
• Apply dbt's data lineage features to create a transparent, end-to-end view of data flow from source to final models, visualizing dependencies via the Directed Acyclic Graph (DAG). Enrich models with metadata and documentation using schema.yml to improve data discovery and governance.
• Collaborate with data analysts, data scientists, and business partners to translate business requirements into technical dbt models. Provide technical leadership, participate in code reviews, and mentor other team members on dbt methodologies and engineering standard processes.
• Actively monitor and optimize dbt project performance in Snowflake, including managing costs, optimizing query execution, and selecting the most appropriate materialization strategy.
• Stay current with new dbt features (e.g., Semantic Layer, column-level lineage) and leverage other tools in the modern data stack to enhance dbt capabilities.

Benefits

• We offer a robust package of benefits including paid time off, paid holidays, community service and self-care days, medical/dental/vision/pharmacy insurance, 401(k) matching and non-contributory plan, life insurance, short and long term disability, education reimbursement, employee assistance plan (EAP), adoption assistance program and paid family leave program.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees