NSXNational Skills ExchangeSign in
Back to Framework

Data Warehousing Specialists

SOC 15-1243.01Job Zone 4 · Considerable Preparationv.26.05

Context coveredThis framework covers data warehousing practice in enterprise and industry sector environments, spanning ETL design, database architecture, data quality, standards governance, and platform leadership calibrated to Job Zone 4 preparation and experience.

Sources:O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.SkillsCrosswalkSkillsCrosswalk — O*NET enrichment + adjacency index. Opens in new tab.
Emerging
Entry / Apprentice
  1. Data warehouse process models — identify and document sourcing, loading, transformation, and extraction steps under direct supervision in a structured enterprise environment.
  2. Warehouse data quality — perform basic verification checks on structure and accuracy using predefined validation scripts in a team-supported data environment.
  3. Data mapping documentation — assist in mapping data fields between source systems and data warehouses following established templates and guidelines.
  4. Data extraction procedures — execute existing ETL scripts from administration or billing systems under senior specialist direction in a production support setting.
  5. Warehouse database structures — assist in designing simple schemas by applying foundational relational database principles in a supervised project environment.
  6. Data warehouse standards — review and apply existing organizational naming conventions and structural standards when working with warehouse elements.
  7. Troubleshooting support — document and escalate data warehouse incidents by following established triage protocols in a helpdesk-supported environment.
  8. Programming tasks — modify small, well-defined segments of existing ETL or reporting code using current languages under code-review oversight.
  9. Metadata management software — navigate and query metadata repositories to locate data lineage information under guided instruction in a warehouse environment.
  10. Technical documentation — read and interpret system specifications, data dictionaries, and warehouse design documents to support assigned task completion.
Developing
Mid-level / Established
  1. Data warehouse process models — design and refine ETL process flows covering sourcing, transformation, and loading with reduced oversight in an enterprise data environment.
  2. Warehouse data quality — conduct systematic accuracy and structural audits using query tools and profiling software, resolving common anomalies independently.
  3. Data mapping specifications — produce and validate end-to-end field mapping documents between source systems, data warehouses, and data marts for routine integration projects.
  4. Data extraction procedures — develop and implement extraction routines from billing, claims, or administrative systems using current ETL platforms in a multi-source environment.
  5. Warehouse database structures — design and deploy normalized and dimensional database schemas to meet defined business requirements in a managed data warehouse setting.
  6. Warehouse standards maintenance — update and enforce data architecture naming conventions, model standards, and tooling guidelines across assigned warehouse components.
  7. Troubleshooting coordination — diagnose and resolve moderate data warehouse failures by analyzing logs, tracing data flows, and coordinating fixes with application teams.
  8. Program development — write and test new ETL programs or reporting scripts using object-oriented or procedural languages to satisfy defined customer requirements.
  9. Systems analysis — evaluate source system data structures and integration points to identify compatibility issues before warehouse load cycles begin.
  10. Stakeholder communication — explain data warehouse processes and integration decisions clearly to business analysts and project managers in cross-functional meetings.
Proficient
Senior / Expert IC
  1. Data warehouse process models — architect comprehensive end-to-end process models spanning sourcing, transformation, loading, and extraction layers across complex, multi-domain enterprise environments.
  2. Data quality assurance — design and execute advanced validation frameworks that detect structural defects, referential integrity failures, and semantic inconsistencies across the full warehouse scope.
  3. Cross-system data mapping — lead the creation of authoritative mapping specifications integrating heterogeneous source systems, enterprise data warehouses, and subject-area data marts.
  4. Extraction procedure engineering — engineer robust, high-performance data extraction solutions from diverse operational systems, incorporating error handling and incremental load strategies.
  5. Warehouse database architecture — design scalable star and snowflake schemas, partitioning strategies, and indexing plans optimized for analytical query performance in large-scale environments.
  6. Standards governance — develop and enforce enterprise-wide data warehouse design standards covering architectures, models, tooling selection, and database nomenclature.
  7. Troubleshooting leadership — independently diagnose and resolve complex, non-routine data warehouse incidents including performance degradation, data corruption, and pipeline failures.
  8. Advanced programming — write, optimize, and refactor complex ETL programs and stored procedures using current languages and technologies to meet evolving customer and system requirements.
  9. Systems evaluation — assess warehouse platform performance, scalability, and fitness-for-purpose against business objectives, recommending architectural improvements based on evidence.
  10. Critical problem solving — apply deductive and inductive reasoning to resolve ambiguous data integration challenges that span multiple business domains and technology stacks.
