Hi, I'm John Lorenzo.
Data Engineer

I leverage code and visualization to uncover trends, solve complex problems, and drive data-driven decision making.

About Me

I am a Data Engineer based in Hamilton, OH, with a strong background in clinical data and dashboard development.

I hold a B.S. in Computer Science (Minor in Data Science) from Northern Kentucky University.

My professional experience has strengthened my ability to connect technical data insights with practical business needs. I’m passionate about building tools that turn raw data into meaningful solutions.

Email Me Hamilton, OH

Professional Experience

Data Engineer

TriHealth • January 2026 – Present • Cincinnati, OH

Write and optimize complex SQL queries across Clarity and Caboodle databases to develop ETL pipelines and model healthcare data for reporting.
Build custom reports and analytical tools using SlicerDicer and Reporting Workbench to support clinical workflows and administrative decision-making.
Collaborate with healthcare teams and stakeholders to translate operational reporting needs into scalable database queries and dashboard solutions.

Clinical Data Analyst

Medpace • August 2022 – August 2024 • Cincinnati, OH

Designed and maintained Spotfire dashboards to monitor patient safety and site performance across multiple clinical trials.
Translated clinical trial protocols and CRFs into data visualization specifications.
Produced biweekly/monthly safety reports used by medical teams to guide trial decisions.
Automated ad hoc analyses using Python, including a lab cross-table tool for flagging abnormalities.

Featured Projects

A selection of work showcasing my experience in data analysis, visualization, and automation.

Lottery Scratch-Off Analyzer

Daily data pipeline tracking scratch off lottery tickets. Analyzes prize pools, expected value, and optimal purchasing strategies in real-time.

R Shiny Python Web Scraping PHP API

View Project

Clinical Safety Dashboard

Interactive dashboard visualizing key patient safety metrics with drill-down capabilities for non-technical users.

Tableau Clinical Trial Data Data Viz

View Project

Technical Skills

A comprehensive toolkit for data analysis, visualization, and automation.

Programming

Python
R
SQL
SAS
Java

Visualization & BI

Spotfire
R Shiny
Tableau
Power BI

Core Competencies

Clinical Data Analysis
Dashboard Design
Automation
Data Cleaning

Certifications

Epic Cogito Fundamentals
Epic Caboodle Data Model
Epic Clarity Data Model
Epic Clinical Data Model
Microsoft Azure Fundamentals

Interested in my full background?

Download my resume to see how my skills can benefit your team.

Download Resume Contact Me

Let's Connect

Feel free to reach out!

[email protected]

Hamilton, OH

Hi, I'm John Lorenzo. Data Engineer