Senior Analytics Engineer & AI Developer

Fractal; California (MO); On-site; USD 125,000 - 165,000; Full time

Job summary

Fractal, a leading analytics partner for Fortune 500 companies, seeks a Senior Analytics Engineer & AI Developer to drive data foundations, AI-powered agents, and rigorous analytics across product growth and user engagement. You will lead data migrations, optimize schemas, and implement governance for scalable, trustworthy insights.

Join a high-ownership, client-facing role that blends Data Engineering, Business Analytics, and AI-native development to transform BI into an AI-augmented

Qualifications

• 5+ years in Data Engineering, Analytics Engineering, or Advanced BI.
• Expert-level SQL with partitioning, clustering, indexing, cost optimization.
• Designing star-schema/snowflake data marts and automated ETL pipelines.
• Proficient in Python (Pandas, PySpark) or R.
• Experience leading RCA analyses for core business metrics in consumer tech, ecommerce, or mobile apps.
• Independent execution on complex, end-to-end engineering migrations.

Responsibilities

• Design governed data foundations and unified semantic layers.
• Build production-grade conversational AI agents and LLM-assisted tools.
• Migrate data from legacy databases to optimized infrastructures with minimal downtime.
• Automate RCA frameworks to diagnose metric drivers and trends.
• Consolidate dashboards and reduce output table fragmentation.
• Implement AI-native skills and governance around data access and queries.

Skills

SQL proficiency

Data engineering

Python/PySpark

R

RCA analysis

Independent execution

Tools

BigQuery

Google Cloud

Job description

Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work® Institute and recognized as a 'Cool Vendor' and a 'Vendor to Watch' by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal

Note: This position is not eligible for Immigration Sponsorship at this time.

Position Overview:

As a Senior Analytics Engineer & AI Developer at Fractal Analytics, you will join our client facing teams at the cutting edge of data intelligence — operating at the intersection of Data Engineering, Business Analytics, and AI-Native Agent Development. Embedded within a world-class data science and analytics client organization at one of the most recognized technology companies on the planet, you will help lead the transformation of traditional business intelligence into a unified, AI-augmented ecosystem at a scale few engineers ever experience.

This is a senior, high-ownership role designed for engineers who thrive on independent execution. You will design governed data foundations, build production-grade conversational AI agents, and lead root cause analysis frameworks that shape the decisions of a global digital platform — influencing key business metrics across product growth, user loyalty, commerce, trust, and beyond.

Responsibilities Include:

Data Engineering & Platform Foundations

• Design and implement unified, governed semantic layers, robust data marts, and pre-aggregated data cubes to ensure high performance and data trustworthiness.
• Lead large-scale data migrations from legacy databases to optimized core infrastructure, ensuring seamless transitions, high quality, and zero production downtime.
• Aggressively optimize high-overhead schemas, reduce query execution runtimes, and minimize base table scans to control compute costs.
• Partner with Data Engineering teams to shift operations from reactive troubleshooting to proactive SLA management and automated pipeline monitoring.

Analytical Rigor & Advanced Root Cause Analysis

• Establish and automate structured, multi-dimensional Root Cause Analysis (RCA) frameworks to quickly diagnose quantitative drivers of metric changes (e.g., Spend, Buyers, Paying Users, Organic Traffic).
• Rationalize and consolidate fragmented dashboards and redundant output tables into highly performant, unified data stores.
• Develop and enforce data access practices that restrict ad-hoc queries to appropriate aggregation levels, preventing unnecessary resource bottlenecks.
• Design, test, and deploy specialized AI-native Skills and conversational Agents that enable stakeholders to ask complex business questions in natural language.
• Build and run offline evaluation test suites using command-line evaluation frameworks and LLM-assisted judges to prevent regressions in prompt updates before code is committed.
• Implement SQL safety gates within AI agents to dynamically enforce partition filters, column minimization, and query cost limitations.
• Champion modern AI development tools (e.g., Gemini Coder and unified coding agents) to maximize engineering velocity and maintain high-quality code.

Qualifications:

• 5+ years of experience in Data Engineering, Analytics Engineering, or Advanced Business Intelligence.
• Expert-level SQL proficiency (GoogleSQL, BigQuery, or equivalent large-scale query engines) with deep understanding of partitioning, clustering, indexing, and cost optimization.
• Proven experience designing performant star-schema or snowflake data marts, semantic layers, and automated ETL pipelines.
• Strong proficiency in Python (Pandas, PySpark, API integration) or R.
• Extensive experience leading structured Root Cause Analysis (RCA) and deep-dives for core business metrics in consumer tech, e-commerce, or mobile app platforms.
• Demonstrated track record of independent execution on complex, end-to-end engineering migrations.

Preferred Qualifications:

• Practical experience developing applications powered by Large Language Models (LLMs), Retrieval-Augmented Generation (RAG), or agentic frameworks.
• Familiarity with command-line agent evaluation frameworks, benchmark configuration (e.g., .txtpb formats), and LLM-assisted side-by-side evaluations.
• Experience establishing validation filters, safety gates, or guardrails for AI-generated database queries.
• Prior experience working with Google Cloud infrastructure, BigQuery, or Google-scale data platforms.
• Background in consumer tech, mobile apps, e-commerce, or digital marketplace analytics.

Pay:

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: $125,000 - $165,000. In addition, you may be eligible for a discretionary bonus for the current performance period.

As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time. You will be eligible for benefits on the first day of employment with the Company. In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms. The Company provides for 11 paid holidays and 12 weeks of Parental Leave. We also follow a "free time" PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.