Snowflake/DBT Engineer — AWS Data Pipelines & CI/CD

BlackCube Labs; New York (NY); On-site; USD 120,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401(k) Plan

Paid holidays

Parental leave

PTO

Job summary

Fractal Analytics is hiring a Snowflake/DBT Developer with AWS focus to design and implement robust data pipelines, optimize Snowflake workloads, and ensure data governance across cloud-based platforms.

The role emphasizes collaboration with data analysts, data engineers, and business stakeholders to deliver scalable and secure data solutions using Snowflake, DBT, and AWS services. Experience with CI/CD, IaC, and data modeling is essential.

Qualifications

• Ability to write complex SQL queries, stored procedures, and user-defined functions.
• Skills in optimizing SQL queries for performance and efficiency.
• Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran or similar tools for real-time and periodic data processing.
• Proficiency in transforming data within Snowflake using SQL, with Python being a plus.
• Expertise in AWS data services relevant to Snowflake workloads (e.g., S3 data lake integration, IAM roles, KMS encryption, CloudWatch monitoring).
• Experience designing and implementing AWS-based data pipelines and integrations with Snowflake (data ingestion from S3, Glue, and other AWS services; orchestration patterns).
• Familiarity with Azure DevOps CI/CD pipelines for data assets, including build, test, and release automation, and IaC tooling (e.g., ARM templates, Terraform) as part of the deployment workflow.
• Strong understanding of data security, compliance and governance.
• Experience with DBT for database object modeling and provisioning.
• Experience in version control tools, particularly Azure DevOps.
• Good documentation and coaching practice.

Responsibilities

• In-depth knowledge of Snowflake’s data warehousing capabilities.
• Implement robust CI/CD processes for data assets and AWS services using Azure DevOps pipelines, infrastructure as code, and artifact/version control; manage promotion from development to production.
• Understanding of Snowflake’s virtual warehouse architecture and how to optimize performance and cost.
• Proficiency in using Snowflake’s data sharing and integration features for seamless collaboration.
• Develop and optimize complex SQL scripts, stored procedures, and data transformations.
• Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions.
• Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
• Integrate data from various sources including APIs, flat files, relational databases, and cloud services.
• Ensure data quality, data governance, and compliance standards are met.
• Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and associated tools.
• Participate in code reviews, testing, and deployment of data solutions in development and production environments.

Skills

Snowflake

DBT

SQL queries

Python

AWS

Azure DevOps

Data modeling

Data governance

Tools

Snowpipe

AWS Glue

Fivetran

Terraform

ARM templates

OpenFlow

Job description

Fractal Analytics is hiring a Snowflake/DBT Developer with AWS focus to design and implement robust data pipelines, optimize Snowflake workloads, and ensure data governance across cloud-based platforms.

The role emphasizes collaboration with data analysts, data engineers, and business stakeholders to deliver scalable and secure data solutions using Snowflake, DBT, and AWS services. Experience with CI/CD, IaC, and data modeling is essential.