Snowflake_DBT Developers

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

It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business. Data Engineer - Snowflake/DBT Fractal Analytics is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite empowers imagination with intelligence. And that it will be such Fractalites that will continue to build the company for the next 100 years. Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Please Note: We are not sponsoring at this time.

Snowflake/DBT Developer with AWS Focus Role Overview

We are seeking an experienced Snowflake engineer with a strong emphasis on AWS-based data architectures. This role combines Snowflake expertise with AWS services, DBT modeling, and a robust CI/CD approach using Azure DevOps. You will collaborate with data analysts, data engineers, data architects, and business stakeholders to deliver scalable, secure, and high-quality solution.

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.

Required knowledge

• 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.

Pay:

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the hourly rate range, depending experience, is $120,000 - $140,000. In addition, you may be eligible for a discretionary bonus for the current performance period.

Benefits:

• As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time.
• You will be eligible for benefits on the first day of employment with the Company.
• In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms.
• The Company provides for 11 paid holidays and 12 weeks of Parental Leave.
• We also follow a "free time" PTO policy, allowing you the flexibility to take time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

At Fractal, towards our goal of "powering every human decision in the enterprise", our partnerships and alliances help in creating and delivering a compelling suite of solutions to unlock value. We partner with companies from around the globe, leaders in their respective fields. With Fractal's expertise in artificial intelligence, design, engineering, and digital transformation, combined with the data, technology, and software platforms from our partners, we create cutting-edge solutions to problems in the business world. We understand how critical and timely decision triggers, and information, empower our clients to create, unlock, deliver, and realize value. Together with our partners, our goal is to serve each client in their end-to-end data-to-decision journey.