Senior Snowflake & dbt Data Architect

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

Job summary

Anblicks Inc. is seeking an experienced Senior Snowflake & dbt Engineer in Dallas to design, build, and optimize scalable data pipelines and modern data warehouse solutions.

You will work with Snowflake, dbt, SQL, and Azure to deliver analytics and reporting capabilities across enterprise data sources. You will develop modular dbt models, orchestrate ELT/ETL jobs, implement dimensional models, and drive data governance and quality initiatives.

Qualifications

• 6+ years of experience in Data Engineering, Cloud Data Warehousing, and Analytics Engineering.
• Strong expertise in Snowflake, dbt, SQL, ETL/ELT development, and Azure.
• Experience designing scalable data pipelines and modern data warehouse solutions.
• Experience with CI/CD pipelines for dbt deployments is preferred.

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.
• Develop reusable dbt models, macros, tests, snapshots, and documentation.
• Implement dimensional models (Star/Snowflake Schema) for reporting.
• Optimize Snowflake performance with tuning, clustering, and sizing.
• Design data quality frameworks, monitoring, and validations using dbt.
• Collaborate with analysts, scientists, and stakeholders to deliver data solutions.
• Develop CI/CD pipelines for dbt deployments and automate data workflows.
• Ensure data governance, security, and compliance in Snowflake environments.
• Troubleshoot data issues, perform root cause analysis, and implement preventive solutions.
• Create architecture diagrams and data lineage documentation.
• Mentor junior data engineers and establish engineering standards.

Skills

Data engineering

Analytics engineering

ETL/ELT development

Tools

Snowflake

dbt

Azure

SQL

CI/CD

Job description

Anblicks Inc. is seeking an experienced Senior Snowflake & dbt Engineer in Dallas to design, build, and optimize scalable data pipelines and modern data warehouse solutions.

You will work with Snowflake, dbt, SQL, and Azure to deliver analytics and reporting capabilities across enterprise data sources. You will develop modular dbt models, orchestrate ELT/ETL jobs, implement dimensional models, and drive data governance and quality initiatives.