Advanced
Lead / Principal / Executive
  1. Enterprise data warehouse strategy — define and drive the long-term vision, roadmap, and investment priorities for data warehousing capabilities across the organization.
  2. Process model governance — establish organizational standards for warehouse process model design, ensuring consistency, reusability, and alignment with enterprise data strategy.
  3. Data quality policy — develop and institutionalize data quality policies, metrics, and accountability structures that govern warehouse accuracy and trustworthiness at organizational scale.
  4. Architectural leadership — lead the design of next-generation warehouse and data platform architectures, incorporating cloud, lakehouse, or hybrid patterns to meet strategic business needs.
  5. Standards body leadership — chair or lead enterprise data governance committees that define, publish, and evolve data warehouse standards, taxonomies, and architectural principles.
  6. Organizational troubleshooting capability — build and mature a warehouse support function, including runbooks, escalation frameworks, and on-call structures that ensure platform reliability.
  7. Technology evaluation and adoption — evaluate emerging warehouse platforms, ETL tools, and metadata management solutions, making adoption recommendations with measurable business impact.
  8. Talent development — mentor and coach data warehousing specialists across all experience levels, designing learning pathways that elevate team capability and bench strength.
  9. Cross-functional alignment — partner with executive stakeholders, data governance officers, and enterprise architects to translate business strategy into actionable data warehousing initiatives.
  10. Innovation and research — lead proof-of-concept initiatives exploring advanced data integration, real-time warehouse patterns, or AI-augmented ETL processes to sustain competitive organizational advantage.

AI-at-Work Competency Framework

Sources:Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab.Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab.WEF Skills TaxonomyWEF Skills Taxonomy 2021 — Building a Common Language for Skills at Work. Opens in new tab.
Subscriber feature

Authoritative source data identified for 998 occupations

How a worker at each mastery level uses, directs, and evaluates AI tools in this occupation. Each statement cites its evidence inline; click a citation chip to verify the source.

Emerging
  1. AI-assisted SQL generation — accepts LLM-suggested query templates for straightforward data extraction tasks, manually reviewing each clause against the source schema before execution Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab..
  2. ETL boilerplate scaffolding — uses AI chat tools to generate initial transformation script stubs, then hand-edits logic to match business rules and source-system constraints Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab..
Developing
  1. Data quality verification support — delegates routine row-count reconciliation and null-check scripts to an AI assistant, then validates outputs against warehouse acceptance criteria Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab. Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab..
  2. Schema mapping drafts — prompts an LLM to produce first-pass column-level mappings between source systems and the data mart, reviewing and correcting mismatches before committing to the ETL pipeline Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab..
  3. Process model documentation — directs an AI tool to draft narrative descriptions of sourcing, loading, and transformation flows from structured notes, then edits for technical accuracy and completeness Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab..
Proficient
  1. Complex ETL pipeline design — orchestrates an AI assistant through multi-step transformation logic by providing explicit business rules and iteratively validating intermediate outputs, retaining authorship of the overall architecture Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab. Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab..
  2. Data extraction procedure generation — supplies AI tools with source-system API specifications and target schema definitions to auto-generate extraction code, then stress-tests edge cases and error-handling paths manually Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab..
  3. Warehouse database structure review — uses LLM analysis to surface indexing inefficiencies and denormalization opportunities in proposed schemas, applying critical judgment to accept, modify, or reject each recommendation Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab. WEF Skills TaxonomyWEF Skills Taxonomy 2021 — Building a Common Language for Skills at Work. Opens in new tab..
  4. Cross-system anomaly investigation — feeds AI tools with profiling summaries and data dictionaries to rapidly hypothesize root causes of data integrity failures, then traces confirmed issues back through lineage logs Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab..
