Analytics & Data Engineer - Snowflake + Fabric OLAP

Thecomplianceengine

Lisle (IL)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A technology compliance company in Lisle, IL, seeks an experienced Analytics & Data Engineer to manage end-to-end data processes. The candidate will architect and maintain data pipelines from Zoho to Snowflake, delivering insights through Microsoft Fabric and Power BI. Required skills include advanced Snowflake knowledge, SQL, and Python programming. This on-site position also emphasizes data governance and performance tuning. Ideal for candidates with 2-3 years in data engineering, aiming to enhance business intelligence operations.

Qualifications

2-3 years of data engineering/analytics experience required.
Experience implementing Medallion Architecture in a cloud environment.

Responsibilities

Design and manage ETL/ELT pipelines to extract data from Zoho APIs and load into Snowflake.
Architect scalable data structures in Snowflake using Star Schema or Data Vault methods.
Integrate Snowflake with Microsoft Fabric to create a unified data layer.
Build and maintain semantic models within Fabric/Power BI for accurate reporting.
Monitor and optimize Snowflake compute usage and Power BI DAX queries.
Implement security protocols for data governance.