The company builds an all-in-one EHR platform for independent healthcare practices, and more than 42,000 private practices use it.
You will help build the company's new internal analytics platform so every team has numbers it can rely on.
You will own projects from start to finish, set the standards others build on, and work with business leaders to choose the metrics that matter most.
Responsibilities
Build and maintain company-wide business datasets with dimensional modeling and layered staging, intermediate, and mart models, so each piece of business logic is written once.
Work with Finance and other metric owners to define each key metric once, with a named owner and documented logic.
Publish governed metrics in a semantic layer that Tableau, AI assistants, and other tools query, and reconcile them with current reporting and the general ledger before teams switch over.
Lead each team's move to the new platform one domain at a time, with cutover and rollback plans, and onboard analysts to the new conventions, review processes, and tools.
Create easy-to-use datasets so non-technical colleagues and analysts can answer their own questions without complex joins.
Write automated tests and pull request checks that catch data issues before they reach reports, and handle scheduled job monitoring, failure fixes, and run recovery in shared production support.
Tune SQL, models, and pipeline schedules so data refreshes on time and dashboards load in seconds, and track compute usage and cost when choosing how each model is built and refreshed.
Prepare clean, documented datasets for analysts and data scientists building forecasting and machine learning models, such as retention and revenue projections.
Review code from analysts and engineers across teams and coach them on modeling, SQL, and testing.
Keep protected health information and personal data out of internal analytics, and maintain model documentation, lineage, and metric definitions in dbt, GitHub, Confluence, and Jira.
Requirements
5+ years in analytics engineering, data engineering, or a similar role, including 2+ years of hands-on dbt work in production.
Expert SQL, including window functions, CTEs, and tuning queries and pipelines on large datasets.
Deep knowledge of Kimball dimensional modeling, including shared datasets that serve many teams.
Proven experience with Snowflake or a similar cloud data warehouse, and with dbt.
Experience defining business metrics with Finance or business stakeholders and reconciling data to financial systems.
Experience with GitHub for version control and code review, automated builds such as GitHub Actions or similar, and Jira and Confluence for work tracking and documentation.
Clear communication with people who are not data specialists, and the ability to work with minimal supervision.
A drive to learn new technologies and develop new skills.
Bachelor's degree in computer science, statistics, economics, information systems, or a related field, or equivalent practical experience.
Preferred: experience with a semantic layer, such as Snowflake semantic views or the dbt Semantic Layer.
Preferred: experience with Salesforce, NetSuite, or Stripe data, and with subscription revenue, retention, or payments metrics.
Preferred: experience preparing data for forecasting or machine learning models.
Preferred: healthcare or HIPAA experience.
A plus: familiarity with Tableau, Terraform, or Okta.
Preferred: dbt Analytics Engineering or SnowPro certification.
Conditions
Remote role.
Pay band for Zone 1 (National Average) is $127,000 - $145,000 USD; your actual pay depends on experience, qualifications, role requirements, and geo zone, and the range for your zone is shared at the initial talent screen.
Geo zones are Zone 1 National Average, Zone 2 moderately higher cost regions, Zone 3 high-cost regions, and Zone 4 lower-cost regions.
Eligible for variable pay.
Equal opportunity employer: all applicants are considered without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status.
Phone and video screenings are recorded and transcribed with Greenhouse Notetaker, and applying means you accept that your interview may be recorded.
Benefits
United States: healthcare benefits, a discount on work-from-home basics through Dell, Gympass for fitness, and the Telus Employee Assistance Program for mental health and everyday support.
Costa Rica: a wellness and childcare subsidy, a university and education discount, Gympass for health and fitness apps, and the Telus Employee Assistance Program for mental health and everyday support.
A robust benefits package and eligibility for variable pay.
Where you’d work
Fully remote
You can work from
United States
About the company
Hidden companyCompany hidden
Industry: HealthTech
Good
Your chances
Still hiring, not crowded yet, and you'd be among the first.
17 checks run
7 good signs
0 red flags
Still hiring?
11 checks
Actively hiring
StaleHiring
In its favour3
Still on the company's own careers site, checked 1 h agoModerate evidence
Found in the last 48 hours, before the big job boardsModerate evidence
A tight salary range, set for one seat: $125K to $145KSlight evidence
How crowded?
6 checks
Low
QuietCrowded
In its favour4
In its Early Window: not on the big job boards yetStrong evidence
Remote within United States onlySlight evidence
Senior level: far fewer people qualifySlight evidence
1 moreFewer
Asks for dbt, which only 1% of open roles doSlight evidence
?
Fits Me
How well does this role fit you?
Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.