13 days ago
Remote, United StatesMid Level / Senior
Base Salary
$135k - $145k/yr
Responsibilities
- Design and maintain scalable dbt data models in Snowflake as trusted sources of truth.
- Architect data pipelines and transformation workflows using Fivetran and modern ELT practices.
- Develop reusable, extensible data assets and establish modeling, documentation, and governance standards.
- Partner with RevOps and Finance to define and operationalize SaaS metrics including ARR, retention, expansion, and pipeline.
- Build data foundations for internal AI applications and prototype and productionize AI-driven operational use cases.
- Integrate analytics and AI into workflows using Notion, Cursor, Glean, and other emerging platforms.
- Create reusable data assets for activation through Hightouch and analysis through Omni.
- Collaborate with Sales, Customer Success, Marketing, Finance, Product, and Engineering to translate business needs into scalable technical systems.
- Ensure data architecture is scalable, secure, and adaptable to evolving enterprise requirements.
Requirements
- Require 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, including dimensional modeling, transformations, and data contracts.
- Experience building with cloud data warehouses such as Snowflake, BigQuery, or Redshift.
- Comfort working in a fast-moving and evolving AI tooling landscape.
- Ability to design scalable, extensible, and flexible systems and solve ambiguous problems.
- Strong communication skills and ability to collaborate across business and technical teams.
- Experience with listed tools is helpful but not required; strong fundamentals and ability to learn new technologies are valued more.
- Experience with Pendo, Amplitude, Heap, or Mixpanel is preferred.
Benefits
- Medical, vision, and dental benefits.
- 401(k), stock options, and HSA contribution.
- Learning stipend and flexible paid time off.
- Quarterly mental escape days and generous parental leave.
- Home office stipend, mobile phone reimbursement, and home internet reimbursement for remote employees.
- Anniversary and milestone celebrations.
Tech Stack
Categories
Data Engineering
About Ontic
Ontic builds subscription software for corporate and government security teams to identify threats, assess risk, and respond faster. Its AI-powered Connected Intelligence Platform unifies security operations and data into a centralized system of record to support executive protection, workplace violence prevention, threat intelligence, and corporate investigations. Fortune 500 companies and federal agencies use Ontic to manage threats and incidents across dispersed locations and programs.