Location: Mesquite, TX
Salary: $120,000.00 USD Annually - $150,000.00 USD Annually
Description
Job Summary
We are building a modern analytics platform from the ground up and are seeking a hands‑on Senior Analytics Engineer to lead its design, build, and operation. Data is currently fragmented across multiple systems—including ERP, eCommerce, marketing platforms, logistics providers, and legacy databases—with no unified analytical layer.
In this role, you will serve as the technical owner of the analytics platform, making foundational architectural decisions, owning pipelines end‑to‑end, and enabling business decisions that have not previously been possible. You will work closely with an experienced data professional and a small team of generalist engineers.
This is an AI‑agent‑first role. You will direct teams of AI developer agents throughout analysis, data modeling, pipeline implementation, and deployment. AI is a force multiplier and execution partner; you provide vision, judgment, and technical leadership.
Key ResponsibilitiesAI‑Led Platform Development
- 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
Analytics Platform Build and Operations
- 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
Minimum Qualifications
- 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
Preferred Qualifications
- 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
Working Style & Attributes
- Leads AI agents with the same rigor applied to human engineering teams
- Designs analytics systems with a holistic, architectural mindset
- Proactively identifies and explains violations of data modeling or engineering principles
- Asks thoughtful questions before execution to ensure high‑quality inputs and outputs
- Documents architectural decisions clearly to support long‑term maintainability
- Works effectively in a distributed environment with strong communication and accountability
- Energized by greenfield work and building foun