Advanced
  1. End-to-end AI workflow governance — defines organizational standards for how AI tools are integrated across the full warehouse lifecycle—sourcing through extraction—establishing validation gates that preserve data accuracy and auditability Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab. WEF Skills TaxonomyWEF Skills Taxonomy 2021 — Building a Common Language for Skills at Work. Opens in new tab..
  2. AI autonomy calibration — sets bounded autonomy levels for AI agents handling repetitive load-and-transform jobs, intervening on schema-change events or business-rule exceptions that exceed pre-defined confidence thresholds Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab. Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab..
  3. Strategic capability evaluation — evaluates emerging AI coding and data-pipeline tools against the Q2 augmentation profile of warehouse work, recommending adoption only where human oversight remains integral to quality assurance Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab. WEF Skills TaxonomyWEF Skills Taxonomy 2021 — Building a Common Language for Skills at Work. Opens in new tab..
Evidence pack
AEI usage
Task observations: 58849
Augment share: 95%
Time saved: 82.7%
AI autonomy: 3.20
SAFI positioning
Top skill: Reading Comprehension
Score: 45.5 / 100
Quadrant: Q2_ai_augmented
precision: exact
WEF cluster
Artificial Intelligence
artificial_intelligence
Sources:Anthropic Economic IndexAnthropic Economic Index — release_2026_03_24. Opens in new tab.Jadhav & Danve, 2026Skill Automation Feasibility Index — Jadhav & Danve, 2026 (arXiv:2604.06906). Opens in new tab.WEF Skills TaxonomyWEF Skills Taxonomy 2021 — Building a Common Language for Skills at Work. Opens in new tab.

Pathsmith Durable Skills Framework

Sources:Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Subscriber feature

Ten durable-skill domains mapped to four proficiency/role levels for each occupation. Each statement is aligned to the Pathsmith taxonomy, derived from trusted grounding data and mapped to occupation-specific O*NET tasks and skills.

1Communication10 statements
Emerging
  1. Data warehouse documentation — drafts basic technical specifications for ETL processes using standard templates and terminology Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Stakeholder intake — listens to business requirements during initial meetings and records data sourcing needs for review by senior specialists Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Developing
  1. ETL process communication — explains data transformation logic and pipeline design to non-technical stakeholders using plain language analogies Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Issue reporting — writes structured incident reports documenting data quality failures, root causes, and remediation steps for warehouse systems Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Requirements gathering — conducts active listening sessions with source system owners to capture data mapping requirements accurately Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Data architecture presentation — delivers clear verbal and written explanations of warehouse schema designs, including star and snowflake models, to both technical teams and business users Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Standards documentation — authors and maintains comprehensive data warehouse standards covering nomenclature, structure, and architecture for organization-wide use Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Cross-functional briefing — translates complex ETL extraction procedures and data mart mapping decisions into actionable guidance for downstream consumers Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Exceeding
  1. Executive communication — presents data warehouse strategy, capacity planning, and governance recommendations to senior leadership with precision and business relevance Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Knowledge transfer authorship — produces definitive technical guides on data warehouse process models, sourcing pipelines, and transformation logic used as organizational reference standards Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
2Leadership9 statements
Emerging
  1. Task ownership — takes responsibility for assigned data extraction or transformation modules within a larger warehouse project without requiring constant supervision Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Peer contribution — shares observations about data quality issues with team leads to support collective troubleshooting efforts Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Developing
  1. Project initiative — leads discrete data mapping workstreams between source systems and data marts, coordinating with adjacent teams to meet delivery milestones Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Junior mentoring — guides entry-level analysts through ETL process models and data warehouse conventions, reinforcing organizational standards Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Applying
  1. Warehouse program leadership — directs end-to-end design and implementation of warehouse database structures, assigning tasks and managing technical dependencies across team members Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Standards stewardship — leads development and enforcement of data warehouse design standards, including data architectures, models, and naming conventions, across the engineering organization Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Troubleshooting coordination — takes ownership of escalated warehouse incidents, organizing cross-functional response teams and driving resolution to completion Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Exceeding
  1. Data platform vision — defines long-term data warehouse architecture strategy, aligning engineering roadmaps with organizational data governance and analytics objectives Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Organizational capability building — establishes mentorship programs and technical communities of practice focused on data warehousing excellence, elevating team-wide proficiency Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
