ECP Logo

ECP

Analytics Consultant, ECP Insights

Posted One Month Ago
In-Office or Remote
Hiring Remotely in Denver, CO, USA
Entry level
In-Office or Remote
Hiring Remotely in Denver, CO, USA
Entry level
Build and own customer-facing analyses, dashboards, and reusable reporting for ECP Insights. Conduct customer discovery, define reporting needs, write SQL and Python or PySpark in Databricks, contribute dbt models, validate accuracy, explain methodologies, and help prioritize the product roadmap. Collaborate with product, engineering, and customer-facing teams while handling HIPAA-protected health information.
The summary above was generated by AI

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

Similar Jobs

35 Minutes Ago
Remote
United States
Junior
Junior
Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
Coordinate People Operations programs including employee engagement, culture initiatives, company offsites, events, recognition, onboarding, benefits communications, surveys, HRIS administration, reporting, and employee support. Maintain accurate and confidential records, improve processes and documentation, coordinate vendors and logistics, and partner with People, Talent, Finance, and IT teams. The role supports a global remote workforce and offers opportunities to take on greater ownership.
Top Skills: Ai ToolsHrisSlack
36 Minutes Ago
Easy Apply
Remote or Hybrid
USA
Easy Apply
151K-215K Annually
Senior level
151K-215K Annually
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
Leads global customer advocacy through AI-powered innovation, strategic customer content, and third-party validation. Drives adoption and optimization of AI solutions, measures productivity and business impact, develops customer success stories for integrated campaigns, manages Gartner Peer Insights review programs, and supports analyst engagement and customer references. The role requires cross-functional collaboration across Sales, Marketing, and Customer Success, along with scalable processes, analytics, and operational execution.
Top Skills: Ai ToolsCustomer Story AgentGartner Peer InsightsUpland Ro
37 Minutes Ago
Remote
United States
210K-230K Annually
Senior level
210K-230K Annually
Senior level
Computer Vision • Digital Media • Kids + Family • Mobile • Software • Sports
Lead the technical vision, design, implementation, and operation of GameChanger’s Partner API and other integrations. Establish standards for API design, security, reliability, observability, documentation, and developer experience. Guide architecture across teams, manage dependencies and risks, improve production practices, and mentor senior and Staff engineers. Partner with engineering, product, and business leaders to align technical investments with company goals while remaining hands-on in critical implementation work and occasional on-call support.
Top Skills: APIsAWSNode.jsPostgresRedisTypescriptWebhooks

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account