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.