Salesforce · salesforce.wd12.myworkdayjobs.com · checked today
Data Engineering Senior Associate
To get the best candidate experience, please consider applying for a maximum of 3 roles within 12 months to ensure you are not duplicating efforts. Salesforce is the #1 AI CRM, where humans with agents drive customer success together. And innovation isn’t a buzzword — it’s a way of life.
Skills, with evidence
- Airflow / orchestration
Experience with Apache Airflow workflow development, scheduling, and monitoring.
must have - Data quality
Perform data validation, source-to-target reconciliation, completeness checks, and failed-job recovery to ensure reliable data delivery.
must have - Python
Hands-on experience with Python and Snowflake.
must have - SQL
Strong SQL development, data analysis, and production troubleshooting skills.
must have - Warehousing
Knowledge of data warehouse concepts, including fact and dimension tables, star and snowflake schemas, conformed dimensions, and Slowly Changing Dimensions.
must have - Failure handling
Design, maintain, and monitor Apache Airflow DAGs for scheduling, workflow orchestration, dependency management, retries, and failure recovery.
- Data modelling
Knowledge of data warehouse concepts, including fact and dimension tables, star and snowflake schemas, conformed dimensions, and Slowly Changing Dimensions.
- Incremental loads
Familiarity with Salesforce data models and tools such as Bulk API, REST API, Platform Events, or Change Data Capture.
- Dashboards & BI
Tableau reporting and dashboard-development experience.
not practised here
Your plan
- The SQL screen: correct, then fast≈ 2 h
Data quality · SQL
- Median delivery time per cityIntermediate
- Bucket deliveries into quartilesIntermediate
- Median order value without a median functionIntermediate
- New and repeat orders by monthIntermediate
- Every order against its customer's averageIntermediate
- Python: the data-wrangling round≈ 3 h
Python
- Diff two snapshots of a tableIntermediate
- Explode an array column into rowsIntermediate
- Flatten nested event payloadsIntermediate
- Pivot a long metrics table to wideIntermediate
- Choose what an incremental run should readIntermediate
- Data modelling: the round most people fail≈ 3 h
Warehousing · Data modelling
- Addresses that stay true to the pastIntermediate
- Seat holds and the release-night raceIntermediate
- Subscription warehouse grainIntermediate
- Campaign efficiencyIntermediate
- Catalogue: products, variants and sellersIntermediate
- Pipeline design: safe to run twice≈ 4 h
Airflow / orchestration · Failure handling · Incremental loads
- Is this change safe?Intermediate
- Marketplace transactions at scaleIntermediate
- The source will not let youIntermediate
- Changing a pipeline that’s already runningIntermediate
- SLA-aware alerting flowIntermediate
- Say it out loud≈ 1 h
20 drills · Intermediate + Advanced≈ 12 hours
Not covered by the plan: Dashboards & BI.
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 13 dremoved the moment Salesforce closes it