Snowflake DBT Data Engineer - AWS Focus

Fractal Analytics Inc.; 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

Paid time off

Job summary

Fractal Analytics is seeking a Snowflake/DBT Developer with AWS focus to design and implement data pipelines using Snowflake, DBT, and AWS services. You will collaborate with analysts and engineers to deliver scalable, secure data solutions with CI/CD in Azure DevOps.

The role emphasizes data warehousing, ETL/ELT, data governance, and performance tuning, with a strong emphasis on cost optimization and compliant data models.

Qualifications

• Ability to write complex SQL queries, stored procedures, and user-defined functions.
• Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, Fivetran or similar.
• Proficiency in transforming data within Snowflake using SQL, with Python a plus.

Responsibilities

• Implement CI/CD processes for data assets and AWS services using Azure DevOps pipelines and IaC.
• Develop and optimize SQL scripts, stored procedures, and data transformations.
• Design and maintain data models for data warehousing, including star/snowflake schemas.

Skills

SQL

Stored procedures

User-defined functions

Data modeling

Data warehousing

CI/CD for data pipelines

Data governance

Tools

Snowflake

AWS

DBT

Azure DevOps

Terraform

IAM/KMS

Job description

Fractal Analytics is seeking a Snowflake/DBT Developer with AWS focus to design and implement data pipelines using Snowflake, DBT, and AWS services. You will collaborate with analysts and engineers to deliver scalable, secure data solutions with CI/CD in Azure DevOps.

The role emphasizes data warehousing, ETL/ELT, data governance, and performance tuning, with a strong emphasis on cost optimization and compliant data models.