Dbt Engineer II or III

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 Git Hub 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.

• 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+ years 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, 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.

• Experience leveraging AI‑powered assistants (e.g., Claude Code, dbt Copilot, Cursor) to automate routine tasks such as generating documentation, authoring data quality tests, and scaffolding dbt models.
• dbt Certification (e.g., dbt Analytics Engineering Certification).

Hybrid work location: onsite at the Meridian Idaho campus and WFH. Fully remote work may be considered for a mutually acceptable location.

Pay range: $96,183 to $144,275 for Engineer

II; $118,506 to $177,758 for Engineer

III. Eligible for an annual incentive bonus. Comprehensive benefits package includes paid time off, holidays, medical/dental/vision/pharmacy insurance, 401(k) matching, life insurance, disability, education reimbursement, EAP, adoption assistance, paid family leave, and community service days.

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 disability. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. We comply with all state and local laws concerning employee leave benefits.

Equal Opportunity is the Law. EEO is the Law. Supplement E-Verify Pay Transparency.