Lead AI Data Engineer - Frisco

Role Overview

Join our eCommerce Operational Intelligence team as a Lead AI Data Engineer. You will build enterprise-scale data pipelines and analytics foundations (SQL, Spark/PySpark, ETL/ELT) that produce reliable operational insights and measurable business impact.

• Build and operate production ETL/ELT pipelines processing millions of eCommerce events daily and order trends.
• Write and tune complex SQL for operational analytics, KPIs, and reporting.
• Design analytics-ready schemas and data models for performance and scale.
• Troubleshoot pipelines, microservices, and APIs; apply observability to isolate root causes.
• Integrate data across eCommerce, Mar Tech, and operational systems into unified insights.
• Build AI-driven anomaly detection and notification.

• 10+ years building and architecting large-scale applications and distributed systems.
• 5+ years building production data pipelines, ETL/ELT workflows, and analytics platforms.
• Expertise in SQL (complex queries and performance tuning on large datasets).
• Experience with Spark/PySpark in production (Spark SQL, optimization).
• Strong Python skills (testing, packaging, modern development practices).
• ETL/ELT design: orchestration, scheduling, error handling, monitoring.
• Experience with Databricks/Delta Lake (Jobs/Workflows, Unity Catalog; Medallion patterns).
• Data modeling for analytics (dimensional models; star/snowflake schemas).
• Distributed systems fundamentals: microservices, APIs, event-driven patterns.
• Production troubleshooting and observability (logs, metrics, traces, alerting).
• Experience with AWS services (S3, Lambda, Glue, Kinesis, Open Search, Quick Sight, Cloud Watch).
• Familiarity with BI tools (Power BI, Tableau, Grafana).
• Experience with LLM/GenAI (RAG, vector DBs, Lang Chain, Bedrock).

• Flexible work hours and family-friendly benefits.
• Medical, dental, and vision coverage.
• Paid time off and parental leave.
• Support for community involvement.
• Bonus program and retirement plans.

We are serious about our commitment to diversity and inclusion. McAfee prohibits discrimination based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status. We provide reasonable accommodation to applicants and employees with disabilities. We value the unique perspectives offered by a diverse workforce.