dbt Engineer II or III

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.

Key Responsibilities

dbt Development and Best Practices

• Build, develop, and maintain a robust dbt project using dbt Cloud, ensuring alignment with a layered approach (e.g., staging, intermediate, marts).

Data Pipeline Implementation

• Build and maintain optimized ELT/ETL pipelines within Snowflake using dbt, focusing on efficient SQL transformations, materializations (tables, views, incremental models), and performance tuning.

Automation and CI/CD

• 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.

Testing and Data Quality

• 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.

Data Lineage and Governance

• 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.

Collaboration and Mentorship

• 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.

Performance Optimization

• Actively monitor and optimize dbt project performance in Snowflake, including managing costs, optimizing query execution, and selecting the most appropriate materialization strategy.

Advanced Features and Ecosystem

• 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.

Required Qualifications

Location: this position has preference to based in hybrid work location (onsite at Meridian Idaho campus and WFH). There may be opportunity for fully remote within a mutually acceptable location. #LI-Hybrid

Education: Bachelor's degree in quantitative or related technical field, or equivalent practical experience (two years’ relevant work experience is equivalent to one-year college).

Experience: 2-4/+ in data engineering or analytics engineering, preferably in healthcare. Experience should also span:

• 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.

Preferred Qualifications

• 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)

As of the date of this posting, a good faith estimate of the current pay range is $96,183 to $144,275 as Engineer II; $118,506 to $177,758 as Engineer III. The position is eligible for an annual incentive bonus (variable depending on company and employee performance).

The pay range for this position takes into account a wide range of factors including, but not limited to, specific competencies, relevant education, qualifications, certifications, relevant experience, skills, seniority, performance, travel requirements, internal equity, business or organizational needs, and alignment with market data. At Blue Cross of Idaho, it is not typical for an individual to be hired at or near the top range for the position. Compensation decisions are dependent on factors and circumstances at the time of offer.

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.

We will adhere to all relevant state and local laws concerning employee leave benefits, in line with our plans and policies.

Reasonable accommodations

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

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, and basis of disability or any other federal, state or local protected class.