Analytics Engineer
Avante AI
Data Science
Seattle, WA, USA
Posted on Mar 19, 2025
About Avante
Avante is located in Seattle, WA, with an in-office culture requiring 4 days per week on-site. We're on a mission to transform how self-funded employers manage their benefits and HR operations. Our AI-powered B2B SaaS platform helps employers shift from reactive firefighting to strategic planning, while providing employees with the guidance they need to truly understand and maximize their benefits.
Employee benefits represent the second-largest expense for most businesses, yet the landscape is fragmented, complex, and difficult to navigate. Avante unifies fragmented benefits data and provides AI-driven insights that help employers control costs while delivering an exceptional employee experience.
The Role: Transform Complex Benefits Data into Actionable Insights
We're seeking a skilled Analytics Engineer to help us wrangle the diverse array of claims and benefits-related data streams we receive from customers. In this role, you'll be responsible for cleaning, transforming, and loading data into our existing schema, ensuring the highest possible level of accuracy. You'll work extensively with our DBT/SQL-centric data stack to transform raw healthcare data into reliable, consistent datasets that power our analytics and AI capabilities.
What You'll Do
- Transform raw claims data into standardized formats using DBT within our existing data infrastructure
- Apply data quality checks and validation to ensure accuracy and reliability of transformed data
- Orchestrate data pipelines using argo-workflows
- Support development of AI-powered BI solutions
- Ad-hoc exploratory data analysis (EDA)
- Create and maintain DBT models that accurately represent healthcare and benefits concepts
- Document data transformations, business logic, and data lineage for stakeholder transparency
- Optimize SQL queries and transformations for performance and scalability
- Occasionally contribute to infrastructure in Snowflake and Azure using Terraform
What We're Looking For
- Advanced SQL skills with ability to write complex, efficient, and maintainable queries
- Experience with DBT
- Strong data modeling fundamentals
- Ability to translate business questions into data models and transformations
- Proficiency with Python and dataframe libraries (Pandas, Polars) for data manipulation
- Knowledge of data testing methodologies to ensure data quality and accuracy
- Excellent analytical problem-solving skills and meticulous attention to detail
- Strong communication skills to collaborate with technical and non-technical stakeholders
Nice to Have
- Familiarity with columnar databases (Snowflake, Redshift, Clickhouse, etc.)
- Experience with CDC tooling (Airbyte, Fivetran)
- Background working in analytics, data science, AI/ML multidisciplinary teams
- Domain knowledge in medical, healthcare, or benefits sectors
- Experience working with claims data
- Infrastructure experience using Kubernetes and/or Azure
- Terraform experience
- Full-stack development experience
- Prior startup experience
Our (Data) Tech Stack
- DBT for transformation workflows and data modeling
- Snowflake for data warehousing
- Python for data manipulation (Pandas, Polars) and integration with our AI platform
- Data orchestration using argo-workflow DAGs
- Azure cloud infrastructure with kubernetes
Our Company Values
At Avante, our culture is defined by four core values:
Beat Yesterday: We're relentlessly committed to improvement, challenging ourselves to exceed our previous best and redefine what's possible. Every day is a fresh opportunity to innovate, grow, and push boundaries.
Embrace Type 2 Fun: We acknowledge that startup life is challenging, but deeply rewarding. We approach difficult moments with resilience, positivity, and empathy for our teammates, finding meaning and even joy in the climb.
Act Like an Owner: We take initiative beyond job descriptions, solving problems rather than just pointing them out. We navigate ambiguity by focusing on broader business goals and hold ourselves accountable with kindness and candor. Our commitment extends beyond shipping code—we own outcomes.
Stay Hungry, Stay Curious: We reject "that's how it's always been done" thinking in favor of radical innovation. We approach our mission with humility and endless curiosity, believing we can create meaningful impact. We ask the questions others are only thinking.
Interview Process
1. Initial screen with our recruiters
2. Phone screen with our head of engineering
3. On-Site Interview Loop
a. Technical interview focused on real-world problem solving (no whiteboard algorithms!)
b. Behavioral interview to explore your approach to teamwork and challenges
4. Final conversation with our CEO
If you're excited about solving complex data challenges in the benefits space while making a meaningful impact on businesses and their employees, we'd love to hear from you!