Senior Analytics Engineer
Independence Pet Group1 month ago
Remote, United States +2 moreSenior
Base Salary
$113k - $169k/yr
Responsibilities
- Own the analytics engineering roadmap, priorities, standards, and operating practices.
- Design and evolve analytics architecture across bronze, silver, and gold data layers.
- Build, maintain, and optimize dbt models and analytics-ready datasets.
- Use SQL and Python for transformation, validation, automation, and complex processing.
- Develop dimensional and business-oriented models for dashboards, self-service analysis, reporting, and data products.
- Define shared KPI logic, data contracts, ownership, authoritative sources, and metric governance.
- Implement automated tests, freshness checks, documentation, lineage, monitoring, and data-quality practices.
- Use Git-based version control, code review, CI/CD, and controlled environment promotion.
- Partner with Data Engineering on ingestion, schemas, platform performance, and data-layer handoffs.
- Investigate and remediate data-quality issues and communicate root causes and resolutions.
- Improve Databricks performance and cost efficiency through table design, incremental processing, query optimization, and compute management.
- Migrate spreadsheet, dashboard, and ad hoc query logic into governed and reusable dbt models.
- Create technical documentation, modeling conventions, enablement materials, reusable patterns, and design reviews.
- Mentor team members and raise analytics engineering capability.
Requirements
- Bachelor’s degree or higher in computer science, data engineering, analytics, information systems, mathematics, or a related discipline, or equivalent professional experience.
- 8+ years of relevant data and analytics experience, including senior-level ownership of production analytics data models and standards.
- Strong experience leading complex analytics engineering, data engineering, business intelligence engineering, or related initiatives.
- Advanced SQL skills and experience designing, debugging, and optimizing complex transformations.
- Deep hands-on dbt experience with 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 tuning.
- Experience with medallion architectures and lakehouse data models across bronze, silver, and gold layers.
- Strong Python skills for data processing, testing, validation, automation, and engineering utilities.
- Strong understanding of dimensional modeling, warehouse and lakehouse design, semantic layers, slowly changing dimensions, and metric governance.
- Experience with Git, CI/CD, code review, automated testing, orchestration, and environment management.
- Ability to translate ambiguous business needs into technical designs and communicate with senior leaders and non-technical stakeholders.
- Experience in animal health, veterinary services, pet insurance, SaaS, fintech, or health technology is a plus.
Benefits
- Remote U.S. position aligned to Eastern or Central Time business hours.
- U.S. travel may be required.
- Comprehensive medical, dental, and vision insurance.
- Company-paid basic life insurance, short-term disability, and long-term disability.
- 12 weeks of 100% paid parental leave.
- Health Savings Account and Flexible Spending Accounts.
- Retirement savings plan, paid time off, paid holidays, and a company-wide Wellness Day.
- Paid time off for volunteering at nonprofit organizations.
- Pet-friendly office environment, commuter benefits, and group pet insurance.
- On-the-job training, skills development, and Employee Assistance Program.
- Annual bonus eligibility.
- Phone and video interviews or screenings may be recorded and transcribed using interview technology, with candidate consent.
- Job-related text messages may be sent to provided mobile numbers, with opt-out available by replying STOP.
About Independence Pet Group
Independence Pet Group provides pet insurance and related services across North America through a portfolio of brands, offering policies to pet owners and pet-industry partners. Its family includes ASPCA Pet Health Insurance, AKC Pet Insurance, Figo, Felix, and Pets Plus Us, and it also provides microchip identification and an online pet registry. Privately held and headquartered in Chicago, the company supports insurance coverage for more than 1 million pets in the U.S. and Canada, and operates its own carrier.