Senior Analytics Engineer

Boulder Care is seeking a Senior Analytics Engineer to build and maintain reliable data pipelines, models, and reporting structures across clinical, operational, and growth data. The role partners with teams across the organization to translate business questions into analytics, with a focus on patient acquisition, marketing performance, attribution, and growth.

Responsibilities:

• Operate across the data stack to build, manage, and optimize end-to-end data pipelines from ingestion to reporting
• Develop, test, and maintain robust, production-grade data models and schemas in BigQuery using dbt, ensuring clean lineage and optimized performance
• Collaborate with the Principal Data Engineer to implement and refine efficient ETL/ELT workflows, balancing infrastructure scalability with analytical agility
• Configure and manage data ingestion pipelines using Fivetran to integrate new operational, financial, and clinical data sources
• Serve as a primary partner to clinical, operations, finance, and growth teams, translating ambiguous business requests into structured, actionable data projects
• Confidently and clearly communicate data insights, technical constraints, and data definitions to both technical and non-technical leaders
• Design and maintain semantic layers and scalable reporting structures within Looker (LookML) to enable self-service analytics across the organization
• Act as a technical mentor and escalation point for data analysts, building their capabilities across SQL, dbt, and advanced analytical workflows
• Establish best practices for code reviews, version control, and testing within the analytics team to foster a high-performance engineering culture
• Bridge the gap between raw data engineering and downstream analysis, ensuring analysts have the well-structured datasets they need to succeed
• Implement robust data validation, testing (e.g., dbt tests), and monitoring to ensure the highest integrity and completeness of upstream and downstream data
• Collaborate with data leadership to define and enforce data standards, metrics definitions, and single-source-of-truth architectures
• Maintain comprehensive documentation of data models, definitions, and governance policies to ensure institutional knowledge is transparent and accessible
• Thrive in a fast-paced, evolving environment by proactively identifying data gaps, bottlenecks, and optimization opportunities across the pipeline
• Maintain a bias for action, comfortably wearing multiple hats—from infrastructure tuning to deep-dive business analysis—to drive organizational momentum

Requirements:

• 6+ years of experience in analytics engineering, data analysis, data engineering, or related full-stack data roles
• Prior experience working in a fast-paced startup environment, with a proven ability to operate autonomously and navigate ambiguity
• Advanced proficiency in SQL and deep, hands-on experience building scalable data models with dbt
• Strong experience managing and optimizing cloud data warehouses, specifically BigQuery
• Proven track record with Fivetran (or similar ingestion tools) and business intelligence platforms, specifically Looker/LookML development
• Excellent stakeholder management and communication skills, with a demonstrated ability to turn business requirements into technical execution
• Familiarity with data governance, version control (Git), and an understanding of handling sensitive data within a secure, compliant environment (e.g., HIPAA)
• Comfortable working alongside a dedicated Principal Data Engineer, with enough technical depth to collaborate on infrastructure while maintaining a strong focus on business application and analysis
• Integrity, strategic thinking, and professionalism that reflect Boulder Care's values
• Experience partnering with Marketing or Growth teams to build the data foundations and analytics needed to understand acquisition, attribution, funnel performance, conversion, and growth opportunities is strongly preferred
• Experience in healthcare data analytics (e.g., working with EHRs, claims data, or clinical workflows)
• Familiarity with Substance Use Disorder and/or other stigmatized populations
• Demonstrated proficiency using AI tools to enhance productivity, analytical workflows, and technical development
• Boulder Care recognizes the value that lived experience can provide to our organization, community, and patients. Applicants with lived experience and/or training as a peer recovery specialist are encouraged to apply!