Snowflake_DBT Developers

About the role

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

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.

Requirements

• 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

A reasonable estimate of the hourly rate range, depending on experience, is $120,000 - $140,000. In addition, you may be eligible for a discretionary bonus for the current performance period.

Benefits

• Health, dental, vision, life insurance, and disability plans (eligible on first day of employment).
• Company 401(k) Plan (eligible after 30 days).
• 11 paid holidays.
• 12 weeks of Parental Leave.
• "Free time" PTO policy allowing flexibility for sick time or vacation.