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 BI Team is at the center of Stellar Health’s analytics practice and has an outsized influence on the growth and success of the business. The BI 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 Asana and related status meters
As Senior Analytics Engineer you should have:
- 4+ years experience designing and implementing commercial Analytics Data Models, using Dimensional Modeling
- 4+ years total experience as an Analytics Engineer, Data Engineer, or equivalent
- 4+ years writing SQL with advanced level knowledge, including various join types, CTEs, partitioning, pivoting, and aggregates
- 2+ years creating project plans and related data-domain project management materials (design documents, BI wireframes, ERDs, metrics catalogs, milestone plans)
- 2+ years experience working collaboratively across business and engineering teams in areas like design reviews and code reviews to deliver scalable and high-quality output
- 2+ years experience working in source code management systems and code approval processes, ideally GitHub
- 2+ years building BI Dashboards (prefer Tableau or Looker)
- 1+ years defining and growing dbt best-practices including CI/CD practices, code promotion to production, dbt folder management, and code quality
- 1+ years working in the Snowflake Cloud Data Warehouse
- 1+ years working in an established and growing Snowflake/dbt environment with > 50 models, unit tests, Daily Build Job, linked to BI Dashboards
- Nice to Have: Experience in B2B, SaaS, or Gaming within the Healthtech or Medtech industries
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.
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 Stellar'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 $150,000-$190,000 and will be eligible for equity and an annual performance based bonus.
Perks & Benefits:
Stellar offers a carefully curated selection of wellness benefits and perks to our employees:
- Medical, Dental and Vision Benefits
- Unlimited PTO (and ask our recruiting team about the ways we make sure employees are actually taking PTO)
- Universal Paid Family Leave, with up to 21 weeks of fully paid leave available to new parents and caregivers
- 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 NoticeAt 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.
