Browse categories
Explore
Fiverr Pro
English
$
USD
I will build your bigquery sql pipeline with staging and marts layers
Data Analyst, Analytics Engineer, BigQuery et Looker Studio Specialist
Hi, I'm Ricky, a passionate Data Analyst and Analytics Engineer. I specialize in turning raw, messy data into clean, automated, and highly interactive business dashboards using Google Cloud (BigQuery,...
About this Gig
Is your data scattered across multiple CSV files, platforms, or databases, making your SQL queries hard to maintain? I'll design a professional data pipeline on Google BigQuery, structured using Analytics Engineering best practices (dbt-inspired): a Staging layer to clean and cast your raw data, an Intermediate layer to apply your business rules (margins, taxes, order statuses), and a Marts layer ready to plug into your BI tool (Looker Studio, Power BI, Tableau).
What you get: clear, documented, reusable SQL scripts that don't need to be rebuilt every time new data comes in. Perfect if you're an e-commerce, SaaS, or marketplace business looking to move from patchwork reporting to a reliable data foundation.
Experience: I designed a full simulated 24-month international e-commerce platform (multi-country margin calculation, marketing attribution, LTV) using this exact layered architecture on BigQuery.
My Portfolio
FAQ
Do I need my own BigQuery account?
Not necessarily. I can set one up for you (Google Cloud offers a free sandbox tier), or work directly in your existing environment if you already have one.
Can you work with data other than BigQuery, like Snowflake or PostgreSQL?
Yes, the same staging/intermediate/marts approach works on most modern SQL warehouses. Just mention your platform in the order requirements.
What if my data is messy or has errors?
That's exactly what the Staging layer is for — cleaning, type casting, and filtering out inconsistent records is part of the process, not an extra step.
Will I be able to maintain or update this pipeline myself afterward?
Yes, all scripts are commented and documented. The Premium package also includes a handoff call to walk you through everything.
Can you also connect the pipeline to my BI tool (Looker Studio, Power BI)?
The Marts layer is specifically designed to plug into a BI tool. If you want the dashboard built as well, check out my dashboard gig or contact me for a bundle.
How many revisions are included?
1 revision on Basic, 2 on Standard, 3 on Premium. Additional revisions can be arranged if needed.
