Back to jobs

Analytics Consultant, ECP Insights

Milwaukee, Wisconsin, United States

Actively hiring, first seen by us 3 days ago
Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Remote — work setting source
Work setup in the employer’s posting: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Run discovery with customers to find the underlying need and define what to build

  • Own client-facing analyses and dashboards from first conversation through delivery

  • Build client work so it can extend to other customers when the need is shared

  • Write SQL and PySpark against large multi-tenant datasets in Databricks

  • Contribute dbt models with the data engineering team when transformations belong upstream

From the employer’s posting
Run discovery with customers. Understand the underlying need, propose an approach, and define what will be built.
Own client-facing analyses and dashboards end to end, from the initial conversation with the customer through delivery.
build client-specific work so it can extend to others when the need is shared.
Write SQL and Python or PySpark against large, multi-tenant datasets in Databricks.
Contribute dbt models alongside our data engineering team when the transformation belongs upstream.

What you’ll bring

All qualifications

Core experience

  • Strong SQL, including joins, window functions, and query performance on large tables.
  • Experience in healthcare, senior living, or another environment where the data is regulated
  • Experience presenting your own work to people who did not build it, ideally external customers.
Qualification wording
Strong SQL, including joins, window functions, and query performance on large tables.
Experience in healthcare, senior living, or another environment where the data is regulated
Experience presenting your own work to people who did not build it, ideally external customers.
Education & alternatives
Requirements - Bachelor's degree - You have independently built and shipped analyses or reporting against large, complex datasets using SQL and Python or PySpark.
Apply at ECP

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Sep 23, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

ECP is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • BigQuery
  • Databricks
  • dbt
  • Snowflake
  • PySpark
Where the posting names them
We are looking for an Analytics Consultant to build it. Some of what you build will be standard reporting that ships to every customer. Some will begin as a request from a single customer. In both cases you will build for reuse, so that work done for one operator can extend to others when it makes sense. The work is primarily in Databricks, using SQL and Python or PySpark. Some reporting also requires querying our production databases directly. You will work with customers directly, and the expectation is product discovery rather than intake. Understand the need behind the request, propose a better approach when there is one, and shape what we build instead of only executing what is asked.
- Design for reuse. Build standard reporting that serves all customers, and build client-specific work so it can extend to others when the need is shared. - Write SQL and Python or PySpark against large, multi-tenant datasets in Databricks. - Contribute dbt models alongside our data engineering team when the transformation belongs upstream.
- Bachelor's degree - You have independently built and shipped analyses or reporting against large, complex datasets using SQL and Python or PySpark. - You already use AI coding tools in your day to day work, for example Claude Code or Cursor. This is how we work and we expect the same here.
- You already use AI coding tools in your day to day work, for example Claude Code or Cursor. This is how we work and we expect the same here. - Strong SQL, including joins, window functions, and query performance on large tables. - Working knowledge of Databricks, or strong experience on a comparable platform such as Snowflake, BigQuery, or Spark elsewhere.
- Strong SQL, including joins, window functions, and query performance on large tables. - Working knowledge of Databricks, or strong experience on a comparable platform such as Snowflake, BigQuery, or Spark elsewhere. - Experience presenting your own work to people who did not build it, ideally external customers.
- Write SQL and Python or PySpark against large, multi-tenant datasets in Databricks. - Contribute dbt models alongside our data engineering team when the transformation belongs upstream. - Explain coverage, limitations, and methodology to customers.
Nice to Haves - Experience with dbt - Building reporting that serves many customers on shared infrastructure, rather than for a single internal audience

Your next step

Complete your application on apply.workable.com. The employer’s form will show what is required.

Applying through Workable

  • No account needed. You can import your resume to fill in the form, or skip that and fill it in yourself.

Already applied? Track this application

Job description

View original posting ↗

ECP is a market-leading SaaS solution that enables senior living communities to better care for their residents. Used in more than 8,000 communities nationwide, our mission is to build world-class software that improves quality of life for seniors and drives clinical, business, compliance, and operational performance for our customers.

ECP Insights is our customer-facing reporting and analytics product. It gives senior living operators visibility across their portfolio and the reporting they need to run their business, from clinical care to occupancy to billing.

We are looking for an Analytics Consultant to build it. Some of what you build will be standard reporting that ships to every customer. Some will begin as a request from a single customer. In both cases you will build for reuse, so that work done for one operator can extend to others when it makes sense.

The work is primarily in Databricks, using SQL and Python or PySpark. Some reporting also requires querying our production databases directly.

You will work with customers directly, and the expectation is product discovery rather than intake. Understand the need behind the request, propose a better approach when there is one, and shape what we build instead of only executing what is asked.

Insights is a new product and this role carries real influence over its direction. You will join a small team and report to our VP of Data.

Responsibilities

  • Own client-facing analyses and dashboards end to end, from the initial conversation with the customer through delivery.
  • Run discovery with customers. Understand the underlying need, propose an approach, and define what will be built.
  • Use client input to prioritize what we build next across the reporting roadmap.
  • Design for reuse. Build standard reporting that serves all customers, and build client-specific work so it can extend to others when the need is shared.
  • Write SQL and Python or PySpark against large, multi-tenant datasets in Databricks.
  • Contribute dbt models alongside our data engineering team when the transformation belongs upstream.
  • Explain coverage, limitations, and methodology to customers.
  • Own the accuracy of what ships.
  • Work with product, data engineering, and customer-facing teams to turn recurring requests into product.
  • Handle protected health information in line with HIPAA and our security requirements.

What This Role Requires from You

  • You do discovery well. You find the need behind a request and propose a better approach when there is one.
  • You move quickly and design for reuse at the same time.
  • You get real leverage out of AI tooling and keep pushing on what it can take off your plate.
  • You are comfortable telling a customer that an approach will not work, and explaining why.
  • You ship in increments rather than waiting for a complete solution.
  • You verify your results before a customer sees them.
  • You want a role that is both technical and customer-facing.

Requirements

  • Bachelor's degree
  • You have independently built and shipped analyses or reporting against large, complex datasets using SQL and Python or PySpark.
  • You already use AI coding tools in your day to day work, for example Claude Code or Cursor. This is how we work and we expect the same here.
  • Strong SQL, including joins, window functions, and query performance on large tables.
  • Working knowledge of Databricks, or strong experience on a comparable platform such as Snowflake, BigQuery, or Spark elsewhere.
  • Experience presenting your own work to people who did not build it, ideally external customers.
  • A track record of owning work end to end.

Nice to Haves

  • Experience with dbt
  • Building reporting that serves many customers on shared infrastructure, rather than for a single internal audience
  • Experience in healthcare, senior living, or another environment where the data is regulated
  • BI and dashboarding tools

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Milwaukee, Wisconsin, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.