Analytics Engineer: AI-Powered Data Platform Architect

Ontic; Oregon; Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Competitive Salary

Medical, Vision & Dental Benefits

401k

Stock Options

HSA Contribution

Learning Stipend

Flexible PTO Policy

Home Office Stipend

Mobile Phone Reimbursement

Home Internet Reimbursement

Job summary

Ontic is seeking an Analytics Engineer to build and scale the data and AI foundation for an enterprise SaaS platform. You will architect scalable analytics systems, design core data models, and create reusable assets serving Product, Engineering, and Design.

You’ll own data pipelines and governance as the organization grows. You will collaborate with RevOps, Finance, Sales, CS, Marketing, and Engineering to define SaaS metrics and power AI‑driven workflows.

Qualifications

• 3–6 years of experience in analytics engineering, data engineering, or similar hands‑on roles.
• Strong SQL skills and deep understanding of modern data modeling.
• Experience building in cloud data warehouses (Snowflake, BigQuery, Redshift).
• Comfort working in a fast‑moving AI tooling landscape.
• Systems‑level thinker focused on scalability and data contracts.

Responsibilities

• Design and maintain scalable dbt data models in Snowflake that serve as trusted sources of truth across the business.
• Architect data pipelines and transformation workflows using Fivetran and modern ELT practices.
• Develop durable, extensible data assets that evolve as the company scales.
• Establish modeling standards, documentation practices, and governance frameworks.
• Partner with RevOps and Finance to define and operationalize core SaaS metrics (ARR, retention, expansion, pipeline).

Skills

SQL

Data modeling

Cloud data warehousing

Communication

Problem solving

Tools

Snowflake

BigQuery

Redshift

Fivetran

dbt

Notion

Cursor

Glean

Hightouch

OmniAI

Job description

Ontic is seeking an Analytics Engineer to build and scale the data and AI foundation for an enterprise SaaS platform. You will architect scalable analytics systems, design core data models, and create reusable assets serving Product, Engineering, and Design.

You’ll own data pipelines and governance as the organization grows. You will collaborate with RevOps, Finance, Sales, CS, Marketing, and Engineering to define SaaS metrics and power AI‑driven workflows.