3Metacognition8 statements
Emerging
  1. Learning reflection — identifies personal gaps in SQL or ETL tooling knowledge after encountering unfamiliar warehouse technologies and seeks targeted resources to close them Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Task monitoring — checks own data mapping outputs against source system specifications before submission to identify self-introduced errors Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Developing
  1. Approach evaluation — reflects on chosen data extraction strategies after implementation, assessing whether alternative loading or transformation patterns would have improved performance Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Skill gap planning — creates a structured learning plan to develop proficiency in a new programming language or warehouse platform required for an upcoming project Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Applying
  1. Design retrospection — systematically reviews completed warehouse schema designs to identify architectural decisions that introduced technical debt and adjusts future modeling approaches accordingly Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Problem-solving awareness — recognizes when a familiar ETL troubleshooting approach is insufficient for a novel data quality issue and deliberately shifts analytical strategy Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Exceeding
  1. Cognitive strategy modeling — articulates personal frameworks for warehouse problem decomposition and shares metacognitive strategies with junior specialists to accelerate their technical reasoning development Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Continuous methodology refinement — evaluates the effectiveness of personal and team-level data engineering practices over time, instituting iterative improvements to design and delivery processes Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
4Critical Thinking9 statements
Emerging
  1. Data quality inspection — applies defined validation rules to verify the structure and accuracy of incoming warehouse data, flagging anomalies for review Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Assumption identification — questions whether source system field definitions align with target warehouse schema requirements before beginning a mapping exercise Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Developing
  1. Root cause analysis — investigates failed ETL loads by tracing data lineage across source, transformation, and target layers to isolate the point of failure Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Requirements evaluation — critically assesses customer-provided specifications for data extraction procedures, identifying ambiguities or conflicts before development begins Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Architecture trade-off analysis — evaluates competing warehouse database structure options by weighing query performance, scalability, storage cost, and maintenance complexity before recommending a design Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Data model validation — systematically verifies that process models for sourcing, loading, transformation, and extraction satisfy both technical constraints and business reporting requirements Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Systems impact assessment — analyzes how modifications to source administration, billing, or claims systems will propagate through existing extraction procedures and affect downstream data integrity Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Exceeding
  1. Enterprise logic evaluation — challenges organizational assumptions about data architecture patterns, introducing evidence-based arguments for adopting superior modeling paradigms such as data vault or lakehouse approaches Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Complex problem synthesis — integrates findings from performance profiling, data quality audits, and stakeholder feedback to diagnose systemic warehouse issues and prescribe multi-layered remediation strategies Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
5Collaboration9 statements
Emerging
  1. Cross-team coordination — participates in data mapping sessions with source system owners and warehouse engineers, contributing assigned field-level analysis without disrupting group workflow Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Feedback receptivity — incorporates code review comments on ETL scripts from senior developers into revised program versions Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Developing
  1. Source system partnership — collaborates with administration, billing, and claims system teams to gather extraction requirements and validate data definitions across organizational boundaries Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Joint troubleshooting — works alongside database administrators and BI analysts to diagnose warehouse performance degradation, integrating perspectives from multiple technical domains Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Integrated delivery collaboration — coordinates with data architects, business analysts, and DevOps engineers throughout the full warehouse development lifecycle to ensure cohesive design and timely deployment Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Standards co-creation — facilitates cross-functional working groups to establish shared data warehouse nomenclature and structural conventions accepted by all stakeholder teams Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Diverse perspective navigation — reconciles competing stakeholder priorities around data mart design by synthesizing technical constraints with business logic requirements Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Exceeding
  1. Ecosystem orchestration — leads collaboration across enterprise data governance councils, engineering guilds, and business units to align warehouse investments with strategic data platform objectives Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Conflict mediation — resolves deeply divergent perspectives on data ownership or schema design decisions by facilitating structured technical debate grounded in evidence and shared organizational goals Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
