Job Title: Azure Snowflake Data Engineer
Location: Boston MA HYBDID (4x per week Onsite)
Duration: 6-12 Months Contract W2/C2C
Job Summary: We are looking for a highly skilled Azure Snowflake Data Engineer to join our data engineering team on a contract basis. This role will focus on building robust scalable data solutions using Snowflake and Azure enabling real-time and batch data processing pipelines. The ideal candidate will be well-versed in modern data engineering practices and Snowflake-specific capabilities such as Time Travel Zero Copy Cloning and Snowpipe.
Key Responsibilities:
- Design and implement end-to-end data pipelines using Azure Data Services and Snowflake.
- Develop scalable ELT/ETL frameworks and manage large datasets efficiently.
- Implement Snowpipe for continuous data ingestion and streaming.
- Leverage Time Travel and Zero Copy Cloning features for data versioning recovery and testing.
- Optimize query performance and storage usage within Snowflake.
- Collaborate with data analysts engineers and business stakeholders to understand data requirements.
- Ensure data reliability governance and security across platforms.
- Monitor troubleshoot and maintain existing data workflows and infrastructure.
Required Skills:
- Bachelors or Masters degree in Computer Science Engineering or a related field.
- Must have 8 Years of in data engineering or analytics roles.
- 4-6 years of hands-on experience with Snowflake and Azure data platforms.
- Snowflake: Advanced expertise including Time Travel Zero Copy Cloning and Snowpipe.
- Azure Data Services: Azure Data Factory Azure Synapse Azure Data Lake Azure Blob Storage.
- Strong proficiency in SQL for data manipulation and optimization.
- Experience with Python for scripting and automation.
- Solid understanding of data warehousing data lakes and distributed systems.
Nice to Have:
- Experience with dbt Apache Airflow or similar orchestration tools.
- Familiarity with CI/CD in data engineering workflows.
- Knowledge of Delta Lake or Databricks is a plus.