[Remote] Snowflake Data Engineer
Note: The job is a remote job and is open to candidates in USA. Fractal is seeking an experienced Snowflake Data Engineer to design and deliver scalable, secure, and high-quality data solutions with a strong focus on AWS-based architectures. The role involves Snowflake development, DBT modeling, AWS data pipelines, CI/CD automation through Azure DevOps, data integration, governance, and performance optimization.
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
- In-depth knowledge of Snowflake's data warehousing capabilities
- 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
- 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
- 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
Benefits
- Eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents.
- Eligible for benefits on the first day of employment with the Company.
- Eligible 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.
- Eligible for a discretionary bonus for the current performance period.
Company Overview
Company H1B Sponsorship