6Character9 statements
Emerging
  1. Data stewardship honesty — accurately reports data quality verification results, including unfavorable findings, without omitting anomalies to simplify delivery Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Deadline accountability — communicates proactively when an assigned ETL development task is at risk of missing its scheduled completion Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Developing
  1. Standards adherence — consistently applies established data warehouse design standards to all development work, including personal projects where deviations would be undetected Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Confidentiality responsibility — handles sensitive source data from billing or claims systems with strict adherence to data privacy policies throughout extraction and loading processes Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Professional integrity — documents all data transformation logic and mapping decisions transparently, ensuring audit trails reflect actual implementation rather than idealized design Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Ethical data handling — refuses to implement extraction procedures that would circumvent data governance controls, escalating concerns through appropriate channels Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  3. Ownership modeling — accepts full accountability for warehouse incidents traced to personally developed code, leading remediation without deflecting responsibility Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Exceeding
  1. Governance advocacy — champions ethical data management practices and organizational accountability standards, influencing engineering culture beyond immediate project responsibilities Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Institutional trustworthiness — builds a sustained reputation for reliability and transparency in warehouse delivery, making personal commitments on project quality that the broader organization relies upon Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
7Creativity9 statements
Emerging
  1. Novel query exploration — experiments with alternative SQL approaches or warehouse functions to solve a data transformation challenge beyond the prescribed method Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Prototype initiative — sketches an exploratory data model concept for a new reporting requirement before formal design sessions begin Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Developing
  1. Innovative extraction design — devises a custom extraction procedure for a non-standard source system that lacks native warehouse connectors, delivering a reusable integration pattern Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Process improvement ideation — proposes a redesigned ETL pipeline architecture that reduces load times by eliminating redundant staging transformations Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Architecture innovation — designs a warehouse process model that introduces a novel sourcing and loading pattern to accommodate real-time data ingestion requirements not covered by existing standards Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Tool adaptation — repurposes existing programming frameworks creatively to meet unusual customer data requirements, delivering solutions outside conventional warehouse tooling patterns Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Data mart reimagining — conceives an unconventional data mart structure that resolves long-standing query performance bottlenecks while preserving backward compatibility Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Exceeding
  1. Platform innovation leadership — pioneers adoption of emerging warehouse paradigms such as streaming ingestion or semantic layer abstraction, translating experimental concepts into production-grade organizational capabilities Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Creative standards evolution — leads redesign of enterprise data architecture standards to incorporate inventive modeling approaches that position the organization for future analytics demands Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
8Growth Mindset9 statements
Emerging
  1. Technology curiosity — voluntarily explores documentation for an unfamiliar ETL tool or warehouse platform encountered on a new project assignment Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Feedback utilization — applies corrective feedback from warehouse design reviews to improve subsequent data mapping submissions Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Developing
  1. Skill stretch acceptance — takes on a warehouse programming task in an unfamiliar language, treating the challenge as a deliberate learning opportunity rather than a risk Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Setback reframing — analyzes a failed data load incident as a technical learning event, extracting lessons that improve future extraction procedure design Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Continuous platform learning — proactively develops proficiency in evolving cloud warehouse technologies and updated programming paradigms to maintain relevance across project generations Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Effort-mastery connection — pursues iterative performance tuning of warehouse queries with sustained effort, recognizing that expertise in optimization emerges through deliberate practice Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Challenge seeking — volunteers for complex data integration projects involving legacy source systems, viewing the difficulty as an accelerant for technical growth Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Exceeding
  1. Learning culture cultivation — institutionalizes growth mindset practices within the data engineering team by establishing blameless post-mortems, skill-sharing sessions, and experimental project allocations Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Adaptive mastery modeling — publicly documents personal learning journeys through new warehouse technologies, normalizing vulnerability and effort as components of expert-level development Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
9Mindfulness9 statements
Emerging
  1. Attention management — applies focused concentration during data quality verification tasks to reduce error rates from distraction-induced oversights Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Emotional regulation — maintains composure when receiving critical feedback on warehouse schema designs during peer review sessions Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Developing
  1. Intentional troubleshooting — approaches warehouse incident diagnosis with deliberate, step-by-step attention rather than reactive assumption-based fixes, reducing resolution time Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Stress awareness — recognizes personal cognitive load signals during high-pressure data migration deadlines and applies structured breaks to sustain analytical quality Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Applying
  1. Present-moment debugging — maintains focused attention on live extraction procedure failures, resisting cognitive shortcuts that introduce confirmatory bias into root cause analysis Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Considerate stakeholder engagement — brings full attentive presence to requirements-gathering sessions, detecting subtle contradictions in business user descriptions of data needs Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Emotional intelligence in conflict — regulates personal reactions during disagreements about data architecture decisions, keeping technical discussions productive and solution-focused Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Exceeding
  1. Team mindfulness modeling — demonstrates and teaches intentional, distraction-free technical review practices that elevate collective code quality and reduce warehouse defect rates across the engineering team Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Strategic clarity under pressure — maintains calm, deliberate decision-making during critical warehouse outages affecting enterprise operations, providing steady leadership that stabilizes team response Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
