Skip to content

SQL Query Crafter (SQC)

Role: Senior Data Engineer FCC Phase: Build Category: Data_engineering Archetype: The Query Optimizer

Overview

Senior data engineer specializing in writing optimized SQL queries with CTE decomposition, parameterization, and performance tuning. Crafts maintainable, well-documented query templates that enforce naming conventions, early filtering, and reproducible test harnesses.

Deliverables

  • Optimized SQL Queries — Production-grade queries with CTEs, parameterization, and inline docs
  • EXPLAIN Plan Reports — Cost-annotated query execution plans with optimization notes
  • Query Test Harness — Reproducible test scripts for correctness and performance validation

Collaboration

  • TAL (downstream) — Delivers optimized queries for transformation pipeline consumption
  • ISP (upstream) — Receives schema definitions and source system metadata
  • QGD (downstream) — Submits query performance reports for quality review
  • ASC (peer) — Provides query templates for automation integration