Sr Snowflake DBT Engineer

Anblicks Inc.; Dallas (TX); On-site; USD 140,000 - 200,000; Full time

Job summary

Anblicks Inc. seeks a Senior Snowflake & dbt Engineer to design, build, and optimize scalable data pipelines and modern data warehouse solutions for enterprise analytics. The role emphasizes Snowflake, dbt, SQL, ETL/ELT, and Azure cloud.

You will collaborate with data analysts, scientists, and product teams to deliver data solutions, mentor junior engineers, and implement governance and quality frameworks while advancing CI/CD for data workflows.

Qualifications

• 6+ years of experience in data engineering and analytics engineering.
• Experience with cloud data warehousing.
• Strong SQL and data modeling skills.

Responsibilities

• Design, develop, and maintain scalable data solutions using Snowflake and dbt.
• Build and optimize ELT/ETL pipelines from multiple sources.
• Develop reusable dbt models, tests, snapshots, and documentation.
• Implement dimensional models (Star & Snowflake Schema) for reporting.
• Optimize Snowflake performance via tuning, clustering, partitioning, and sizing.
• Design data quality frameworks, monitoring, and automated validations using dbt.
• Collaborate with analysts, scientists, stakeholders, and product teams to deliver data solutions.
• Develop CI/CD pipelines for dbt deployments and automate data workflows.
• Ensure data governance, security, compliance, and best practices in Snowflake environments.
• Troubleshoot data issues, perform root cause analysis, and implement preventive measures.
• Create technical documentation, architecture diagrams, and data lineage.

Skills

Data Engineering

Analytics Engineering

ETL/ELT development

SQL

Cloud Data Warehousing

Tools

Snowflake

dbt

Azure

Job description

We are seeking an experienced Senior Snowflake & dbt Engineer with 6+ years of experience in Data Engineering, Cloud Data Warehousing, and Analytics Engineering. The ideal candidate will have strong expertise in Snowflake, dbt (Data Build Tool), SQL, ETL/ELT development, and Azure cloud platform . The candidate will be responsible for designing, developing, optimizing, and maintaining scalable data pipelines and modern data warehouse solutions to support enterprise analytics and reporting initiatives.

Key Responsibilities

• Design, develop, and maintain scalable data solutions using Snowflake and dbt .
• Build and optimize ELT/ETL pipelines to ingest, transform, and load large-scale data from multiple sources.
• Develop reusable and modular dbt models, macros, tests, snapshots, and documentation.
• Implement dimensional data models including Star Schema and Snowflake Schema for reporting and analytics.
• Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse sizing.
• Design and implement data quality frameworks, monitoring, and automated validations using dbt.
• Collaborate with Data Analysts, Data Scientists, Business Stakeholders, and Product teams to understand requirements and deliver data solutions.
• Develop CI/CD pipelines for dbt deployments and automate data workflows.
• Ensure data governance, security, compliance, and best practices within Snowflake environments.
• Troubleshoot data issues, perform root cause analysis, and implement preventive solutions.
• Create technical documentation, architecture diagrams, and data lineage documentation.
• Mentor junior data engineers and establish engineering standards and best practices.
• Experience with orchestration tools such as: Azure Data Factory (ADF)
• Understanding of data governance, security, metadata management, and data lineage.
• Experience handling structured and semi-structured data (JSON, XML, Parquet, Avro).

Nice To Have: Knowledge in HRMS or Finance data