Data Engineer

Newlineinfo Corp - IT Services and IT Consulting; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Newlineinfo Corp - IT Services and IT Consulting seeks a senior Data Engineer for 100% onsite work in the Chicago area. You will design, implement, and optimize production ETL/ELT pipelines and ensure data quality across Snowflake and enterprise data lakes.

You will work with advanced SQL, RBAC/security, and near-real-time data ingestion using Streams/Tasks/Snowpipe, while collaborating with the Data Platforms team on Databricks and Unity Catalog integration.

Qualifications

• 10+ years of hands-on Data Engineering experience.
• Strong Snowflake experience with data modeling and performance tuning.
• Advanced SQL skills for complex transformations and data reconciliation.
• Experience with cloud data platforms (Azure preferred) and ELT tooling (dbt, Fivetran, ADF) and AWS knowledge.
• Write performant SQL for data transformation and validation across sources.
• Collaborate on integration with Enterprise Data Lake, Unity Catalog/ABAC, MDM, and Elastic Search environments.

Skills

Data Engineering

Snowflake

Advanced SQL

Cloud Platforms

dbt

Fivetran

ADF

RBAC/Security

ETL/ELT Pipelines

Databricks

Unity Catalog

Elastic Search

Tools

Databricks

Unity Catalog/ABAC

Elastic Search

Job description

• 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.