Jay Napolitano
Product Engineer
Profile
Product and data engineer building full-stack internal tools, analytics systems, AI-assisted workflows, registry data platforms, and public product surfaces. The work sits across product discovery, UX, APIs, data modeling, cloud infrastructure, and operational reporting.
Professional Experience
Data Engineer
AdventHealth
Builds clinical registry data infrastructure for institute reporting, data quality review, and governed Snowflake modeling.
- Develops a metadata-driven registry platform that ingests clinical quality files from SharePoint into Azure Blob Storage, preprocesses them, stages them to Snowflake, and models bronze, silver, and gold layers.
- Supports registry data such as NCDR, STS, AHA Get With The Guidelines, ELSO ECMO, VQI, and related cardiopulmonary quality sources.
- Builds validation, lineage, audit, schema-drift, file-parity, row-parity, null-check, cardinality, and reconciliation workflows for data engineers, architects, analysts, and institute stakeholders.
- Creates Streamlit review tools, metadata manifests, schema documentation, Snowflake SQL models, UDFs, and local CLI workflows for controlled review and release.
Analytics Engineer
Penske Media Corporation
Built analytics, AI-assisted editorial tools, executive reporting, and audience data products across a large media portfolio.
- Helped build Omnilytics, a Next.js executive analytics surface that centralized curated Looker reporting for C-suite, SVPs, editors, and senior analysts across Penske brands.
- Built and maintained Azure-hosted RAG and ChatGPT-style editorial tooling with a Next.js frontend, Flask API backend, Cosmos DB, Azure AI Search, OCR, Microsoft Graph API, and Bicep deployment scripts.
- Built audience and advertising pipelines using Treasure Data, BigQuery, Snowflake, GCP Cloud Functions, Google Analytics, Piano, Google Search Console, vendor APIs, Python, SQL, and Go.
- Interviewed editors, analysts, department heads, SVPs, the COO, and the CTO to identify workflow pain, prototype internal tools, QA dashboards, and simplify reporting and data products.
Data Products & Automation
BTJN
Converted client data requests into reusable data collection, enrichment, and reporting workflows.
- Collected public web data, normalized it into market-specific datasets, enriched records, and delivered lead lists and automated CSV reports for clients.
- Built reusable Python, SQL, Postgres, browser automation, Google Sheets API, GCP, and cron-driven pipelines with logging for repeated delivery.
- Translated one-off client requests into algorithmic processes that could be reused across similar markets and reporting needs.
Selected Projects
Empirical research workflow for planning, retrieval, scoring, synthesis, and source-backed technical decisions.
Open News ReaderNews analysis appA reader for grouping sources, reducing noise, and turning current news into reviewable signal.
Open InstrumentalApplied AI systemA working project surface for agentic workflows, software orchestration, and practical tool-building experiments.
Open Clinical Registry Data PlatformHealthcare data platformMetadata-driven registry platform for clinical quality data ingestion, validation, lineage, Snowflake modeling, and governed reporting.
Open GitHubPublic codePublic repositories, experiments, project pages, and the visible surface of current build work.
Open Evidence ModelReview systemThe data model behind this review: job requirements, claims, evidence lineage, scores, and report routes.
OpenEducation
University of Central Florida
August 2017