Lead Analytics Engineer

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 Staff Analytics Engineer you should have:

7+ years total experience as an Analytics Engineer, Data Engineer, or equivalent
6+ years creating project plans and related BI, Analytics, and Data project management materials (design documents, BI wireframes, ERDs, metrics catalogs, milestone plans)
6+ years building and implementing BI, Analytics, and Data solutions for business teams like Marketing, Sales, Product, Customer Success, and Finance
6+ years collaborating with 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 ETL tools like dbt and Airflow
4+ years building BI Dashboards
1+ years working in a Cloud Data Warehouse

What you’ll do:

Build the Analytics Engineering function, including technology selection, program structure, and dimensional model rollout and operations
Collaborate with business and technical team members to collect business requirements to deliver best-in-class dimensional data models to serve as single-source-of-truth for product, customer, and business analytics
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 Snowflake Data Warehouse
Define, develop, and enhance the dbt/SQL codebase and companion ERD documents 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 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.
The base salary range for a Staff Analytics Engineer is $170,000-$210,000 and will be eligible for equity and an annual performance based bonus.

‌