Skip to main content
Back to Home

Data Engineering Portfolio

Building automated ETL/ELT pipelines, cloud data warehouses, and dbt models that turn raw data into one trusted source of truth.

Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbt — Data Engineering case study by Alfa Analytics
Video WalkthroughLead Architect
Watch Video & Read Case Study
Data Engineering
6 weeks

Social Media Data Stack: Airbyte, Fivetran, BigQuery & dbt

The client's analysts were pulling social media data by hand every week—logging into YouTube, Facebook, Instagram, TikTok, and other platforms one by one, exporting CSVs, and pasting numbers into reports. That took 8+ hours every week, and because each platform names and counts metrics differently, reports never matched.

95%
Drop in manual data collection time
8+ hrs/wk
Analyst time saved and redirected to insights
1 Source
Trusted set of audience & engagement metrics across all platforms
dbtBigQueryAirbyteFivetran+3
Gifting Platform Cloud Data Warehouse (Snowflake, Fivetran & dbt) — Data Engineering case study by Alfa Analytics
Featured Case StudyLead Data Engineer
Read Full Case Study
Data Engineering
8 weeks

Gifting Platform Cloud Data Warehouse (Snowflake, Fivetran & dbt)

A fast-growing corporate gifting SaaS platform had data scattered across its operational PostgreSQL database, legacy Snowflake tables, and third-party APIs. The executive team lacked visibility into key business metrics and had to ask product engineers to pull custom SQL reports for every question.

80%
Reduction in ad-hoc data requests sent to engineering
4x
Faster time-to-insight for executive business questions
$50K/yr
Engineering time saved through self-service Tableau analytics
SnowflakeFivetrandbtTableau+2
Tableau Server Two-Node Cluster Performance Optimization — Data Engineering case study by Alfa Analytics
BI Infrastructure Architect
Read Full Case Study
Data Engineering
2 weeks

Tableau Server Two-Node Cluster Performance Optimization

The client's two-node Tableau Server cluster was suffering from 1-hour+ extract refresh bottlenecks, frequent peak-hour crashes, and slow dashboard loads because both nodes were running heavy Backgrounder jobs alongside interactive VizQL user traffic.

75%
Reduction in extract refresh time (60+ min → 15 min)
0 Crashes
Peak-hour server outages eliminated (down from 3/month)
40%
Improvement in interactive dashboard load speed
Tableau ServerTSM CLILinuxCluster Tuning+1
GMV & SaaS ARR Sales Performance Tracker — Data Engineering case study by Alfa Analytics
BI Developer
Read Full Case Study
Data Engineering
3 weeks

GMV & SaaS ARR Sales Performance Tracker

Sales leadership couldn't track real-time progress toward quarterly and monthly GMV and SaaS ARR targets. Pipeline forecasting lived in manual spreadsheets with no rep-level deal visibility.

$5.81M
Quarterly GMV target tracked with live rep-level attainment
80.95%
Monthly GMV pacing visibility at a glance
Daily
Automated Salesforce deal-level syncs replacing manual sheets
LookerSQLSalesforceSaaS Metrics+1
AI Invoice PDF to Excel Comparison Tool — Data Engineering case study by Alfa Analytics
Video WalkthroughAI Automation Developer
Watch Video & Read Case Study
Data Engineering
2 weeks

AI Invoice PDF to Excel Comparison Tool

The client received invoices from many different suppliers, and every supplier used a different PDF layout. To compare product unit prices or catch billing errors, someone had to type every line item into a spreadsheet by hand—which was slow and made price changes easy to miss.

Any Layout
Works with new supplier invoice PDFs without custom template setup
Minutes
To consolidate batch invoices into one side-by-side Excel file
100%
Manual invoice spreadsheet typing eliminated
n8nClaude Sonnet 4Microsoft ExcelPDF Extraction+2
Discord Data Bots: Fix Google Sheets Errors & Answer Data Questions — Data Engineering case study by Alfa Analytics
Video WalkthroughAI Automation Developer
Watch Video & Read Case Study
Data Engineering
3 weeks

Discord Data Bots: Fix Google Sheets Errors & Answer Data Questions

The team managed large operational datasets in Google Sheets while coordinating daily work in Discord. Finding mismatched rows in the sheets required tedious manual reviews, and whenever team members had a question about the data, they had to wait for a spreadsheet expert to look it up.

~90%
Of plain-English data questions answered automatically in Discord
Auto-Fix
Mismatched Google Sheets rows corrected in place without manual review
Real Data
Every answer comes directly from live sheet rows, not AI memory
n8nDiscord APIGoogle Sheets APIOpenAI API+2
E-Commerce Data Architecture: 8-Platform BigQuery & dbt Stack — Data Engineering case study by Alfa Analytics
Lead Data Architect
Read Full Case Study
Data Engineering
5 weeks

E-Commerce Data Architecture: 8-Platform BigQuery & dbt Stack

Data was siloed across 8 different platforms (WooCommerce, Meta Ads, TikTok Ads, Google Ads, GA4, Klaviyo, Stripe, and ERP inventory) with no way to see the complete customer journey or calculate true customer acquisition cost.

8
Data sources unified into a single source of truth
Daily
Automated data syncs (replacing manual weekly exports)
100%
Attribution visibility across the customer journey
FivetranBigQuerydbtLooker Studio+2

Have a similar problem in your business?

Book a 30-minute call and we'll walk through how we would architect and automate your exact workflow.