Senior Analytics Engineer: Architect Data Foundation & AI

Pilot.com; San Francisco (CA); On-site; USD 166,000 - 224,000; Full time

Benefits offered by this job

Flexible vacation/time-off policy

Competitive benefits package

Parental leave – 100% pay for 12 weeks

Job summary

Pilot.com in San Francisco is looking for a Senior Analytics Engineer to own and architect the data foundation. You will lead the ingestion of new data sources and ensure the reliability of the data systems. Ideal candidates should possess over 5 years of relevant experience and strong SQL skills. This role also involves building AI workflows that enhance team efficiency. The base pay range is $166,000 - $224,000, with benefits including 401(k) and parental leave.

Qualifications

• 5+ years experience as an Analytics Engineer or Data Engineer with ownership of a production warehouse.
• Strong SQL and production dbt experience.
• Working Python proficiency for ingestion code.

Responsibilities

• Architect Pilot’s data foundation.
• Lead the ingestion of new data sources.
• Build AI tools and workflows for team support.

Skills

SQL

Data engineering

Production dbt

Python

AI workflow automation

Education

5+ years experience

Tools

Snowflake

Airflow

Fivetran

Looker

Job description

Pilot.com in San Francisco is looking for a Senior Analytics Engineer to own and architect the data foundation. You will lead the ingestion of new data sources and ensure the reliability of the data systems. Ideal candidates should possess over 5 years of relevant experience and strong SQL skills. This role also involves building AI workflows that enhance team efficiency. The base pay range is $166,000 - $224,000, with benefits including 401(k) and parental leave.