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 Skills Required :
  
  

• Snowflake
• DBT (Data Build Tool)
• SQL
• Data Warehousing Concepts
• ELT/ETL Development
• Data Engineering & Cloud
  
  

• Cloud Platforms (AWS/Azure/GCP)
• Data Pipelines
• Workflow Orchestration Tools
• Data Modeling
• Performance Tuning
  
  

• Airflow
• Python
• Git
• CI/CD pipelines
  
  

• Dimensional Modeling
• Data Lake & Data Warehouse Architectures
• Query Optimization
• Data Governance
• Data Quality Frameworks
  
  

• 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 Qualifications :
• Bachelors degree in Computer Science, Information Technology, Data Engineering, or related field.
• Snowflake certifications or cloud certifications are Required :
• 10-15 years of experience in Data Engineering, Data Warehousing, Snowflake Development, or Analytics Engineering roles.