← All Skills
SkillTechnical

Data Pipeline Design

The ability to architect and build reliable data movement and transformation workflows that extract data from source systems, load it into a warehouse, and transform it into analytics-ready models.

Day-to-day use

Designing Fivetran connector configurations, writing dbt models to clean and standardise CRM exports, monitoring pipeline run schedules, debugging data freshness issues, and documenting lineage for downstream metrics.

Typical tasks

  • ·Designing an ELT pipeline from Salesforce and Stripe into Snowflake
  • ·building dbt staging models for opportunity data
  • ·setting up data freshness alerts in Monte Carlo
  • ·documenting table ownership and refresh cadences

Business outcome

Reliable data pipelines ensure all revenue dashboards reflect accurate, timely data — enabling confident forecasting, attribution, and performance management decisions.