Senior Analytics Engineer
Color
How You'll Contribute:
- Build foundational data models that help Color demonstrate program value to employers and prospective clients.
- Translate business needs and source data into robust, scalable models that power accurate, insightful analysis.
- Collaborate across Product, Engineering, Operations, GTM, Clinical, and Client teams — clarifying ambiguity and balancing scope vs. impact to deliver meaningful solutions.
- Define and maintain business logic in dbt, keeping the warehouse aligned with evolving products, data, and business needs.
- Create self-service data layers that speak the language of business users, enabling intuitive, independent exploration.
- Partner with BI and analytics teams to align on metrics and ensure consistency and trust across dashboards.
- Identify recurring patterns and build reusable solutions that reduce ad hoc work and improve scalability.
- Use emerging AI and automation tools to streamline analytics workflows and boost team efficiency.
- Contribute to a culture of data-driven decision-making by mentoring peers and sharing best practices in analytics engineering.
Must-Haves
- 5+ years of experience using data to drive product growth and operational efficiency.
- 5+ years of experience as an analytics engineer or in a similar role..
- Advanced proficiency in SQL, data model design, and data warehouse platforms..
- Working knowledge of Python and data science tools.
- Deep interest in the modern data stack.
- Excellent communication skills and ability to work with technical and non-technical partners from many teams, especially in exploring decisions and trade-offs.
- Experience driving complex projects from design to completion.
- Commitment to software engineering best practices and applying them in an analytics setting.
- A strong desire to work at the intersection of healthcare and technology, driven by the opportunity to make preventive care more accessible and equitable.
- A strong desire to adapt to new emerging technology and AI tools to scale the output of the team.
Nice to Have:
- dbt, BigQuery, Fivetran, Airflow, Git
- Analytics & BI tools like Omni or Metabase
- Large amounts of healthcare or genomic data
- Automating manual processes with data solutions
- Conforming disparate data sources to a common model
- Crafting self-service data resources
- Helping teams adopt AI tools and workflows
Possible Projects to Contribute to:
- Expand self-service data models in collaboration with analysts to drive adoption and empower teams across Color. Today, more than half the company uses dashboards we’ve built, and over one-third of employees create their own analyses thanks to our robust self-service models — and we’re eager to grow this impact even further.
- Develop and enhance customer-facing data models that power the next generation of dashboards, giving clients visibility into program health (e.g., engagement rates, participation trends) and population outcomes (e.g., areas of vulnerability where Color can provide support).
- Build a conformed medical claims data model that unifies disparate sources, enabling consistent and accurate analysis of healthcare utilization and outcomes.
- Optimize data infrastructure performance and costs, ensuring our pipelines and warehouses are efficient, scalable, and reliable as our data volume and complexity grow.
What We Offer:
- 💰 Competitive salary
- ✨ Comprehensive medical, dental, vision, life, and disability benefits
- 📈 401k match
- 📝 Monthly phone and wifi stipend for employees, annual ergonomic stipend
- 🏝 Generous vacation policy, paid holidays and company-wide recharge days
- 🍼 Equal paid parental leave for birthing and non-birthing parents
- Free cancer screening and prevention resources for employees and their adult dependents