Data & Systems Professional ยท Pittsburgh, PA

Anthony
Hamilton

Data Engineer & Technical Lead

I design scalable data pipelines, lead engineering teams, and turn complex data challenges into clean, reusable frameworks. Currently building enterprise data solutions at PANTHERx Rare Pharmacy using SQL Server, Azure Databricks, and Azure DevOps.

Anthony Hamilton
Open to opportunities
Anthony Hamilton
Data engineer and technical lead based in Pittsburgh, PA. I build the systems that turn raw data into decisions โ€” from scalable pipelines to the teams that maintain them.

Skills & Expertise

โ˜๏ธ
Cloud & Data Engineering
Azure DatabricksSQL ServerAzure DevOpsETL / ELTData Pipeline Design
๐Ÿ“Š
Reporting & Analytics
PowerBIStatistical AnalysisData ValidationData SanitationInventory Reporting
โš™๏ธ
Development & Automation
SQLJavaAPI DevelopmentScriptingGoAnywhere MFT
๐Ÿงญ
Leadership & Delivery
Team Leadership (17)Agile / ScrumBacklog ManagementStakeholder MgmtArchitecture Review
๐Ÿ”—
Data Integration
EDI File ManagementData FeedsPBM SystemsVendor InterfacesPatient Status Frameworks
๐Ÿ–ฅ๏ธ
Systems & Infrastructure
Linux Server AdminOffice 365Active DirectoryRuby on RailsHelp Desk
CompTIA A+
CompTIA A+
CompTIA ยท CE Certified
CompTIA Network+
CompTIA Network+
CompTIA ยท CE Certified
CompTIA Security+
CompTIA Security+
CompTIA ยท CE Certified

Work History

April 2025 โ€“ Present
Data Engineer
PANTHERx Rare Pharmacy ยท Pittsburgh, PA (Remote)
Lead a team of 17 developers across three data initiatives, providing technical leadership, architectural guidance, and delivery oversight. Manage daily standups, remove blockers, and maintain project backlogs in Azure DevOps. Serve as Lead Data Engineer for the Data Feeds team, designing scalable solutions and acting as Subject Matter Expert in inventory reporting, patient status frameworks, and enterprise data feeds using SQL Server and Azure Databricks.

Key achievements: Built a Master Inventory framework that standardized drug inventory reporting across the organization, reducing new development timelines from ~14 days to 1โ€“4 days. Developed a config-driven patient journey status reporting platform that consolidated status logic into a unified reporting table, reducing development time from ~1 month to 1โ€“2 weeks. Consolidated 48 separate tables into 1 standardized table for greater insight into patient journeys.
July 2024 โ€“ April 2025
Reporting Analyst
eNGINE ยท Pittsburgh, PA
Oversaw data feeds for 9 drug programs ensuring contractual compliance. Worked directly with clients and stakeholders to validate data delivery. Converted legacy reports into PowerBI, mined and cleaned data from numerous sources, and developed EDI 850 file transmission procedures with third-party vendors.
July 2020 โ€“ July 2024
Data / Systems Analyst I
90 Degree Benefits ยท Pittsburgh, PA
Built and validated data feeds using SQL for PBMs, carriers, analytics, and portal access. Created API tools that reduced data entry time from 45 seconds to under 1 second per record. Successfully migrated 3 years of historical data between claims systems and developed Java programs for data extraction, cleaning, and formatting.
October 2019 โ€“ July 2020
Operations Analyst / Help Desk
Managed Care of America ยท Heidelberg, PA
Built and validated data feeds using BASH and Java. Developed a database for RX data received from PBMs, established automated processes for loading EDI files, and administered the help desk ticketing system for full end-user support.
March 2015 โ€“ October 2019
Facilities & Operations Supervisor
Chick-fil-A
Progressed from team member to supervisor, overseeing facility equipment, maintenance scheduling, and LEAN-based inventory management. Built a custom inventory tracking system adopted by multiple local franchises, reducing food cost across locations.

Key Achievements

14 days โ†’ 1โ€“4 days
Master Inventory Framework
PANTHERx Rare Pharmacy
Built a standardized drug inventory reporting framework that replaced bespoke per-drug development, cutting new report delivery timelines by up to 93%.
48 tables โ†’ 1
Patient Journey Status Platform
PANTHERx Rare Pharmacy
Designed a config-driven reporting platform that consolidated 48 separate status tables into a single unified table, reducing development time from ~1 month to 1โ€“2 weeks.
45 sec โ†’ <1 sec
API Automation Tool
90 Degree Benefits
Developed an API-driven tool that reduced per-record data entry time from 45 seconds to under 1 second โ€” a 98%+ efficiency gain across high-volume operations.
3 years of data
Legacy System Migration
90 Degree Benefits
Successfully led the extraction, transformation, and migration of three years of historical claims data from Eldorado into the VBA claims system with full integrity validation.
Multi-franchise adoption
Inventory Tracking System
Chick-fil-A
Built a custom LEAN-based inventory tracking system that was voluntarily adopted by multiple local franchises, measurably reducing food cost across locations.

Education

Liberty University
Master of Science
Information Technology
Liberty University ยท Lynchburg, VA
2021 โ€“ April 2024
Liberty University
Bachelor of Science
Business Administration
Minor in Psychology
Liberty University ยท Lynchburg, VA
2017 โ€“ 2020

Community Service

May 2023 โ€“ Present
Firefighter I
North Franklin Volunteer Fire Company ยท Washington, PA
Respond to emergent, non-emergent, mutual aid, medical, and public service calls. Oversaw the planning, migration, and implementation of the network infrastructure for reliable communication across the department.
January 2025 โ€“ February 2026
Treasurer
North Franklin Township Firefighters Relief Association
Served as Treasurer managing financial oversight, reporting, and fiduciary responsibilities for the firefighters relief association.
August 2024 โ€“ Present
Board of Directors Member
Child Evangelism Outreach ยท Washington, PA
Serve on the board of directors, providing guidance across the technological landscape for the organization's operational and communication needs.

Get In Touch

Whether you're looking for a skilled data & systems professional, want to discuss a project, or just want to connect โ€” reach out on LinkedIn or by email.