Pipelines• Automation• Dashboards
Caleb Shepherd-Carpenter
Data Integrity Specialist
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
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 to Present, Las Vegas, NV
Safeguard data quality and design reporting systems for Nevada’s largest domestic violence services nonprofit. Develop specialized reporting, automate workflows, and strengthen data-driven decision making across departments and executive leadership.
- Quarterly Reports: Streamlined reporting by tagging data in the CRM, defining standardized data categories, and building specialized reports, enabling leadership to submit accurate grant data faster and with greater confidence.
- Data Governance: Partnered with staff and leadership to streamline data collection, define shared terms, and establish consistent reporting standards, improving clarity and reducing duplication across departments.
- Data Quality: Ensured data was entered accurately through routine checks, staff guidance, and corrective feedback, strengthening the reliability of organizational reporting.
- IT Asset Management: Built an asset tracking system in Microsoft Lists, SharePoint, and Power Apps, ensuring devices were traceable and compliant with security standards.
- ETL and Dashboards: Developed SQL and Power BI dashboards to monitor service delivery and contract KPIs, giving executives real-time visibility into performance.
- Data Literacy and Support: Provide staff training, technical support, and cross-department collaboration to enhance organizational data practices and resilience.
- User Support: Collaborated with a managed service provider (MSP) to deliver responsive IT support to staff, ensuring timely troubleshooting and smooth daily operations.