Envision Technology Solutions
Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Engineer specializing in Snowflake, requiring 5 years of data engineering experience, including 2 years with Snowflake. Contract length is unspecified, with on-site work in Houston, New York, or Wisconsin. Pay rate is not disclosed.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
July 23, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York, United States
-
🧠 - Skills detailed
#Azure #SnowPipe #Python #Snowflake #AWS S3 (Amazon Simple Storage Service) #Data Modeling #Data Pipeline #Data Governance #Scripting #Cloud #Data Vault #BI (Business Intelligence) #Version Control #PySpark #Microsoft Power BI #Deployment #ADF (Azure Data Factory) #Agile #Data Ingestion #Apache Iceberg #Data Science #Spark (Apache Spark) #Vault #Data Engineering #Tableau #"ETL (Extract #Transform #Load)" #AWS (Amazon Web Services) #Databricks #SQL (Structured Query Language) #JSON (JavaScript Object Notation) #Scala #S3 (Amazon Simple Storage Service) #DevOps #Kafka (Apache Kafka) #Lambda (AWS Lambda) #dbt (data build tool) #Complex Queries #Azure DevOps #Batch #Compliance #Datasets #Delta Lake #ADLS (Azure Data Lake Storage) #Apache Spark #API (Application Programming Interface) #Data Extraction #Data Quality #Informatica
Role description
Snowflake Data Engineer
Location : Houston TX , New York and Wisconsin onsite
Contract
Design develop test and deploy data pipelines that ingest transform and serve data across the Sirius enterprise data platform Working under the Data Tech Leads direction they implement the reusable ingestion framework canonical data models and analytics ready datasets that power marketing attribution claims analytics executive dashboards and AIML workloads
Key Responsibilities
• Build and maintain ETLELT pipelines using Snowflake services covering data extraction from multiple sources Marketing Platforms Partner Distribution Feeds PAS Claims Systems
• Implement the reusable ingestion framework with API connectors batch connectors and standardized data quality checks
• Develop and optimize Snowflake objects tables views stored procedures Snow pipe Streams Tasks Dynamic Tables
• Implement schema on write data models aligned to the canonical data domain sequence Marketing Distribution Claims Pricing
• Build data pipelines in Parquet format with Apache Iceberg support for lake house integration
• Develop Databricks notebooks and Spark jobs for advanced analytics and data science workbench use cases where Databricks is in scope
• Integrate data from diverse sources
• Implement data quality cleansing validation and enrichment logic within pipelines
• Collaborate with the Data Governance Liaison on lineage catalog registration and compliance tagging Informatica
• Write unit tests and partner with the Unit Test Engineer to maintain test coverage meeting ART quality gates
• Follow CICD practices for pipeline deployment coordinate with the shared DevOps Engineer
Must Have Skills Qualifications
• 5 years of handson data engineering experience with at least 2 years on Snowflake
• Strong SQL skills complex queries performance tuning Snowflake specific SQL
• Proficiency with Python or Scala for data transformation and pipeline scripting
• Experience with cloud platforms Azure ADF ADLS Azure DevOps andor AWS S3 Glue Lambda
• Understanding of data modeling star schema snowflake schema data vault canonical models
• Familiarity with Parquet Avro JSON CSV data formats and Apache Iceberg table format
• Experience working in AgileSAFe teams with 2week sprint cadence
• Good understanding of data quality principles and data testing frameworks
Good to Have Preferred
• Experience building ETLELT pipelines batch and streaming using tools like Vincilium Informatica dbt or equivalent
• Handson Databricks Apache Spark experience PySpark Delta Lake
• Experience with Snowpipe Streaming Kafka or eventdriven data ingestion patterns
• Familiarity with Power BI Tableau and building datasets and views for BI consumption
• Insurance or financial services data experience claims policy distribution marketing data
• SnowPro Core or SnowPro Advanced Data Engineer certification
• Experience with Gitbased version control and CICD for data pipelines"
Thanks,
Satender Kumar (Sam)
Team Lead
Envision Technology Solutions
Email: satender.kumar@envisiontechsol.com
Snowflake Data Engineer
Location : Houston TX , New York and Wisconsin onsite
Contract
Design develop test and deploy data pipelines that ingest transform and serve data across the Sirius enterprise data platform Working under the Data Tech Leads direction they implement the reusable ingestion framework canonical data models and analytics ready datasets that power marketing attribution claims analytics executive dashboards and AIML workloads
Key Responsibilities
• Build and maintain ETLELT pipelines using Snowflake services covering data extraction from multiple sources Marketing Platforms Partner Distribution Feeds PAS Claims Systems
• Implement the reusable ingestion framework with API connectors batch connectors and standardized data quality checks
• Develop and optimize Snowflake objects tables views stored procedures Snow pipe Streams Tasks Dynamic Tables
• Implement schema on write data models aligned to the canonical data domain sequence Marketing Distribution Claims Pricing
• Build data pipelines in Parquet format with Apache Iceberg support for lake house integration
• Develop Databricks notebooks and Spark jobs for advanced analytics and data science workbench use cases where Databricks is in scope
• Integrate data from diverse sources
• Implement data quality cleansing validation and enrichment logic within pipelines
• Collaborate with the Data Governance Liaison on lineage catalog registration and compliance tagging Informatica
• Write unit tests and partner with the Unit Test Engineer to maintain test coverage meeting ART quality gates
• Follow CICD practices for pipeline deployment coordinate with the shared DevOps Engineer
Must Have Skills Qualifications
• 5 years of handson data engineering experience with at least 2 years on Snowflake
• Strong SQL skills complex queries performance tuning Snowflake specific SQL
• Proficiency with Python or Scala for data transformation and pipeline scripting
• Experience with cloud platforms Azure ADF ADLS Azure DevOps andor AWS S3 Glue Lambda
• Understanding of data modeling star schema snowflake schema data vault canonical models
• Familiarity with Parquet Avro JSON CSV data formats and Apache Iceberg table format
• Experience working in AgileSAFe teams with 2week sprint cadence
• Good understanding of data quality principles and data testing frameworks
Good to Have Preferred
• Experience building ETLELT pipelines batch and streaming using tools like Vincilium Informatica dbt or equivalent
• Handson Databricks Apache Spark experience PySpark Delta Lake
• Experience with Snowpipe Streaming Kafka or eventdriven data ingestion patterns
• Familiarity with Power BI Tableau and building datasets and views for BI consumption
• Insurance or financial services data experience claims policy distribution marketing data
• SnowPro Core or SnowPro Advanced Data Engineer certification
• Experience with Gitbased version control and CICD for data pipelines"
Thanks,
Satender Kumar (Sam)
Team Lead
Envision Technology Solutions
Email: satender.kumar@envisiontechsol.com
