Zack GregoryTechnical expertise
An architect’s working toolkit.
Explore six disciplines through the decisions, tools and projects where I have used them.
Platform architectureChoose where data lives and how it moves.
Azure Databricks · Delta Lake · Microsoft Fabric · Azure Data Factory
At Vantage, I assessed inherited pipelines and mapped a staged migration to Databricks and Fabric. Retaining source history in Bronze gave the team a basis for replay and reconciliation.
Data engineeringMake incremental loads repeatable.
PySpark · Spark SQL · Auto Loader · Delta Live Tables
I built and reviewed incremental ingestion and transformation pipelines. Reusable merge and Type 2 patterns preserved changes to business entities over time.
Modeling & governanceMake a measure mean the same thing across systems.
Dimensional modeling · SCD Type 2 · Unity Catalog · Source-to-target mapping
At Vantage, 18 conformed Silver tables and cross-source master-data bridges connected local ERP identifiers to shared entities. Finance, Supply Chain and Commercial helped define ownership.
Business intelligenceGive analysts a dependable place to start.
Power BI · Semantic models · Tableau migration · Metric governance
At ClubCorp, I rebuilt the semantic and reporting layer for operations and marketing. At Microsoft, I led BI platform delivery and standardized inconsistent sales and marketing metrics.
Consulting & leadershipTurn a discovery conversation into an executable scope.
Discovery · Architecture workshops · Statements of work · Team leadership
At Affirma I owned pre-sales and SOW development across Amazon, Microsoft and Meta engagements. At Meta I managed the 21-person data pipeline engineering team supporting smart-glasses programs.
Applied AI researchGive a generated explanation a traceable basis.
Independent exploration · Reconciliation · Retrieval · Human review
NorthTrace explores how an assistant could investigate differences between reports. The interactive portfolio example uses deterministic rules and synthetic records. In the local prototype, a model running in LM Studio summarized verified DuckDB results. Model evaluation is an area of ongoing study.