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
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 (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
Nice to have: Experience with Pendo, Amplitude, Heap, or Mixpanel
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 recruitment@ontic.co or call (512) 572-7400
