Newlineinfo Corp - IT Services and IT Consulting
Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Engineer with 10+ years of experience in ETL/ELT pipelines and strong Snowflake expertise. It requires advanced SQL skills, cloud platform knowledge (Azure preferred), and is 100% onsite. Contract length and pay rate are unspecified.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
August 11, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Chicago, IL
-
🧠 - Skills detailed
#Security #SnowPipe #Databricks #Fivetran #ADF (Azure Data Factory) #Data Lake #Snowflake #BI (Business Intelligence) #Azure #Databases #Data Reconciliation #dbt (data build tool) #MDM (Master Data Management) #Data Modeling #Migration #SQL (Structured Query Language) #Data Engineering #Cloud #AWS (Amazon Web Services) #"ETL (Extract #Transform #Load)"
Role description
Required Qualifications
• 10+ years of hands-on Data Engineering experience - building, operating, and troubleshooting production ETL/ELT pipelines (not just BI/reporting development).
• Strong, demonstrable Snowflake experience - data modeling, warehouse sizing/performance tuning, RBAC/security, Streams/Tasks/Snowpipe, and cost optimization. Hands on Snowflake implementations or migrations.
• Build and maintain Snowflake objects (warehouses, databases, schemas, roles, RBAC), and implement Streams, Tasks, and Snowpipe for near-real-time ingestion.
• Advanced SQL skills - complex joins, window functions, query optimization, and data reconciliation across heterogeneous sources.
• Experience with cloud data platforms (Azure preferred) and modern ELT tooling (dbt, Fivetran, ADF, or equivalent) also strong knowledge of AWS environment.
• Write advanced, performant SQL for data transformation, validation, and reconciliation across source and target systems.
• Collaborate with the broader Data Platforms team on integration points with the Enterprise Data Lake (Databricks Bronze/Silver/Gold, Unity Catalog/ABAC), MDM, and Elastic Search environments.
Looking only in local area since 100% onsite.
Required Qualifications
• 10+ years of hands-on Data Engineering experience - building, operating, and troubleshooting production ETL/ELT pipelines (not just BI/reporting development).
• Strong, demonstrable Snowflake experience - data modeling, warehouse sizing/performance tuning, RBAC/security, Streams/Tasks/Snowpipe, and cost optimization. Hands on Snowflake implementations or migrations.
• Build and maintain Snowflake objects (warehouses, databases, schemas, roles, RBAC), and implement Streams, Tasks, and Snowpipe for near-real-time ingestion.
• Advanced SQL skills - complex joins, window functions, query optimization, and data reconciliation across heterogeneous sources.
• Experience with cloud data platforms (Azure preferred) and modern ELT tooling (dbt, Fivetran, ADF, or equivalent) also strong knowledge of AWS environment.
• Write advanced, performant SQL for data transformation, validation, and reconciliation across source and target systems.
• Collaborate with the broader Data Platforms team on integration points with the Enterprise Data Lake (Databricks Bronze/Silver/Gold, Unity Catalog/ABAC), MDM, and Elastic Search environments.
Looking only in local area since 100% onsite.
