Data Analyst, ECP Insights

ECP is a SaaS company providing software for senior living communities, including its customer-facing ECP Insights reporting and analytics product. The Data Analyst will own customer-facing analyses and dashboards, conduct product discovery, and build reusable reporting using Databricks, SQL, Python, and PySpark. The role also involves collaborating with product and data engineering teams, ensuring accuracy, and handling protected health information in compliance with HIPAA and security requirements.

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

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
• • Experience working in version control on a shared codebase. We use Github
• • A track record of owning work end to end
• • 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