Analytics Engineer

Join Counsel, a rapidly growing healthcare technology company, as our first dedicated Analytics Engineer. In this role, you will own the semantic layer, build and maintain core data models, and shape how Counsel uses data for years to come. You will have significant opportunities for broad ownership and professional development, including equity, 401K, unlimited PTO, and comprehensive healthcare benefits.

• Posséder la couche sémantique, construire et maintenir les modèles de données fondamentaux.
• Exécuter l'orchestration dbt avec des alertes intégrées, des pipelines CI/CD et des tests de qualité des données.
• Mettre en place des pipelines ETL inversés qui alimentent des données propres et modélisées dans les systèmes de production.
• Experience with BigQuery or comparable cloud data warehouses (Snowflake, Redshift)
• Deep expertise in SQL and dbt
• Experience with data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar) and integrating analytics data back into production systems
• 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
• 3+ years of experience in analytics engineering, data analytics, or a hybrid data role
• Feels energized by creating structure in ambiguous, fast-moving environments, and can synthesize needs from multiple stakeholders into a clear data strategy
• 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
• 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