dbt Engineer

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. #J-18808-Ljbffr Blue Cross of Idaho