Selected Work
Welcome to a curated snapshot of the work behind Emerald Duck Analytics LLC. From data architecture to financial automation, each project reflects a commitment to precision, scalability, and meaningful insights.
🧠 Data Architecture & Integration
Christianity Today International – Data Architect (Jul 2024–Present)
- Designed and maintained 40+ ETL pipelines across platforms including AWS S3, GCP, Shopify, Stripe, Sage Intacct, PayPal, and ActiveCampaign.
- Engineered a scalable data architecture supporting reporting, forecasting, dashboards, snapshots, risk monitoring, and machine learning.
- Led Snowflake administration and integration, optimizing data accessibility and security.
- Built REST and GraphQL API integrations to unify customer experience and marketing data.
- Conducted privacy, security, and ethics reviews to ensure compliance and minimize liability.
- Mentored data professionals and improved data literacy across departments.
📈 Financial Automation
Christianity Today International – Data Analyst (Mar 2023–Jul 2024)
- Automated journal entries and sales tax remittance, reducing manual workload and improving accuracy.
- Predicted revenue and expenses for budgeting using historical and real-time data.
- Optimized Stripe payment token workflows for compliance and cost efficiency.
- Created financial dashboards and reports that informed strategic decisions across marketing, fundraising, and editorial teams.
📊 Analytics & Dashboards
- Built and maintained 30+ interactive dashboards using R Shiny and Power BI.
- Delivered monthly reports and strategic recommendations to executive leadership.
- Enabled real-time performance monitoring with custom visualizations and KPI tracking.
- Spearheaded the design of a data ecosystem for a publishing company with ~100K paid subscribers.
🧩 Platform Integration & Migration
- Migrated legacy systems to cloud-based platforms, improving reliability and scalability.
- Integrated Snowflake into the company’s data ecosystem, serving as lead admin.
- Unified disparate data sources to enable holistic analysis and seamless reporting.
🧪 Technical Highlights
- Languages & Tools: R, PostgreSQL, DuckDB, Snowflake, AWS, GCP
- Specialties: ETL orchestration, financial modeling, dashboarding, API integration
- Certifications: Data Engineer Associate (DataCamp)
- Soft Skills: Cross-functional collaboration, mentorship, ethical data stewardship
Looking for more details or a tailored solution? Let’s explore how Emerald Duck Analytics can elevate your data strategy.