Job Description: Senior AWS Data Engineer, GA4 Silver/Gold Layer
Engagement type: Contract
Location: Remote, Eastern Time overlap required
Experience: 10+ years
Mission
Take raw GA4 clickstream data landing in Porter's S3 Bronze layer and build the flattened, domain-aligned silver and gold layers in Redshift that BI (Tableau, Power BI) and AI/RAG consumers will run against. Ship production tables, not prototypes.
What you will do
- Build transformation pipelines (Matillion, Python, or AWS Glue) that unpack nested GA4 struct and array fields into flat, queryable columns
- Design and deliver wide, denormalized, domain-aligned silver tables such as silver shopping and silver order, prioritizing BI query performance over normalization purity
- Layer Gold-tier aggregates on top of Silver for reporting and AI consumption
- Implement column-level PII controls in Lake Formation with distinct access classes for BI, AI, and Data Science
- Deploy late-binding views in Redshift as the consumption abstraction for Tableau and Power BI, keeping raw S3 partitions out of end-user reach
- Reconcile new GA4 data against Porter's existing legacy flyporter clickstream where it accelerates value
- Document lineage, grain, and refresh cadence for every table you land
- Partner with Troy on architectural decisions and hand off cleanly at end of engagement
Must-have experience
- 8+ years in data engineering with recent, hands-on production work on AWS (S3, Glue, Lake Formation, Redshift, Redshift Spectrum)
- Direct experience flattening GA4 (or GA360) BigQuery-style nested exports into columnar analytics tables
- Strong SQL and Python. Comfortable writing Glue jobs or Matillion transformations in production
- Redshift performance tuning: dist keys, sort keys, late-binding views, workload management
- Column-level security patterns in Lake Formation, and role-based access design across multiple consumer classes
- Modeling judgment for wide domain tables serving BI and AI/RAG, not just classical Kimball
Pay: $60.00-$68.00 per hour
Expected hours: 40.0 per week
Application question(s):
- Only Apply if you have experience on GA4 Silver/GA360 Silver/Gold Layer/Gold-tire ?
Work Location: Remote
