Experience · now
Rochester Regional Health
Information Systems and Technology Co-op, Analytics and Data Engineering
May 2026 – Dec 2026 · Rochester, NY
Snowflake
FabricPower BI
SQL Server
Python
Power Automate
Jira
Copilot Studio
- Architected a Jira analytics platform across Snowflake, Fabric and Power BI for cross-functional engineering and clinical teams.
- Modeled a Bronze-to-Gold medallion architecture in Snowflake using streams and stored procedures for business-ready tables.
- Orchestrated a Fabric pipeline with timestamp-based incremental ingestion, cutting Snowflake load runtime by 67%.
- Built a 30+ table star schema Power BI semantic model on OneLake, with DAX measures as the source of truth for reports.
- Delivered 5 multi-page Power BI reports with 20+ KPIs as a Fabric Workspace App, improving decision-making efficiency.
- Automated a monthly Fabric and Python reporting workflow, turning SQL Server data into Excel and distributing it via Power Automate.