MTG Data Enrichment
Google Colab / APIs / Python / Data Enrichment
Data enrichment pipeline for Magic: The Gathering card collection data.
View CodeSystem Online...
Nathanael Dunning
Data Engineer
Specializing in modern data platforms using the Apache Stack & Azure. Transforming enterprise data into actionable intelligence.
01. Profile Description
Based in Ft. Worth, TX. I am a Data Engineer with a proven track record in designing and maintaining enterprise-scale data pipelines. Currently driving data innovation at McLane Company, processing billions of records to support $40M+ in sales operations.
My passion lies in Lakehouse Architecture, Real-time Analytics, and building resilient infrastructure that empowers business decisions. When I'm not engineering data pipelines, I'm optimizing my Home Lab (Linux VMs, Docker, game servers, Jellyfin, self-hosted AI/web applications), running D&D campaigns, writing fantasy narratives, managing investments, or traveling.
02. Experience Logs
Data Engineer
McLane Company, Inc. Remote / Temple, TX July 2023 – Jan 2026- Designed end-to-end Azure Data Factory pipelines ingesting data from Oracle EBS & DB2 into Microsoft Fabric Lakehouses using Spark.
- Supported datasets ranging from small tables to 6 billion+ records, managing daily and hourly ingestion schedules.
- Implemented watermark-based incremental loading and upsert logic for efficient reprocessing.
- Architected raw, curated, and semantic layers using Medallion Architecture, star schema, and snowflake schema patterns with dimensional modeling best practices.
- Led data engineering efforts as primary technical owner for enterprise tradeshow applications supporting $40M+ in sales across 110K+ store locations and 80 distribution centers.
- Awarded the 212 Award for Innovation for critical data engineering contributions.
- Implemented Type 1 and Type 2 slowly changing dimensions to track historical changes in master data tables.
- Designed partitioning strategies using monthly and yearly keys to optimize query performance on finance datasets.
- Provided production on-call support in coordination with RunOps teams using monitoring alerts, logs, and dashboards.
- Advocated for and contributed to adoption of Git-based version control and CI/CD practices using Azure DevOps, improving deployment safety and code review processes.
Programmer / Analyst
McLane Company, Inc. Remote / Temple, TX May 2022 – July 2023- Developed data-driven applications using Azure Synapse, Databricks, SQL, and Python.
- Transitioned legacy reporting workflows to cloud-based analytics platforms.
- Partnered with stakeholders to deliver solutions for finance and operational reporting.
- Contributed to development of dimensional data models supporting finance and operational reporting requirements.
Data Science & Analytics Intern
McLane Company, Inc. Feb 2020 – May 2022- Supported Azure-based analytics and ML initiatives using SQL and Python.
- Assisted with data ingestion and validation for enterprise-scale datasets.
Customer Service Representative
Papa John's May 2018 – Aug 201903. Technical Modules
🏗️ Data Platforms
- Microsoft Fabric
- Azure Data Factory
- Apache Spark
- Databricks
- Azure Synapse
- Power BI
💻 Programming
- Python (pandas, PySpark, requests, scikit-learn, XGBoost)
- SQL (Complex Joins, CTEs, Window Functions)
- Spark SQL
- Oracle SQL
- IBM DB2 SQL
- Microsoft SQL
☁️ Infrastructure
- Microsoft Azure (Primary)
- AWS / GCP (Familiar)
- Docker
- Linux
⚙️ Engineering
- Lakehouse Architecture
- Medallion Architecture
- Dimensional Modeling (Star Schema, Snowflake Schema, SCD)
- Incremental Loading
- Watermark Based Data Pipelines
- Partitioning Strategies
🛡️ Data Quality
- Schema Validation
- Row Count Reconciliation
- Summation Reconciliation
- Null Checks / Duplicates
- Data Profiling
- Manual QA Workflows
🚀 DevOps
- Azure DevOps (CI/CD)
- Git / Version Control
- Jira
04. Code Repos
05. Education Database
BBA, Business Computer Information Systems
University of Mary Hardin-Baylor 2022High School
Harvest Christian Academy 201806. Leadership Protocols
YCT Foundation - Vice President
Dec 2022 – Present
Managed donor relations and ops for $70k-$100k budget. Restructured board governance for compliance. Generated six figures in donations for student leadership conference.
UMHB Student Gov - Vice President
Aug 2020 – May 2022
Served as Vice President of the Student Government Association.
UMHB Investment Club - President
Aug 2020 – May 2022
Led the university investment club operations.
07. Personal Systems
Home Lab Infrastructure
- Linux VMs for development and testing
- Docker containerization for application deployment
- Game servers for multiplayer hosting (including D&D virtual tabletop platforms)
- Jellyfin media server
- Self-hosted AI applications and web services
- Home Assistant for automation (YAML-based configuration)
- Development tools and experimental platforms
Creative Projects
- Tabletop RPG Storytelling: Active D&D player and campaign notetaker, crafting extensively detailed character backstories (20+ pages) focused on narrative continuity, character relationships, and world-building integration
- Creative Writing: Fantasy narrative development with emphasis on complex character relationships and multi-generational storytelling
Web Development
- Built and maintain npdfw.com using AI-assisted development workflows for rapid prototyping and iteration
08. Establish Contact
Get In Touch
Open to Remote & Relocation opportunities.