Want to know if this job is worth applying to?
Ohio, United States
Onsite
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 visualizations 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 organizational 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 organizations
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.”