Data Engineer & BI Consultant

Eric Ziola

Cross-platform data engineering, business intelligence, and systems integration professional with 15+ years helping fast-moving organizations optimize their business systems into unified, actionable intelligence.

Portrait of Eric Ziola

Summary

Skills

Azure Data Engineering Microsoft Fabric (Lakehouse/Warehouse) Snowflake Databricks dbt Fivetran Power BI / DAX SQL / T-SQL / Spark SQL PySpark Python ETL / ELT SSIS / SSRS / SSAS Power Query M API Development Forecasting & Time Series ERP (SAP, Infor M3) S&OP / IBP Data Modeling

Languages

  • English (Native)
  • Spanish (Professional Working)

Experience

Senior Data Engineer / BI Developer, Renovo Home Partners

Apr 2025 – Nov 2025

  • Designed and built BI solutions for executive, sales, and marketing teams; integrated multiple Salesforce instances across North America.
  • Used Fivetran, dbt, and Snowflake in a medallion architecture feeding Power BI and Marketing Cloud Intelligence.
  • Delivered refreshable, semantic Power BI models driven by executive requirements.

Senior Data Warehouse, Integration, and BI Developer, System Two Insights

Aug 2024 – Apr 2025

  • Built end-to-end enterprise BI solutions for mid-to-large firms using the full Microsoft BI stack (Fabric, Power BI, ADF, SSAS, SSRS).
  • Gathered requirements and delivered custom integrations, semantic models, and KPIs to delight clients.

BI Developer II, Cencora / AmerisourceBergen

Jul 2023 – Aug 2024

  • Led migration of data warehouse from Microsoft Synapse to Databricks; built medallion architecture pipelines.
  • Delivered critical reporting from Databricks to Power BI using T-SQL, Spark SQL, PySpark, and notebooks.
  • Created executive and sales reporting in Power BI and SSRS.

BI Analytics & Forecasting Manager, Otter Products

May 2016 – Jan 2023

  • Delivered end-to-end BI solutions enabling exec decisions and financially informed ops investments.
  • Designed custom integrations in Azure, Power BI, and Data Factory; built ETL across finance and operations systems.
  • Subject matter expert for Logility S&OP implementation; deep experience across Azure, Power BI, SQL, SSIS/SSRS/SSAS.

Senior Business Intelligence Analyst, Otter Products

Oct 2013 – May 2016

  • Built automated cloud analytics for finance, supply chain, demand planning, and inventory management using SSIS/SSRS/SSAS, Power BI, and Azure.
  • Developed time-series and regression forecasting models improving global forecast accuracy to ~80%.
  • Worked across on-prem and cloud ETL; deep ERP experience with SAP and Infor M3.

Education

University of Northern Colorado

MBA, Business Administration & Management · Jun 2021

Colorado State University

B.S. Business Administration, Investment Analysis & Corporate Finance · May 2013

Front Range Community College

Associate of Arts, Business Prerequisites / Spanish · May 2010

Southeast Community College

A.A.S. Computer Systems, Networking & Electronics Engineering · Dec 2000

Recognition