Pipelines• Automation• Dashboards
Caleb Shepherd-Carpenter
Data Integrity Specialist → Data Analyst
I build reliable pipelines, automate reporting, and turn ad-hoc chaos into clean dashboards.
Highlights
60+
Hours saved/quarter
10+
Dashboards delivered
12
Automations in prod
Core Skills
PythonSQLPower BIPandasSharePointPower AutomateETLData ModelingAPI IntegrationsExcelSnowflake
Selected Projects
CRO → SQL → Power BI: Weekly ETL + QA
Cut quarterly reporting time from 140 → 80 hours by refactoring data model and automating extracts.
PythonSQLPower BIETLAutomation
- Built robust API client with retries + date partitioning
- Modeled data for consistent grant reporting
- Published dataset to Power BI; added data-quality flags
SharePoint + Power Automate Ticketing for Finance
Introduced request intake with auto-routing and SLAs; improved visibility for supervisors.
SharePointPower AutomateProcess
- Built list schema + flows for notifications and audit logs
- Forwarded planner comments to closure email
- Reduced email back-and-forth and status ambiguity
Executive Reporting Model & Dashboards
Served as POC for contractor build; mapped data and designed dashboards for leadership.
Data ModelingPower BIStakeholder Mgmt
- Owned metric definitions and acceptance criteria
- Validated ETL outputs; documented edge cases
- Transitioned maintenance knowledge in-house
Experience
SafeNest — Data Integrity Specialist
Oct 2022 – Present, Las Vegas, NV
- Developed IT asset tracking system using Microsoft Lists, SharePoint, and Power Apps.
- Reduced quarterly reporting time from 140 to 80 hours by refactoring incident reports.
- Built automated ticketing for finance with notifications and oversight.
- Created ETL dashboards integrating SQL pipelines with Power BI.