10Fortitude9 statements
Emerging
  1. Persistence through complexity — continues working through a multi-layered data mapping problem without escalating prematurely, exhausting available debugging resources first Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Ambiguity tolerance — proceeds with warehouse design work when source system specifications are incomplete, making documented assumptions and flagging them for stakeholder validation Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Developing
  1. Deadline resilience — sustains development quality on ETL pipeline builds during compressed project timelines, managing fatigue without sacrificing data integrity standards Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Technical setback recovery — rebuilds a warehouse extraction procedure from scratch after discovering that an existing approach is fundamentally incompatible with a new source system architecture Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Applying
  1. Sustained troubleshooting endurance — perseveres through extended, high-stakes warehouse outage investigations spanning multiple system layers without abandoning methodical diagnostic discipline Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  2. Organizational friction navigation — advances necessary but contested data warehouse standards revisions despite stakeholder resistance, maintaining professional persistence grounded in technical evidence Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab. O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
  3. Uncertainty courage — recommends an unproven architectural approach for a critical warehouse redesign when evidence supports it, accepting personal accountability for the outcome Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Exceeding
  1. Adversity leadership — guides the data engineering team through prolonged enterprise data migration crises, sustaining team morale and technical focus across weeks of sustained difficulty Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
  2. Courageous advocacy — challenges established but technically inadequate warehouse practices at the organizational level, accepting resistance and uncertainty in pursuit of long-term platform health Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.
Sources:Pathsmith Durable SkillsPathsmith Durable Skills Framework — America Succeeds + CompTIA. Opens in new tab.O*NET v30.2O*NET Resource Center — Occupational Information Network, v30.2 (Sept 2025). Opens in new tab.
Show O*NET source anchors52 anchors · skillscrosswalk.com

O*NET enrichment · skillscrosswalk.com

Suggest an O*NET correction

Source anchors that ground each statement

Related titles
Analytics Manager · Big Data Engineer · Data Integrity Specialist · Data Management Engineer · Data Management Manager · Data Management Specialist · Data Migration Specialist · Data Quality Analyst · Data Specialist · Data Storage Specialist · Data Warehouse Analyst · Data Warehouse Developer
RAPIDS apprenticeships
—
O*NET skills
Reading ComprehensionCritical ThinkingProgrammingComplex Problem SolvingSystems AnalysisActive ListeningJudgment and Decision MakingSpeakingSystems EvaluationWritingCoordinationMathematicsActive LearningSocial Perceptiveness
Knowledge domains
Computers and ElectronicsMathematicsEnglish LanguageDesign
Abilities
Written ComprehensionInformation OrderingDeductive ReasoningInductive ReasoningOral ComprehensionNear VisionSpeech RecognitionCategory FlexibilityOral ExpressionWritten Expression
Work styles
Attention to DetailDependabilityIntellectual CuriosityCautiousnessIntegrityAchievement Orientation
Technology
Metadata management softwareDevelopment environment softwareObject or component oriented development softwareData base management system softwareData base user interface and query softwareStorage networking softwareInformation retrieval or search softwarePortal server softwareFile versioning softwareOperating system software
Tasks · seed anchors for statements
  1. Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  2. Verify the structure, accuracy, or quality of warehouse data.
  3. Map data between source systems, data warehouses, and data marts.
  4. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
  5. Design and implement warehouse database structures.
  6. Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
  7. Provide or coordinate troubleshooting support for data warehouses.
  8. Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
CIP education codes
11.010111.010311.040111.050111.070111.080211.090211.100314.090114.090314.270130.700130.709952.1201

Sources: O*NET v30.2 (CC BY 4.0), SkillsCrosswalk.com, LER.me, Anthropic Economic Index, SAFI (Jadhav & Danve, 2026), WEF Skills Taxonomy 2021, Pathsmith Durable Skills Framework. © 2026 EBSCOed.