Portfolio

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? Contact us to explore how Emerald Duck Analytics can elevate your data strategy.