Factspan - Snowflake DBT Engineer - Data Warehousing

Description :

We are looking for a highly skilled Snowflake DBT Engineer to design, develop, and optimize cloud-based data transformation and analytics solutions. The ideal candidate will possess strong expertise in Snowflake, DBT (Data Build Tool), SQL, data warehousing, and modern ELT/ETL pipelines.

The candidate will work closely with data engineers, analysts, business teams, and architects to build scalable and high-performance data models and analytics platforms.

Key Responsibilities :

- Design, develop, and maintain scalable data transformation pipelines using DBT and Snowflake.

- Build and optimize data models, data marts, and warehouse structures for analytics and reporting.

- Develop ELT/ETL workflows and automate data processing pipelines.

- Collaborate with data engineering and analytics teams to gather business and technical requirements.

- Optimize Snowflake performance, storage, and query efficiency.

- Implement data quality checks, validations, and governance standards.

- Develop reusable DBT models, macros, and documentation.

- Manage data ingestion, transformation, and orchestration processes.

- Monitor and troubleshoot data pipeline issues and implement resolutions.

- Work with cloud-based data ecosystems and modern analytics architectures.

- Ensure adherence to security, compliance, and data management best practices.

- Support CI/CD deployment processes and version control practices.

- Participate in architecture discussions and continuous improvement initiatives.

Technical Skills Required :

Core Skills :

- Snowflake

- DBT (Data Build Tool)

- SQL

- Data Warehousing Concepts

- ELT/ETL Development

- Data Engineering & Cloud

Experience with :

- Cloud Platforms (AWS/Azure/GCP)

- Data Pipelines

- Workflow Orchestration Tools

- Data Modeling

- Performance Tuning

Familiarity with :

- Airflow

- Python

- Git

- CI/CD pipelines

Database & Analytics :

Strong understanding of :

- Dimensional Modeling

- Data Lake & Data Warehouse Architectures

- Query Optimization

- Data Governance

- Data Quality Frameworks

Required Skills :

- Strong analytical and troubleshooting capabilities.

- Excellent communication and collaboration skills.

- Ability to work with large-scale data systems and distributed teams.

- Strong problem-solving and optimization mindset.

- Ability to manage multiple priorities in fast-paced environments.

Preferred Qualifications :

- Bachelors degree in Computer Science, Information Technology, Data Engineering, or related field.

- Snowflake certifications or cloud certifications are preferred.

Experience Required :

- 10-15 years of experience in Data Engineering, Data Warehousing, Snowflake Development, or Analytics Engineering roles.