Analytics Engineer
Counsel Health · New York, NY · 1 wk ago
HybridInformation Technology$185k–$210k/yrFull-time
About the role
We've built a strong data foundation: a cloud warehouse, ETL pipelines, and event tracking are all in place. Now we need someone to make that data mean something.
Responsibilities
- Build and maintain the data models that define our core business metrics, from clinical outcomes to revenue to utilization, and own the sources of truth the whole company relies on
- Run dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing that catches issues before they reach a dashboard
- Stand up reverse ETL pipelines that feed clean, modeled data back into production systems, including population cohort definitions, marketing intelligence, and operational features
- Implement and maintain access controls for PHI, keeping the data layer HIPAA-compliant while staying accessible to the people who need it
Requirements
- 3+ years of experience in analytics engineering, data analytics, or a hybrid data role
- Deep expertise in SQL and dbt
- Experience with BigQuery or comparable cloud data warehouses (Snowflake, Redshift)
- Experience working in a regulated industry (healthcare, fintech, insurance, government) with a proven ability to manage sensitive data and access controls, HIPAA familiarity a plus
- Experience with data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar) and integrating analytics data back into production systems
Qualifications
- Thinks in business entities and stakeholder questions, not just tables and joins, and turns fuzzy requirements into clean, well-modeled data
- Treats dbt as a primary tool, writing clean, modular, well-tested transformations, with strong opinions about how a dbt project should be organized
- Comfortable managing orchestration, environments, and reverse ETL pipelines without hand-holding, even without being a dedicated data engineer
- Doesn't just model data, but asks why someone needs it and how it drives a patient or business outcome
- Finds energy in creating structure in ambiguous, fast-moving environments, and can synthesize needs from multiple stakeholders into a clear data strategy
Skills
- SQL
- dbt
- BigQuery or comparable cloud data warehouses (Snowflake, Redshift)
- Data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar)
- Access controls for PHI, HIPAA compliance
Benefits
- Impact: Be at the forefront and contribute to groundbreaking, AI-driven healthcare experiences, directly interface with execs at the world's leading tech & healthcare orgs
- Growth: Significant opportunities for broad ownership and professional development within our rapidly scaling startup
- Compensation: Competitive salary + equity
- Benefits: Comprehensive healthcare, vision + dental, 401K, Unlimited PTO, Parental Leave
Pay
$185K - $210K
Schedule
Hybrid, Boston - hybrid, or East Coast - remote