Note: The job is a remote job and is open to candidates in USA. Fractal Analytics is a strategic AI partner to Fortune 500 companies focused on powering enterprise decisions through intelligence. The Snowflake/DBT Developer will design and deliver scalable AWS-based data solutions using Snowflake, DBT, SQL, and Azure DevOps CI/CD, while collaborating with analysts, architects, engineers, and business stakeholders.
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
- • 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
- Python being a plus
Benefits
- Health plans for full-time employees or hourly employees working more than 30 hours per week, in accordance with the plan documents
- Dental plans for full-time employees or hourly employees working more than 30 hours per week, in accordance with the plan documents
- Vision plans for full-time employees or hourly employees working more than 30 hours per week, in accordance with the plan documents
- Life insurance plans for full-time employees or hourly employees working more than 30 hours per week, in accordance with the plan documents
- Disability plans for full-time employees or hourly employees working more than 30 hours per week, in accordance with the plan documents
- Eligibility for benefits on the first day of employment with the Company
- Eligibility to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms
- 11 paid holidays
- 12 weeks of Parental Leave
- “Free time” PTO policy, allowing you the flexibility to take time needed for either sick time or vacation
- You may be eligible for a discretionary bonus for the current performance period
Company Overview