The Role
Designs, develops, and optimizes scalable Snowflake and dbt data warehouse solutions, including ELT/ETL pipelines, dimensional models, data quality frameworks, CI/CD workflows, governance, and lineage documentation. Collaborates with analytics and business teams, troubleshoots data issues, establishes engineering standards, and mentors junior engineers. The role also requires Azure Data Factory experience and expertise handling structured and semi-structured data.
Summary Generated by Built In
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
Skills Required
- 6+ years of experience in data engineering, cloud data warehousing, and analytics engineering
- Strong expertise in Snowflake
- Strong expertise in dbt Data Build Tool
- Strong SQL skills
- Experience developing ETL and ELT pipelines
- Experience with Azure cloud platform
- Experience designing and developing scalable data warehouse solutions
- Experience developing dbt models, macros, tests, snapshots, and documentation
- Experience implementing Star Schema and Snowflake Schema dimensional models
- Experience optimizing Snowflake performance through query tuning, clustering, partitioning, and warehouse sizing
- Experience implementing data quality frameworks, monitoring, and automated dbt validations
- Experience developing CI/CD pipelines for dbt deployments and automating data workflows
- Understanding of data governance, security, metadata management, and data lineage
- Experience handling structured and semi-structured data, including JSON, XML, Parquet, and Avro
- Experience with Azure Data Factory
- Knowledge of HRMS or Finance data
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Anblicks is a Cloud Data Analytics Company based out of Dallas, TX, with offices in USA, India, and Australia. Since 2004, Anblicks has been helping customers by bringing value to their data and implementing modern data architecture and advanced analytics solutions in the cloud.
.jpeg)
