Data & AI Engineer
Durham, NC shakestzd@gmail.com LinkedIn GitHub
Data & AI engineer. At SunStrong/Sunnova, built the geospatial compliance system that unlocked $250M in Investment Tax Credits across a 500K+ solar asset portfolio, automated $95M in revenue recovery, and delivered quarterly IRS filings for partners managing $1B+ in renewable energy investments. Co-authored a multi-agent clinical research pipeline with Johns Hopkins (in peer review at PRS).
Experience
Senior Data Analyst - Revenue Management
SunStrong Management LLC | Aug 2025 - Sep 2025 | Remote
- Ensured zero disruption to $250M+ in federal tax credit qualifications by leading data systems migration through corporate acquisition of Sunnova Energy’s 200K+ solar asset portfolio
- Delivered quarterly ITC certifications and IRS compliance filings for institutional partners managing $1B+ in renewable energy investments
- Adapted proprietary Energy Community analysis system to evolving IRS Notice 2025-31 requirements, maintaining 97.3% accuracy rate across multi-state regulatory compliance
Senior Data Analyst - Finance
Sunnova Energy | Jun 2024 - Jul 2025 | Remote
- Architected Python-based geospatial analytics system that unlocked $250M in additional Investment Tax Credits by analyzing 200K+ solar assets across 29 states
- Built enterprise data infrastructure for 500K+ solar asset portfolio through 7 automated ETL pipelines (Python, DLT, DuckDB, Dagster) with 99.9% reliability
- Enabled $50M in incremental tax credits by collaborating with Legal, Tax, Pricing and Government Relations teams to translate IRS regulatory updates into automated business logic
Data Analyst - Financial Operations
Sunnova Energy | Nov 2022 - Jun 2024 | Remote
- Recovered $95M in dealer-related revenue through automated data pipelines using Python and Tableau: $91M in accounts receivables via integrated dashboards, $4M through credit note reconciliation
- Reduced accounts payable processing time by 75% by consolidating 4 separate reports into unified PostgreSQL database architecture with one-click automation
- Generated $1M in interest revenue over 9 months by implementing automated SQL/Tableau pipelines that identified 3,000 non-compliant systems ($51M value)
Selected Projects
AI Systematic Review Pipeline (2024-Present) – LangGraph multi-agent pipeline (GPT-4.1 + Claude), 99.3% recall across 6,673 papers at $1.16/review. Co-authored with Johns Hopkins Dept. of Plastic and Reconstructive Surgery, in peer review at PRS.
Qualitative NLP (2025) – Privacy-preserving pipeline for on-device open-source LLM qualitative analysis of patient transcripts.
wipnote (2024-Present) – Local-first observability and coordination platform for AI coding agents. HTML files as structured graph storage, SQLite cache, single Go binary. Open source.
Mercury Transport Modeling (2020-2022) – Computational simulation of atmospheric mercury variability and regional inversion modeling. Two papers: one resubmitted to JGR: Atmospheres, one in peer review. International collaboration (MIT, CSIRO, TU Munich).
TiltHQ (2025-Present) – Political media analytics platform in Elixir/Phoenix. OTP supervision tree, Oban background jobs, LiveView dashboard with real-time bias scoring.
Skhiya (2025-Present) – Desktop environment manager (Rust/Tauri + React). Manages .env files, SSH keys, and shell configs across projects.
Technical Skills
Programming: Python, SQL, Elixir, JavaScript, HTML/CSS, HTMX
Data Tools: Excel (Advanced), Tableau, Power BI, PostgreSQL, Power Query, Pandas, GeoPandas
Data Infrastructure: ETL Development, Dagster, DLT Hub, DuckDB, Snowflake, Phoenix/LiveView, Oban, Git/GitHub, API Development
Analytics & Cloud: Financial Modeling, Google Cloud, AWS, Docker, Salesforce, ArcGIS
Education
S.M. in Technology and Policy
Massachusetts Institute of Technology | Cambridge, MA | Sept 20 - Sept 22
- Thesis: GEOS-Chem atmospheric transport modeling and top-down inversion to constrain mercury emissions from artisanal and small-scale gold mining (ASGM); Peru’s Madre de Dios region case study, informing Minamata Convention policy
B.S. in Mechanical Engineering & Minor in German
Duke University | Durham, NC | Aug 15 - May 20
- Graduated with Departmental Distinction
- Mastercard Foundation Scholar
- Davis United World Scholar