Senior Analytics Engineer

About Stellar Health:

Historically, US Healthcare has relied on a fee-for-service reimbursement system where providers are paid based on the quantity of patient visits and procedures, rather than the quality of health outcomes. 

At Stellar Health, we help primary care providers put patient health first. Our platform - a mix of technology, people, and analytics - supports providers at the point of care, delivering real-time patient information, activating practice staff, and empowering providers and care teams with incentives that reward the work they are already doing to keep patients healthy. Using the Stellar App, our web-based, point-of-care tool; practices receive a simple checklist of recommended actions that support the best quality care. Providers and care teams are then paid monthly for each action they complete, and Payors save money in reduced healthcare costs along the way.  

Stellar is a US-based Health-tech backed by Top VCs (General Atlantic, Point72, & Primary Venture Partners)​​ with an established product & proven operating model. We’ve shown that we make a real difference for physician practices and their patients. Our product began 2022 supporting over 500k patient lives; we’re currently at 750k and are fast tracking towards our milestone goal of 1M.  We’re actively hiring and scaling our business to support Stellar’s continued growth and impact on our healthcare system. It's an exciting time to join the team!

About the position:

Stellar Health’s BI Team is at the center of analytics and has an oversized influence on the growth and success of the business. The BI Team is standing up a brand new Analytics Engineering function to accelerate analytics innovation and performance for all teams. As the founding member of Analytics Engineering, the successful candidate will have the opportunity to create a new program and platform, along with the incredible opportunity to  advance the state of healthcare in the United States through data.

As Senior Analytics Engineer you should have:

• 6+ years total experience as an Analytics Engineer, Data Engineer, or equivalent.
• 6+ years creating project plans and related data-domain project management materials (design documents, BI wireframes, ERDs, metrics catalogs, milestone plans).
• 6+ years experience working collaboratively across business and engineering teams to deliver scalable BI solutions.
• 6+ years collaborating marketing, sales, product, people or equivalent cross functional collaboration experience.
• 5+ years writing SQL with advanced level knowledge, including various  join types, CTEs, partitioning, pivoting, and aggregates.
• 4+ years experience designing and implementing commercial Analytics Data Models, preferably using Kimball Dimensional Modeling.
• 4+ years experience creating automated data processing pipelines using tools like Airflow.
• 4+ years building BI Dashboards
• 1+ years working in a Cloud Data Warehouse

What you’ll do:

• Collaborate with team members across Stellar Health to collect business requirements, define successful analytics outcomes, design data models, implement data models, and automated data refreshes
• Design and deliver new analytics data models and schema, primarily using the industry-standard Kimball Dimensional Modeling framework
• Serve as the Lead/Primary point of contact for the Analytics Warehouse
• Define, develop, and enhance the dbt codebase used to bring the Analytics Warehouse to life
• Keep documentation up-to-date in Notion, Docs, and other knowledge bases
• Advocate for Analytics best practices 
• Keep the team and others up-to-date on plans and progress with Asana and related status meters
• Develop code that establishes the benchmark for best practices in a high-scale data environment
• Work with team members to review and approve code and other software artifacts

Who will love this job:

BI & Analytics at Stellar Health is just getting started! Though we’re starting with a stable technology stack and a great baseline of descriptive metrics and dashboards, there remains incredible room to grow and make an impact in our business, across our teams, and out to our customers. If you want to leverage your deep analytics technology and delivery experience to create brand new scalable analytics solutions “the right way” from scratch, this is your place. There is no existing dbt codebase in place or dimensional model in place. You get to create and own it!

Pay:

At Stellar, we believe in transparency and we do our best to make sure the company and our candidates are on the same page as it relates to compensation. In addition to posting salary ranges for our open roles, candidates should expect to be asked about compensation expectations and requirements early on in their interview process. Our goal is to highlight when expectations and Steller's salary range may be out of sync, and work with the candidate to determine whether it makes sense to continue conversations.

Where a new hire falls within this range will be based on their individual skills and experience, and how these competencies compare across other employees in the same role. Stellar's bands are designed to allow for individual compensation growth within the role.  As such, new hires typically start at the lower end of the range.  Stellar rewards performance and outcomes - should you join the company, you will have the opportunity to grow your salary over time.

• The base salary range for a Senior Analytics Engineer is $140,000-$170,000 and will be eligible for equity and an annual performance based bonus.
• The base salary range for a Staff Analytics Engineer is $160,000-$190,000 and will be eligible for equity and an annual performance based bonus.