Analytics & Data Engineer (Snowflake & Microsoft Fabric)

Brycer; Warrenville (IL); On-site; USD 110,000 - 170,000; Full time

Job summary

Brycer is seeking an Analytics & Data Engineer to own the data lifecycle, building pipelines from Zoho through Snowflake to Microsoft Fabric and delivering insights via Power BI. You will architect an high-performance OLAP environment and ensure data accuracy for BI across the stack.

Responsibilities include ETL/ELT design, Snowflake modeling, Fabric integration, and governance with RLS/OLS. On-site role in Lisle, IL with 2–3 years of experience required.

Qualifications

• 2-3 years of data engineering/analytics experience.
• Strong SQL and Python skills for data transformations.
• Experience integrating Zoho APIs and data pipelines.

Responsibilities

• Design and manage end-to-end ETL/ELT pipelines from Zoho to Snowflake.
• Build scalable Snowflake models using Star Schema or Data Vault.
• Integrate Snowflake with Microsoft Fabric to enable unified analytics.
• Develop semantic models in Fabric/Power BI for fast reporting.
• Tune performance to optimize Snowflake and Power BI queries.
• Apply data governance including RLS/OLS security.
• Support sandbox strategy for data-related changes.

Skills

Snowflake

Power BI

SQL

Python

Zoho API integration

REST APIs

Microsoft Fabric

dbt

Apache Airflow

Tools

Fabric Data Factory

Job description

Role Overview

We are looking for a highly skilled Analytics & Data Engineer to own the end-to-end data lifecycle from ingestion to insights. You will be responsible for architecting and maintaining robust data pipelines that move data from Zoho through Snowflake, with final delivery to Microsoft Fabric. Your goal is to build and maintain a high-performance OLAP environment that powers critical business intelligence in Power BI.

Key Responsibilities

• Pipeline Orchestration: Design and manage ETL/ELT pipelines to extract data from Zoho APIs and load it into Snowflake.
• Snowflake Modeling: Architect scalable data structures in Snowflake using Star Schema or Data Vault methodologies to ensure data is optimized for high-speed querying.
• Fabric Integration: Seamlessly integrate Snowflake with Microsoft Fabric (OneLake) to create a unified data layer for downstream analytics.
• OLAP Development: Build and maintain semantic models within Fabric/Power BI, ensuring sub-second report performance and data accuracy.
• Performance Tuning: Monitor and optimize Snowflake compute usage and Power BI DAX queries to minimize latency and costs.
• Data Governance: Implement security protocols, including Row-Level Security (RLS) and Object-Level Security (OLS), across the entire stack.
• Sandbox Strategy: Ensure lower-environment strategy supports change management of data-related needs.

Required Technical Skills

• Data Warehousing: Advanced proficiency in Snowflake (SnowSQL, Snowpipe, Tasks).
• BI Ecosystem: Expertise in Microsoft Fabric and Power BI (Direct Lake mode, DAX, Power Query).
• Programming: Strong SQL and Python skills for complex data transformations.
• API Integration: Experience working with REST APIs, specifically for SaaS platforms like Zoho.
• Modern Data Stack: Familiarity with transformation tools like dbt and orchestration tools like Airflow or Fabric Data Factory.

Preferred Qualifications

• Microsoft Certified: Fabric Analytics Engineer Associate or SnowPro Core Certification.
• Experience implementing MedallionArchitecture (Bronze/Silver/Gold) in a cloud environment.

Additional Information about the role

• On-site 5 days a week in Lisle, IL.
• Requires 2-3 years of data engineering/analytics experience.