Warehouse migration in 6 weeks
Moved legacy reports to Snowflake + dbt with automated tests. Cut manual report refresh from weekly 3h task → live 15m intervals.
Freelance data engineer · analyst · architect helping teams ship modern ELT pipelines, analytics, and AI-ready stacks (Snowflake, BigQuery, dbt, AWS & GCP).
Based in Portugal · Remote worldwide
Hi, I’m Allen Huang. I design data architectures and build pipelines that make analytics trustworthy and fast. Whether you’re migrating to a cloud warehouse, implementing dbt, or need someone to tame flaky ETLs, I love shipping pragmatic solutions with strong testing and documentation.
Design & build ELT/ETL, ingestion, orchestration, and testing. Migrate to Snowflake/BigQuery. CI/CD & infra as code.
Modeling with dbt, metrics layers, and performant SQL. Deliver clean datasets and dashboards that answer real questions.
Blueprints for scalable, secure, and cost-aware data platforms. Audits, roadmap, and hands-on prototypes.
Moved legacy reports to Snowflake + dbt with automated tests. Cut manual report refresh from weekly 3h task → live 15m intervals.
Automated models to track and manage billable medical codes: this process saved > 100H monthly at the current capacity, with scalable savings as the organisation grows.
Right-sized warehouses, job schedules, and caching policies to save ~30% monthly.
30–45 min call to map goals, data sources, and constraints.
Scope, milestones, and success metrics. Fixed-bid or time & materials.
Ship iteratively, document thoroughly, and enable your team.
Tell me about your data challenges and goals. I’ll reply within one business day.