Senior BI Engineer (REMOTE)

Independence Pet Group; Alabama; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Dental and vision insurance

Retirement plan

HSA

FSA

Paid time off

Holidays

Pet-friendly office

Training & development

Employee Assistance Program

Job summary

Clarus is seeking an experienced Analytics Engineer to join the Analytics team. This role will own the analytics engineering process, build scalable pipelines, and transform raw data into analytics-ready models using dbt, SQL, Python, and Databricks.

You will collaborate with Data Engineering, BI, and business stakeholders to deliver trusted data assets. The ideal candidate will be hands-on, able to set technical direction while supporting multiple projects, and comfortable working in a remote

Qualifications

• A strong track record leading complex analytics engineering or related initiatives; animal health or pet tech experience is a plus.
• 8+ years of analytics experience with senior ownership of production analytics data models and standards.
• Advanced SQL skills with designing, debugging, and optimizing complex transformations.
• Deep dbt experience including scalable model architecture, testing, incremental models, documentation, macros, and production deployment.
• Strong Databricks experience: Delta Lake, Spark SQL, Workflows/Jobs, Unity Catalog, performance tuning.
• Experience with medallion architectures and lakehouse data models across bronze, silver, and gold.
• Strong Python for data processing, testing, validation, automation, and engineering utilities.
• Experience with modern engineering practices: Git, CI/CD, code reviews, automated testing, orchestration, and environment management.

Responsibilities

• Own analytics engineering work, including roadmap, priorities, standards, and operating practices.
• Design and evolve analytics architecture with clear data-layer responsibilities.
• Build and optimize dbt models transforming source data into analytics-ready datasets.
• Write and optimize advanced SQL; use Python for transformations and automation.
• Develop dimensional data models for dashboards, self-service analysis, and data products.
• Establish KPI definitions, data contracts, ownership, and authoritative sources.
• Implement automated tests, data quality checks, documentation, lineage, and monitoring.
• Partner with Data Engineering on ingestion and platform performance.
• Collaborate with analysts and BI teams to translate requirements into scalable models.
• Improve Databricks performance and cost efficiency through design and tuning.
• Lead data-quality investigations and root-cause analysis; communicate findings.
• Strengthen data governance with access controls and stewardship.

Skills

dbt

SQL

Python

Databricks

Data modeling

Data governance

CI/CD

Git

Education

Bachelor’s degree in computer science or related field

Tools

Delta Lake

Spark SQL

Unity Catalog

Workflows/Jobs

Git

CI/CD tooling

Job description

Established in 2021, Independence Pet Holdings is a corporate holding company that manages a diverse and broad portfolio of modern pet health brands and services, including insurance, pet education, lost recovery services, and more throughout North America. We believe pet insurance is more than a financial product and build solutions to simplify the pet parenting journey and help improve the well-being of pets. As a leading authority in the pet category, we operate with a full stack of resources, capital, and services to support pet parents. Our multi-brand and omni-channel approach include our own insurance carrier, insurance brands and partner brands.

Clarus, a Doubtless company, is a pioneering pet health technology company transforming the future of pet healthcare. We develop connected solutions across the pet health landscape, helping veterinary teams and pet owners make more informed care and financial decisions. Together, we are reducing complexity and helping more pets receive the care they need.

Clarus is seeking an experienced Analytics Engineer to join the Analytics team. This individual will own the analytics engineering process and serve as the technical bridge between Data Engineering and Analytics delivery. They will build, expand, and optimize Clarus’s analytics architecture and pipelines, improving how data flows from diverse sources to downstream analytics solutions. In this role, you will lead high-impact data product and solutions initiatives from ambiguous problem definition through technical design, implementation, rollout, and adoption. You will transform raw and curated data into reliable, analytics-ready models and consistent business metrics using dbt, SQL, Python, and Databricks, while establishing a scalable architecture and strong engineering practices.

