Skip to main content
Digital Talent Framework

Career Progression Framework

McKinsey Rewired Exhibit 11.1 — Digital Talent Competency Markers

McKinsey Exhibit 11.1 (adapted)
Select Level
Junior DE
Apprenticing
Competency Area
Junior DEApprenticing
Data Pipeline Design
Performs basic data pipeline tasks with guidance; runs standard connectors and monitors scheduled jobs.
🏛️Data Warehouse Architecture
Has growing understanding of Snowflake features, table design patterns, and warehouse sizing.
🔄ETL/ELT Development
Can build transforms in dbt/Spark from defined specifications, working collaboratively with data analysts.
📁SFTP/File Integration
Configures SFTP endpoints and implements basic file parsing with guidance; growing familiarity with PGP encryption and file validation.
Data Quality & Governance
Runs data quality checks defined by others; generates basic quality reports with guidance on presentation.
🛠️Platform Engineering
Writes good, accurate production code with limited guidance; growing familiarity with CI/CD pipelines and infrastructure-as-code.
Source: McKinsey Exhibit 11.1 (adapted) · ADLC Framework v3.7.3 · adlc.oceansoft.io