dbt Engineer

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

Pay

A good faith estimate of the current pay range is $96,183 to $144,275 (Engineer II); $118,506 to $177,758 (Engineer III). The position is eligible for an annual incentive bonus (variable depending on company and employee 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 and long term disability
• Education reimbursement
• Employee assistance plan (EAP)
• Adoption assistance program
• Paid family leave program