Senior Data Engineer (1127880)

The Judge Group is seeking a Senior Data Engineer to lead the design, build, and operation of a modern analytics platform. This role involves directing teams of AI developer agents through the analytics lifecycle and ensuring the integrity and quality of data across multiple systems.

Responsibilities:

• Direct teams of AI developer agents across the full analytics lifecycle, from requirements and data model design through production deployment
• Use structured agent methodologies (such as BMad‑method or equivalent) to coordinate analyst, architect, and developer agents
• Critically evaluate AI‑generated output, including: Identifying DRY violations in pipeline code, Rejecting data models that violate normalization or dimensional modeling principles, Ensuring tests validate specifications rather than implementations
• Provide clear corrective guidance to agents when output violates sound engineering or data principles
• Own CI/CD pipelines for all analytics platform components, including automated testing, deployment, and observability
• Design and implement ELT/ETL pipelines ingesting data from: NetSuite (via NSAW and SuiteQL), Legacy SQL Server, Custom AWS‑hosted eCommerce databases, Google Ads, Meta Ads, FedEx, and Braze
• Stand up and operate the analytics infrastructure, including: Columnar analytics database (ClickHouse on AWS), Object storage for staging (Amazon S3), Ingestion tooling (Airbyte or similar), BI and reporting layer (Metabase)
• Activate and configure NetSuite Analytics Warehouse (NSAW) as a fast‑start layer and build complementary SuiteQL‑based pipelines
• Design and own the canonical data model, including cross‑system product keys bridging legacy and ERP systems
• Deliver priority business reports, including: 12‑month product history spanning multiple systems, Sales by representative, Marketing analytics such as CAC, ROAS, funnel performance, and LTV by channel
• Define and enforce data quality standards and escalation processes to ensure business trust in analytics

Requirements:

• Extensive hands‑on experience designing, building, and operating ELT/ETL pipelines using tools such as Airbyte, Fivetran, dbt, or similar open‑source solutions
• Production experience with columnar analytics databases such as ClickHouse, Redshift, BigQuery, or Snowflake
• Working knowledge of AWS services, including S3, EC2 or ECS, IAM, and VPC networking
• Expert‑level SQL skills for data modeling, transformation, and query optimization
• Demonstrated experience directing teams of AI developer agents for data engineering work across analysis, design, implementation, and deployment
• Proven ability to critically evaluate AI‑generated output and correct flawed designs or implementations
• Experience designing end‑to‑end analytics platforms serving broad business needs rather than isolated reporting use cases
• Portfolio demonstrating data platform work built using AI agent teams (required for consideration)
• Based in Texas with authorization to work in the United States
• Hands‑on experience with NetSuite Analytics Warehouse (NSAW), including activation, configuration, and model navigation
• Experience ingesting data from advertising platforms such as Google Ads and Meta Ads
• Familiarity with marketing automation platforms such as Braze, Klaviyo, or similar tools
• Experience with eCommerce, retail, or distribution data models
• Experience using dbt for transformations, lineage, and data testing
• Prior work unifying analytics across ERP systems, custom web platforms, and third‑party SaaS tools