Analytics Engineer

Posted Yesterday
Hiring Remotely in United States
Remote
95K-105K Annually
Mid level
Aerospace • Defense • Manufacturing
The Role
Design and maintain scalable dbt data models and ELT pipelines in Snowflake; architect reusable data assets, governance, and SaaS metrics; build AI-enabled data foundations and LLM workflows; integrate analytics into operational tools and partner cross-functionally to productionize AI-driven use cases.
Summary Generated by Built In

Who We Are

Ontic provides software that helps corporate and government security teams identify threats, assess risk, and respond faster to keep people and organizations safe. Its AI-powered Connected Intelligence Platform unifies security operations and data into a centralized system of record, enabling organizations to conduct risk assessments, protect against workplace violence, and manage threats and incidents more efficiently. Fortune 500 companies and federal agencies rely on Ontic to support security programs such as executive protection, threat intelligence, and corporate investigations. Learn more at ontic.ai or follow us on LinkedIn.

Who You Are
We are hiring a dedicated R&D Analytics Engineer to help build and scale the data and AI foundation of our enterprise SaaS business.

Reporting to the Sr. Director of AI & Analytics within our centralized Operations organization, this is a highly hands-on role focused on architecting scalable analytics systems and AI-enabled workflows that power decision-making across the company.

You will design the core data models, architecture, and reusable assets that serve Product, Engineering & Design — while helping redefine what an analytics function looks like in the age of AI.

This is a foundational hire with high ownership and long-term growth potential.
What You'll Do
1. Enterprise Data Modeling & Architecture

  • 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, etc.)

2. AI-Enabled Systems & Workflow Integration

  • Build data foundations that power internal AI applications and LLM-enabled workflows

  • Prototype and productionize AI-driven operational use cases

  • Integrate analytics and AI into everyday workflows using tools such as Notion, Cursor, Glean, and other emerging platforms

  • Design systems that embed data directly into operational processes — not just dashboards

3. Cross-Functional Analytics Infrastructure

  • Partner with leaders across Sales, CS, Marketing, Finance, Product, and Engineering to translate business needs into scalable technical systems

  • Create reusable data assets that enable activation via Hightouch and analysis via Omni

  • Ensure architecture is scalable, secure, and adaptable to evolving enterprise requirements

Our Stack

Analytics: Fivetran, dbt, Snowflake, Hightouch, Omni
AI & Knowledge Systems: Notion, Cursor, Glean

Experience with these tools is helpful but not required. Strong fundamentals and the ability to quickly learn new technologies matter more than prior tool exposure.

What We’re Looking For

  • Experience in analytics engineering, data engineering, or similar hands-on roles

  • Strong SQL skills and deep understanding of modern data modeling (dimensional modeling, transformations, data contracts, etc.)

  • Experience building in cloud data warehouses (Snowflake, BigQuery, Redshift, etc.)

  • Comfort working in a fast-moving, evolving AI tooling landscape

  • Systems-level thinker who designs for scalability, extensibility, and flexibility

  • Naturally curious and energized by solving ambiguous problems

  • Pride in building clean, durable architecture — not just shipping quick fixes

  • Strong communication skills and ability to collaborate across business and technical teams

Why This Role Matters

We are not building a traditional BI function.

We are building an AI-augmented analytics capability that:

  • Embeds data into operational workflows

  • Enables faster, smarter enterprise decision-making

  • Evolves as AI tooling evolves

  • Treats architecture as a strategic asset, not a back-office utility

You won’t just build dashboards — you will help shape how analytics and AI power our company over the next several years.


Ontic Benefits & Perks

Competitive Salary

Medical, Vision & Dental Benefits

401k

Stock Options

HSA Contribution

Learning Stipend

Flexible PTO Policy

Quarterly company ME (mental escape) days

Generous Parental Leave policy

Home Office Stipend

Mobile Phone Reimbursement

Home Internet Reimbursement for Remote Employees

Anniversary & Milestone Celebrations

Ontic is an equal-opportunity employer. We are committed to a work environment that celebrates diversity. We do not discriminate against any individual based on race, color, sex, national origin, age, religion, marital status, sexual orientation, gender identity, gender expression, military or veteran status, disability, or any factors protected by applicable law.

All Ontic employees are expected to understand and adhere to all Ontic Security and Privacy related policies in order to protect Ontic data and our clients data.

Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Ontic we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Ontic prioritizes the full inclusion of qualified individuals, providing necessary accommodations for those with disabilities to perform essential job functions. If you need assistance during the application or interview process or job tasks, please contact us at [email protected] or call (512) 572-7400

Skills Required

  • Experience in analytics engineering, data engineering, or similar hands-on roles
  • Strong SQL skills and deep understanding of modern data modeling (dimensional modeling, transformations, data contracts)
  • Experience building in cloud data warehouses (Snowflake, BigQuery, Redshift)
  • Comfort working in a fast-moving, evolving AI tooling landscape and building LLM-enabled workflows
  • Systems-level thinking; design for scalability, extensibility, and flexibility
  • Strong communication skills and ability to collaborate across business and technical teams
  • Experience with ELT tools and pipeline orchestration (Fivetran)
  • Experience with dbt and developing durable, extensible data models
  • Familiarity with activation and integration tools (Hightouch, Omni) and knowledge systems (Notion, Cursor, Glean)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
309 Employees
Year Founded: 2017

What We Do

Ontic is a leading global aerospace OEM and MRO services provider, specializing in supporting and supplying established aircraft parts for the defense and commercial markets. They are a trusted partner to aerospace leaders, giving the industry a new lease of life.

Similar Jobs

Coinbase Logo Coinbase

Analytics Engineer

Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Easy Apply
Remote
USA
4700 Employees
207K-244K Annually

Arcadia Logo Arcadia

Analytics Engineer

Big Data • Fitness • Healthtech • Information Technology • Software • Analytics
Remote
USA
360 Employees
175K-200K Annually

Arcadia Logo Arcadia

Analytics Engineer

Big Data • Fitness • Healthtech • Information Technology • Software • Analytics
Remote
USA
360 Employees
160K-185K Annually
Remote
United States
556 Employees
95K-95K Annually

Similar Companies Hiring

Rosendin Thumbnail
Other • Manufacturing
San Jose, CA
6219 Employees
Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees
Outpost Space Thumbnail
Aerospace • Defense
US
24 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account