Sr. Data Analyst

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. 

Pets Best, a subsidiary of IPH, offers pet insurance and wellness plans for dogs and cats in every state. Founded in 2005 with a mission to provide access to comprehensive animal healthcare at an affordable price, Pets Best delivers flexible coverage, an easy claims process, and excellent customer service. 

Job Profile Summary

Performs statistical modeling and analysis of structured and unstructured datasets to develop metrics, reports, curated datasets, and visualizations of trends and patterns. Partners with stakeholders to define dataset requirements and deliver actionable insights that support Pets Best’s mission to help pets live long, happy, and healthy lives.

Job Description

• Collaborates with stakeholders to understand and define business requirements for operational and analytical reports.
• Defines and curates dataset requirements to support analytics, dashboards, and self-service reporting.
• Collects, analyzes, and interprets data from multiple sources to identify trends, patterns, and insights.
• Performs data cleansing, validation, and documents data definitions. Establishes business rules and quality checks to ensure accuracy and reliability of reports.
• Designs, develops, and maintains interactive dashboards, visualizations, and reports using business intelligence tools.
• Uses analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profiles of new business initiatives.
• Queries and manipulates data using SQL to extract, transform, and aggregate data from databases.
• Leverages Python (and other scripting tools) for advanced analysis, automation, and statistical modeling.
• Builds and maintains dbt models to ensure scalable, documented, and version-controlled data transformations.
• Collaborates with cross-functional teams to support ad-hoc data analysis requests.
• Presents findings and recommendations to stakeholders in a clear and concise manner.
• Provides guidance and mentorship to junior members of the data analysis team, fostering professional growth and adoption of best practices.
• Stays up to date with industry best practices, emerging technologies, and trends in data analysis.
• Ensures data integrity, accuracy, and compliance with data privacy regulations through robust data governance practices.
• Performs other duties and responsibilities as assigned.

Qualifications

Experience:

• Minimum 6 years’ relevant experience in data analytics, business intelligence, or related field.

Education:

• Bachelor’s Degree in Data Science, Statistics, Economics, Computer Science, or related field (or equivalent work experience). A Master’s degree is a plus.

Level Specific Responsibilities:  

• Collaborates with cross-functional teams to define and execute data-driven strategies that align with business objectives
• Ensures data integrity, accuracy, and compliance with data privacy regulations through robust data governance practices
• Provides guidance and mentorship to junior members of the data analysis teams, fostering their professional growth
• Stays up to date with industry best practices, emerging technologies, and trends in data analysis.

Accountability/Complexity: 

• May manage projects requiring the responsibility of delegation of work and review of resulting work product
• Works independently under limited supervision
• May be responsible for providing guidance, coaching, and/or training to other employees within job area
• May function as a team lead and/or assistant to the supervisor/manager

Tools & Skills (Preferred)

• Languages: SQL, Python (R a plus).
• Data Modeling/ETL: dbt (preferred), Alteryx, Airflow, or similar.
• Databases/Warehouses: Snowflake, Redshift, BigQuery, Oracle, SQL Server, or similar.
• Visualization & BI Tools: Power BI, Tableau, Looker, or equivalent.
• Collaboration & Version Control: Git/GitHub.
• Other Skills: Strong business acumen, data governance, statistical modeling, stakeholder communication, and data storytelling.

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)