Carter DuBois

Junior Data Architect

Healthcare • Full-time

Oct 2025 - Present • 11 mos

• Built multidirectional platform sync (Mailchimp, Heymarket, Bullhorn) with delta detection, fill-only merge fields, and an audit trail that captures every field level change in JSONB and renders per contact activity. Eliminated prior N8N workflow stack (11 workflows) with Airflow DAGs and ~20+ system timers + DB triggers. • Designed PostgreSQL data warehouse from scratch: 80+ normalized tables, 300+ indexes (B-tree / GIN / trigram), 20+ views, 140+ idempotent migrations tracked with custom checksum drift detector. Extensive DB rules enforced through BEFORE-INSERT triggers instead of application code to prevent data bypassing cleaning. • Deployed 100+ production web scrapers (Scrapy + Playwright + API Request) automated in Docker across national medical directories and state licensing boards. Each replacing 80-200 hours of manual data collection per quarter. • Shipped a Flask admin dashboard (40+ routes) for data quality monitoring, practitioner search, ETL run inspection, duplicate review, and a per-contact audit trail that is used by both recruiters and executives daily. • Engineered an end-to-end ETL pipeline (TypeScript + Python) for recruiter CSV uploads: dedup, name reconciliation, MillionVerifier email + NumVerify phone validation with 365-day caching, reducing external API spend by ~60%, specialty alias rewriting and idempotent writing. Processed 700+ databases totaling 22m+ rows of practitioner/practice data.

Data Specialist

Aviation • Full-time

Mar 2024 - Oct 2025 • 1 yr 7 mos

• Performed large-scale data processing of 3.5+ million records using Power Query, AWS Textract, and Fuzzy Matching to enhance ETL workflows by reducing processing time by 85%, removing a multiple-year-long marketing bottleneck. • Created and maintained data pipelines using Python for API integration and database insertion, PostgreSQL for database management and warehousing, and Power BI for visual analysis of aviation flight data for marketing purposes. • Deployed a web scraper using Python to extract model eligibility data from various company websites, cross-referencing with supplier supplement databases to streamline product compatibility and reduce manual research time by nearly 90%.

Sole Proprietor

Online Shopping Store • Self-employed

Jan 2016 - Aug 2019 • 3 yrs 7 mos

• Founded a digital marketplace business, generating $120,000 in revenue over 3.5 years by leveraging Excel-based market analysis and predictive modeling of demand patterns to serve 500+ unique, global customers. • Analyzed operational performance metrics and developed detailed Excel reports highlighting KPI’s, issues, and exceptional performance with partners and employees, culminating in a 98% customer satisfaction rate. • Engineered automation tools and gameplay enhancement software with Python and C++, managing complete development pipeline including feature specification, coding, quality testing, deployment, and ongoing maintenance based on customer requirements.