dbt Engineer

Blue Cross of Idaho; Carmel (IN); Hybrid; USD 96,183 - 144,275; Full time

Benefits offered by this job

401(k) matching

Paid time off

Medical/Dental/Vision Insurance

Job summary

Blue Cross of Idaho is looking for a dbt Engineer to design and optimize data pipelines using dbt Cloud within a Snowflake environment. The role is hybrid, allowing for on-site work and remote opportunities.

The ideal candidate will have significant experience in data engineering, specifically with dbt, SQL, and cloud data warehousing, preferably in the healthcare sector. Comprehensive benefits include medical insurance, 401(k) matching, paid leave, and performance-based bonuses.

Qualifications

• 2-4+ years of data or analytics engineering experience, ideally in healthcare.
• Hands-on experience with dbt Cloud and advanced concepts.
• Strong communication, problem-solving, and collaboration skills.

Responsibilities

• Lead design and optimization of data pipelines using dbt Cloud.
• Implement CI/CD pipelines and manage data quality strategies through testing.
• Collaborate with analysts and scientists to translate business requirements.

Skills

Data Engineering

dbt

SQL

Python Scripting

Cloud Data Warehousing

Data Modeling Principles

Version Control (Git)

Tools

dbt Cloud

Snowflake

GitHub Actions

Job description

We're seeking a dbt Engineer to lead the design, implementation, and optimization of data pipelines using dbt Cloud in a Snowflake environment.

Location

Hybrid work: on‑site at the Meridian Idaho campus and WFH, with opportunities for fully remote within a mutually acceptable location.

Qualifications

• 2‑4+ years of data engineering or analytics engineering experience, preferably in healthcare.
• 2‑3+ years of extensive experience with dbt, including advanced concepts such as 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.

Preferred Qualifications

• Experience leveraging AI‑powered assistants (e.g., Claude Code, dbt Copilot, Cursor) to automate routine tasks such as generating documentation, authoring tests, and scaffolding dbt models.
• Experience implementing AI‑enhanced workflows to streamline development, using intelligent code suggestions and state‑aware orchestration.
• 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 (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 such as GitHub Actions, ensuring 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.
• 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.

Compensation & Benefits

Base salary ranges: $96,183 to $144,275 for Engineer II; $118,506 to $177,758 for Engineer III. Eligible for an annual incentive bonus based on performance.

Benefits: 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‑term and long‑term disability, education reimbursement, employee assistance plan, adoption assistance program, and paid family leave.

Reasonable Accommodations

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Equal Opportunity Employer

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, or basis of disability.