Portfolio

Max builds quiet, well-made data systems.

Data analyst on a business analytics team — SQL, Power BI, Python, Microsoft Fabric, DuckDB, dbt — turning messy ERP data into things leadership actually reads.

Location
New York, US
Focus
Analytics engineering · Business Analytics
Fit
Agility, Stakeholder Management
My colors
M
Your photo here
YEP, THAT'S ME
Scroll
Introduction
I like systems just like the way I live — simple on the surface, considered underneath.

I'm a data analyst based in New York, working across eCommerce, wholesale and retail channels. I build the BI dashboards leadership checks every morning, run deep-dives on pricing, inventory and revenue, and keep the numbers trustworthy — validating data, chasing down discrepancies between Microsoft Fabric and the ERP, and automating the repetitive parts with SQL, Python and Power Automate.

I sit between business and engineering: translating vague questions into requirements, modernizing legacy pipelines into a lakehouse architecture, and turning technical findings into narratives executives can act on. My default mode is end-to-end — from the first stakeholder conversation to the model, the pipeline, and the number on the slide.

Skillset
Daily driver

SQL

SQL

Window functions, reconciliation queries, pulling correct numbers from the database.

Daily driver

Power BI · DAX

Power BI · DAX

Executive dashboards, DAX, dual-fact actual-vs-benchmark models.

Production

Python

Python

Data cleaning and validation, small automation scripts.

Production

Microsoft Fabric

Microsoft Fabric

Lakehouse architecture, medallion layers, gold-layer definition.

Production

Power Automate

Power Automate

Email triage flows, AI Builder classification, Planner integration.

Core craft

Dimensional Modeling

Dimensional Modeling

Star schemas designed around the business question, not the table.

Core craft

Cross-team Communication

Cross-team Communication

The bridge between database and stakeholder, convert messy numbers into actionable insights.

Growing

Git · GitHub

Git · GitHub

Version control for SQL, notebooks and pipeline code — push, merge, pull, repeat.

Selected Projects
2026

Email Triage Automation

End-to-end flow for a team distribution list: filters incoming mail, classifies intent with AI Builder, and auto-creates prioritized Planner tasks with full context.

Power Automate · AI Builder · Planner

2026

Quarterly Inventory Turn Analysis

Segment-level turn metrics across product lines and warehouses, delivered to GMs and senior leadership — with the data caveats spelled out, not buried.

SQL · Power BI · Excel

2025

Lakehouse Silver Layer

Cleaning and standardizing ERP data in Microsoft Fabric — the unglamorous layer that decides whether everything downstream can be trusted.

Microsoft Fabric · Python · SQL

2025

Actual-vs-Benchmark Star Schema

A dual-fact dimensional model comparing actuals against benchmarks in one semantic layer — designed so the DAX stays simple and the answers stay fast.

Dimensional modeling · DAX

Contact
Want the longer version? Say hi →
© Max · New York