Brent Stenman
IT Cloud Data Engineer @Advocate Aurora Health
Signup · Get unlimited contacts
WORK HISTORY
IT Cloud Data Engineer @Advocate Aurora Health
Maintained and developed DBT projects & pipelines for ingesting tables from a raw data zone to dev, testing and production in SnowflakeDeveloped python scripts to update YAML & model files to maintain the pipelines and lineageConnected Python to two separate databases (snowflake and Epic’s sql server) to collect table counts and other metadata to check data quality from our HVR + DBT pipeline. Worked in Azure Repos for the CI/CD processManage FiveTran/HVR full load and incremental pipelines for the EL portion on the data-pipeline
EDUCATION
DePaul University Jarvis College of Computing and Digital Media
Master of Science in Information Systems
DePaul University
Bachelor of Science in Business , Concentration Finance
SKILLS
ABOUT BRENT STENMAN
Senior Data Engineer and Cloud Architect with over 6 years of experience designing scalable data ecosystems. I specialize in the Modern Data Stack (Snowflake, dbt, Airflow) and have a proven track record of leading complex migrations and managing high-velocity data streams for Fortune 1 Global Tech and major Healthcare systems.Currently, I lead data engineering initiatives in the HealthTech space, where I architected the end-to-end ingestion pipelines moving Epic Systems data into Snowflake using HVR and dbt. My focus is on building \"self-healing\" infrastructures—automating data quality checks, CI/CD deployment in Azure, and ensuring strict PHI/PII compliance without sacrificing speed.Previously, I designed the cloud infrastructure for a massive SQL Server-to-Azure migration at SeaSpine (now Orthofix) and managed 24/7 real-time streaming data for Walmart’s self-checkout systems using Kafka and GCP BigQuery.I bridge the gap between complex engineering and business value. With a Master’s in Information Systems and a background in Finance, I build pipelines that don’t just move data, but drive decision-making.Core Technical Stack:• Cloud & Warehousing: Snowflake (Data Cloud), Azure (ADF, DevOps), GCP (BigQuery), AWS.• Transformation & Orchestration: dbt (Data Build Tool), Apache Airflow, Spark (PySpark/Scala).• Streaming & Ingestion: Apache Kafka, HVR (High Volume Replication), Fivetran.• Languages: Python, SQL, Scala, Node.js.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.