ETL/ELT Design
The ability to architect and implement data extraction, loading, and transformation workflows — selecting appropriate tools, managing dependencies, and ensuring data arrives in the warehouse reliably and on schedule.
Day-to-day use
Configuring Fivetran connectors for Salesforce and Marketo, writing dbt transformation models that clean and join raw data, scheduling sync frequencies based on business requirements, monitoring pipeline failures and SLA adherence, and documenting data lineage.
Typical tasks
- ·Designing an ELT pipeline architecture for a new Salesforce to Snowflake integration
- ·configuring incremental sync logic for a large opportunities table
- ·building error handling and alerting for a critical revenue pipeline
- ·documenting data transformation lineage in dbt
Business outcome
Reliable ELT/ETL design ensures revenue data arrives in analytics systems on time and in the correct form — the invisible infrastructure that makes all forecasting, attribution, and performance management possible.
Where this skill is applied
Technical Disciplines
Analytical Engineering
Transforms raw revenue data into clean, trusted models that power reporting, forecasting, and decision-making across the GTM organisation.
RevOps Data Engineer
Designs and maintains the data infrastructure — pipelines, warehouses, and integrations — that ensures revenue data is accurate, available, and actionable.