Sales Data Analyst - Senior

Embrace Pet Insurance; Ohio; On-site; USD 91,000 - 114,000; Full time

Benefits offered by this job

Health insurance

Life Insurance

Disability insurance

Parental Leave

Health Savings Account (HSA)

Flexible Spending Accounts (FSA)

Retirement savings plan

Paid Time Off

Paid holidays and Wellness Day off

Volunteer time off

Pet friendly office environment

Commuter Benefits

Group Pet Insurance

On-the-job training and skills dev.

Employee Assistance Program (EAP)

Job summary

Embrace Pet Insurance is seeking a Business Intelligence Analyst to transform data into actionable insights. You will partner with stakeholders across the business to build robust reporting solutions and ensure data integrity, primarily using Power BI and SQL.

You will design dashboards, optimize SQL queries, and automate reporting workflows, enabling strategic decisions and scalable operations. This role offers a collaborative, pet-friendly environment with strong growth opportunities.

Qualifications

• 5+ years of experience with SQL (SQL Server Management Studio preferred).
• 5+ years of experience with Power BI or Tableau.
• Strong understanding of data warehousing and data wrangling techniques.
• Excellent analytical and problem-solving skills.
• Ability to communicate complex data insights clearly.

Responsibilities

• Collaborate with stakeholders to understand business needs and translate them into data-driven solutions.
• Design, develop, and maintain interactive dashboards and reports using Power BI (or similar tools).
• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources.
• Perform ad-hoc analyses to support strategic decision-making and operational improvements.
• Ensure data accuracy and integrity through validation, cleansing, and reconciliation processes.
• Automate data collection and reporting workflows to improve efficiency and scalability.
• Identify trends, patterns, and insights that inform business strategy and performance.
• Monitor KPIs and develop alerts or visualisations to track them.
• Document data definitions, processes, and reporting standards for consistency and transparency.
• Partner with data engineering and IT teams to enhance data infrastructure and reporting capabilities.
• Stay current with BI tools and best practices to advance analytics maturity.

Skills

SQL

Power BI

Data warehousing

Data wrangling

Analytical thinking

Cross-functional collaboration

Communication

Education

Bachelor’s degree in Mathematics or related analytics field

Tools

Power BI

Tableau

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.

Position Overview

As a Business Intelligence Analyst, you’ll play a critical role in transforming data into actionable insights that drive strategic decisions across the organization. You’ll work closely with stakeholders to understand business needs, develop robust reporting solutions, and ensure data integrity across multiple sources—primarily using Power BI and SQL.

Key Responsibilities

• Collaborate with stakeholders to understand business needs and translate them into data-driven solutions
• Design, develop, and maintain interactive dashboards and reports using Power BI (or similar tools)
• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources
• Perform ad‑hoc analyses to support strategic decision‑making and operational improvements
• Ensure data accuracy and integrity through validation, cleansing, and reconciliation processes
• Automate data collection and reporting workflows to improve efficiency and scalability
• Identify trends, patterns, and insights that inform business strategy and performance
• Monitor key performance indicators (KPIs) and develop alerts or visualisations to track them
• Document data definitions, processes, and reporting standards for consistency and transparency
• Partner with data engineering and IT teams to enhance data infrastructure and reporting capabilities
• Stay current with BI tools, technologies, and best practices to continuously improve analytics maturity

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Engineering, Operations Research, or a related analytical field
• 5+ years of experience with SQL (SQL Server Management Studio preferred)
• 5+ years of experience with Power BI or Tableau
• Strong understanding of data warehousing and data wrangling techniques
• Excellent analytical, conceptual thinking, and problem‑solving skills
• Ability to communicate complex data insights clearly and effectively
• Self‑starter with strong organisational and time‑management skills
• Passion for data‑driven decision‑making and continuous improvement
• Proven ability to work with cross‑functional teams to deliver data‑driven solutions that support shared business goals.

Why Join Embrace?

• Award‑winning workplace culture
• Emphasis on work‑life balance and professional development
• Opportunities to make a real impact with data
• Collaborative, pet‑loving team environment

Compensation

Base pay range: $ 91,325 – $ 114,158 per year. This is the range we reasonably expect to pay at hire. Placement within the range depends on job‑related factors such as experience, skills, and certifications.

This position is eligible for an annual bonus.

Base pay is one part of a total rewards package that includes the benefits listed below.

All of our jobs come with great benefits including healthcare, parental leave and opportunities for career advancements. Some offerings are dependent upon the location of where you work and can include the following:

• Comprehensive full medical, dental and vision Insurance
• Basic Life Insurance at no cost to the employee
• Company paid short‑term and long‑term disability
• 12 weeks of 100% paid Parental Leave
• Health Savings Account (HSA)
• Flexible Spending Accounts (FSA)
• Retirement savings plan
• Personal Paid Time Off
• Paid holidays and company‑wide Wellness Day off
• Paid time off to volunteer at nonprofit organisations
• Pet friendly office environment
• Commuter Benefits
• Group Pet Insurance
• On‑the‑job training and skills development
• Employee Assistance Program (EAP)

Interview Technology Notice:

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

By continuing with the interview, you consent to this use.

Text Messaging Notice:

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

You may opt out of text communications at any time by replying “STOP.”