Senior BI Engineer (REMOTE)

Begell House Inc.; Northern (KY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Comprehensive benefits

Mental health support

Paid parental leave

401(k)

Fully remote with hardware

Job summary

Boulder Care is seeking a Senior Analytics Engineer to support data infrastructure and business insights, with a focus on growth, marketing, and patient acquisition analytics. You will collaborate with the Principal Data Engineer to build scalable data assets and empower analysts with reliable data across the organization.

The role emphasizes modeling clinical, operational, and growth data securely and translating complex business questions into analytical workflows, enabling Looker self-service

Qualifications

• 6+ years of experience in analytics engineering, data analysis, data engineering, or related full-stack data roles.
• Advanced proficiency in SQL and building scalable data models with dbt.
• Strong experience with BigQuery, Fivetran, and Looker/LookML development.
• Familiarity with data governance and version control (Git) in secure environments.
• Experience partnering with Marketing or Growth teams to understand acquisition, attribution, funnel performance.
• Experience in healthcare data analytics is preferred.

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.
• Design and maintain semantic layers and scalable reporting structures within Looker (LookML) to enable self-service analytics across the organization.

Skills

SQL

dbt

BigQuery

Fivetran

Looker LookML

Data modeling

Data governance

Git

ETL/ELT

Stakeholder comms

Tools

BigQuery

Fivetran

Looker

Job description

About this role Boulder Care is seeking a skilled and experienced Senior Analytics Engineer to support both data infrastructure and business insights, with a likely focus on growth, marketing, and patient acquisition analytics. The ideal candidate will operate across the entire data pipeline, collaborating closely with our Principal Data Engineer to build reliable, scalable data assets while empowering analysts and stakeholders to make data-driven decisions. This role is key to ensuring that clinical, operational, and growth data is modeled securely and remains reliable and accessible. The Senior Analytics Engineer must also be skilled at translating complex business questions into robust analytical workflows, with particular emphasis on helping teams understand and optimize the patient acquisition funnel, marketing performance and attribution, conversion, and growth opportunities.

Boulder Care is an award-winning digital clinic for addiction medicine, recognized for both innovation and high-quality of patient care. Founded in 2017 by CEO Stephanie Strong, our mission is to improve the lives of people with substance use disorders through compassionate, evidence-based care.

We provide Boulder patients with a fully virtual, multidisciplinary care team—including medical providers and peer recovery specialists—who deliver personalized treatment, including medication for opioid use disorder (MOUD) and ongoing support. Our approach is grounded in clinical excellence, patient-centered care, and a commitment to reducing barriers to recovery. Boulder partners with leading health plans, employers, and community organizations to ensure that our services are accessible and covered for the people who need them most.

Data Modeling & Pipeline Development

• 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.

Stakeholder Partnership & Analytical Translation

• 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.

Team Mentorship & Capability Building

• 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.

Data Quality, Governance & Documentation

• 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.

6+ years of experience in analytics engineering, data analysis, data engineering, or related full-stack data roles.

• 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.
• Familiarity with data governance, version control (Git), and an understanding of handling sensitive data within a secure, compliant environment (e.g., 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.
• 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).

Demonstrated proficiency using AI tools to enhance productivity, analytical workflows, and technical development.

This is a fully remote role, but we are currently only hiring candidates located in the following states: This is a full-time remote position generally expected to work 40 hours per week during standard business hours.

The total compensation package for this position may also include other elements, including a full range of medical, financial, and/or other benefits (including 401(k) eligibility and various paid time off benefits, such as vacation, sick time, and parental leave).

• Comprehensive medical, dental, vision, and short-term disability benefits designed to take care of our employees and their families
• Mental health services via insurance coverage, including Talkspace and EAP for continuous care
• 9 paid holidays per year
• 12 weeks of 100% paid parental leave for the birth or adoption of a child (after 6 months of employment)
• 401(k) retirement savings
• Fully remote, with hardware provided to complete your work duties

Move the industry forward, follow the data

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.

Boulder Care believes the people who build our product and make up our team should be representative of those who use the platform. We celebrate differences and are committed to equal employment opportunities regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, citizenship, marital status, disability, gender identity or veteran status. If you are a qualified person with a passion for what we do,

Boulder Care believes the people who manage our product and team should be representative of those who use the platform. We celebrate differences and are committed to equal employment opportunities regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, citizenship, marital status, disability, gender identity or veteran status. If you are a qualified person with a passion for what we do,