The ideal candidate is a seasoned analytics engineer with strong data-wrangling skills and a passion for building and optimizing scalable analytics systems. They are self-directed, comfortable supporting multiple projects, systems, and products, and able to set technical direction while remaining deeply hands-on.

• Own analytics engineering work, including its roadmap, priorities, standards, and operating practices.
• Design and evolve analytics architecture, with clear responsibilities and quality expectations across bronze, silver, and gold data layers.
• Build, maintain, and optimize dbt models that transform source data into curated, reusable, analytics-ready datasets.
• Write and optimize advanced SQL, and use Python for data transformation, validation, automation, and complex processing where appropriate.
• Develop dimensional and business-oriented data models that support dashboards, self-service analysis, operational reporting, and data products.
• Establish and document shared KPI definitions, calculation logic, data contracts, ownership, and authoritative sources.
• Implement automated tests, source freshness checks, documentation, lineage, and monitoring to make data quality visible and dependable.
• Partner with Data Engineering on ingestion, source schemas, platform performance, and reliable handoffs between foundational and analytical data layers.
• Partner with analysts, BI developers, and business stakeholders to translate requirements into scalable models rather than one-off reporting logic.
• Improve Databricks performance and cost efficiency through thoughtful table design, incremental processing, query optimization, and compute usage.
• Lead data-quality investigations, root-cause analysis, remediation, and communication when critical analytics assets do not meet expectations.
• Strengthen data governance by applying appropriate access controls, handling sensitive data responsibly, and supporting consistent ownership and stewardship.
• Design resilient models that support historical analysis, changing source systems, incremental loads, and evolving business definitions.
• Create clear technical documentation, modeling conventions, and enablement materials that drive adoption of trusted data assets.
• Raise analytics engineering capability across the team through design reviews, reusable patterns, thoughtful feedback, and hands-on mentorship.

Bachelor’s degree or higher in computer science, data engineering, analytics, information systems, mathematics, or a related discipline, or equivalent professional experience.

• ~ A strong record of success leading complex analytics engineering, data engineering, business intelligence engineering, or closely related initiatives. Experience in animal health, veterinary services, pet insurance, SaaS, fintech, or health technology is a plus.
• ~8+ years of relevant data and analytics experience, including senior-level ownership of production analytics data models and standards.
• ~ Advanced SQL skills and demonstrated experience designing, debugging, and optimizing complex transformations.
• ~ Deep, hands-on dbt experience, including scalable model architecture, testing, incremental models, snapshots, documentation, macros, packages, and production deployment workflows.
• ~ Strong Databricks experience, including Delta Lake, Spark SQL, Workflows or Jobs, Unity Catalog, and performance management / tuning.
• ~ Demonstrated skill operating medallion architectures and lakehouse data models across bronze, silver, and gold layers.
• ~ Strong Python skills for data processing, testing, validation, automation, and engineering utilities.
• ~ Experience with modern engineering practices, including Git, CI/CD, code review, automated testing, orchestration, and environment management.

WHAT WILL HELP YOU SUCCEED

You can move easily between hands-on analytics engineering, and stakeholder conversations.

You can manage production data deliverables while continuing to improve the underlying processes.

You build trust by producing reliable data products, communicating clearly, and following through on commitments.

This is a remote U.S. travel may be required.

This position is eligible for an annual bonus. Comprehensive full medical, dental and vision Insurance

• ~ Basic Life Insurance at no cost to the employee
• ~ Company paid short-term and long-term disability
• ~Health Savings Account (HSA)
• ~ Flexible Spending Accounts (FSA)
• ~ Retirement savings plan
• ~ Personal Paid Time Off
• ~ Paid holidays and company-wide Wellness Day off
• ~ Pet friendly office environment
• ~ On the job training and skills development
• ~ Employee Assistance Program (EAP)

Please note that phone and video interviews or screenings may be recorded and transcribed using interview technology to support our recruitment process.

If you provide a mobile phone number, you may receive job-related communications via text message. Message and data rates may apply.