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.

About the position:

The Enterprise Analytics team is looking for a new member of the team to help build scalable and durable data models with Snowflake and dbt to help power self-service for all teams, primarily focusing on Customer Success and Product. The successful candidate will help scale Stellar as a whole, work with a modern data technology stack, work with healthcare Big Data, and have the opportunity to advance the quality of healthcare in the United States.

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 with dbt, primarily designed using dimensional modeling
• Define, develop, and enhance the dbt codebase used to bring the Analytics Warehouse to life
• Develop code that establishes the benchmark for best practices in a high-scale data environment, including source code management, unit testing, CI/CD, and peer code reviews
• Work with team members to review and approve code and other software artifacts
• 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 Jira and related status meters

As Senior Analytics Engineer you should have:

• Deep Analytics Experience: 8+ years total experience as an Analytics Engineer, Data Engineer, or equivalent. DBT Experience is a must.
• Expert level SQL: 6+ years writing SQL with advanced level knowledge, including various  join types, CTEs, partitioning, pivoting, and aggregates
• Expert Dimensional Modeling: 4+ years experience designing and implementing commercial Analytics Data Models, preferably using Kimball Dimensional Modeling
• Expert Data Process Management: 4+ years experience creating automated data processing pipelines using tools like Airflow
• Full-stack experience: We are looking for a candidate that has an interest in fully owning data development - from interacting with the Business Partners to articulate needs, to developing some Tableau Dashboards to lay out the output of their work. 
• Leadership: Clear technical lead, able to communicate clearly and efficiency, with crisp delivery of ideas and concepts
• Collaboration: Ability to establish good rapport immediately
• Curiosity: Asks excellent questions about the team and Stellar

Who will love this job:

Enterprise 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 enjoy combining your deep analytics technology and delivery experience with a curiosity in understanding the business and building metrics and data products that have outsized impact because they support consequential decision making, this is your place. 

Pay:

The salary range for a Senior Analytics Engineer is $150,000-$190,000 and will be eligible for equity and an annual performance based bonus.  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.

Stellar reserves the right to change our compensation bands at any time.

Perks & Benefits:

Stellar offers a carefully curated selection of wellness benefits and perks to our employees:

• Medical, Dental and Vision Benefits
• Unlimited PTO
• Universal Paid Family Leave
• Company sponsored One Medical memberships and Citibike memberships
• Medical Travel Benefits 
• A monthly wellness stipend that gives employees the freedom to choose where they spend their cash, whether it be on wellness, pet care, childcare, WFH items, or charitable donations
• Stock Options & a 401k matching program
• Career development opportunities like Manager Training, coaching, and an internal mobility program
• A broad calendar of company sponsored social events that for our in-office and remote employees

Diversity is the key to our success. Stellar Health is an equal opportunity employer and we are open to all qualified applicants regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, veteran status, or any other legally protected status.  

We believe that diverse teams -and the different identities, cultures, and life experiences our team members bring to the table- enable us to create amazing products, find creative solutions to interesting problems, and build an inclusive working environment. 

Stellar Health Employment Privacy Notice

At Stellar Health, your privacy and security as a job seeker is a priority no matter where you are in the interview process. As recruiting scams have become more prevalent, please take note of the following practices to ensure the legitimacy of any interaction with our team. 

• Please note that any communication from our recruiters and hiring managers at Stellar Health about a job opportunity will only be made by a Stellar Health employee with an @stellar.health email address. 
• Stellar Health does not utilize third-party agencies for recruitment services and does not conduct text message or chat-based interviews. Any other email addresses, agencies, or forums may be phishing scams designed to obtain your personal information. 
• We will not ask you to provide personal or financial information, including, but not limited to, your social security number, online account passwords, credit card numbers, passport information, and other related banking information until we begin onboarding activities, which will be coordinated by a member of the Stellar Health People Ops Team with an @stellar.health email address.  

If you are ever unsure whether you are in contact with a legitimate Stellar Health teammate, please contact people-team@stellar.health. If you believe you've been a victim of a phishing attack, please mark the communication as “spam” and immediately report it by contacting the U.S. Federal Trade Commission.