Jobs → Data & Analytics → Snowflake Data Engineer

Snowflake Data Engineer

Preetam Sanil - Managing DirectorUnited StatesMIDPosted 50m ago
SnowflakeETLAPIBatch ProcessingSQLPythonScalaAzure ADFADLSAzure DevOpsAWS S3AWS GlueAWS LambdaParquetAvroJSONCSVApache IcebergDatabricksSparkCI/CDDevOpsData ModelingData QualityAgileSafe
About the Role We are looking for a Data Engineer to join our team and shape the future of data engineering in marketing, distribution, and claims. This role involves building and maintaining data pipelines in Snowflake and developing schema-on-write models aligned with canonical domains. Key Responsibilities • Build and maintain ETL/ELT pipelines in Snowflake for diverse data sources. • Implement reusable ingestion framework with API connectors, batch pipelines, and quality checks. • Design and optimize Snowflake objects: tables, views, stored procedures, Snowpipe, streams, tasks, dynamic tables. • Develop schema-on-write models aligned with canonical domains: Marketing, Distribution, Claims, Pricing, UW. • Build Parquet-based lakehouse pipelines with Apache Iceberg support. • Create Databricks notebooks and Spark jobs for advanced analytics and data science. • Integrate data from multiple platforms and ensure data quality through cleansing, validation, and enrichment. • Work with Governance Liaison on lineage, catalog registration, and compliance tagging. • Write unit tests and collaborate with QA to meet ART standards. • Follow CI/CD practices and coordinate with DevOps for pipeline deployment. Requirements • 5+ years of data engineering experience, with at least 2 years on Snowflake. • Expertise in SQL, complex queries, performance tuning, and Snowflake-specific SQL. • Proficiency in Python or Scala for data transformation and scripting. • Experience with Azure ADF, ADLS, Azure DevOps, AWS S3, Glue, or Lambda. • Strong understanding of data modeling: star schema, snowflake schema, data vault, canonical models. • Familiarity with Parquet, Avro, JSON, CSV, and Apache Iceberg table formats. • Proven ability to work in Agile Safe teams with 2-week sprints. • In-depth knowledge of data quality principles and testing frameworks.

Similar projects

Business Analyst
Kim Phượng Career Connection · BA, AI tool
Databricks Developer
Lucy Deepika Velaidum · Databricks, AWS, PySpark
Telecom Data Scientist
Deepak Yadav · Python, PySpark, Advanced SQL
Early · 0 applied1 of 6,212 projects

Apply with AI cover letter

AI writes a personalized application in 19 seconds. Just upload your resume.

No credit card · First application free
© 2026 Freelanly · Terms · Privacy