> Markdown version of [/jobs/ext/1182147-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1182147-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - **Company:** Counsel Health - **Location:** Boston, MA, United States (Remote available) - **Experience:** Experienced - **Salary:** $185,000.0 - $210,000.0 - **Contract:** Permanent contract - **Skills:** Airflow, Data Analysis, Backup Devices, BigQuery, Cloud Computing, Cloud Database, Extract Transform Load (ETL), Raw Data, SQL Databases, Snowflake, Data Strategy, Data Layers, Core Data, Data Analytics - **Published:** July 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dc09b8d81af89977 ## About the Role * 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, * 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 * Feels energized by creating structure in ambiguous, fast-moving environments, and can synthesize needs from multiple stakeholders into a clear data strategy ## Description 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., We're looking for an Analytics Engineer to own the semantic layer, building and maintaining the core data models the rest of the company relies on to turn raw data into insight. You'll be the person everyone trusts to answer "how do we measure this?" You'll be our first dedicated analytics hire, which means you set the standards, choose the patterns, and shape how Counsel uses data for years to come. The infrastructure is built, the warehouse is running, and the company is growing. What's missing is the person who makes the data layer actually work, turning raw tables into the trusted models that power every dashboard, every data product, and every strategic decision. What You'll Do * 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, We are clinicians 1st, technologists 2nd. We act with patient trust/safety at the center of every decision. * Innovate with optimism. We are optimistic as we build the future of care delivery from first principles. Challenge the status quo when needed, no sacred cows. * Right answer wins. Debate openly and pick the strongest path. We optimize for the company, not functions. We win and lose as a team. * Simplicity over complexity. We choose clear, elegant solutions and avoid adding complexity that does not serve patients or the team. * Do fewer things, well. We focus, and hold ourselves to the highest bar and pursue excellence in those areas. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)