Data Analyst

PetCheck Urgent Care; Chicago (IL); Remote; USD 105,000 - 115,000; Full time

Job summary

A leading company in veterinary care is seeking a Data Analyst to support analytics and business intelligence initiatives. This full-time remote role will focus on transforming data into actionable insights, developing reports, and collaborating with teams to enhance organizational efficiency.

Benefits

Health, dental, vision insurance

Paid time off

Flexible work schedules

Bonus incentives

Learning and career development solutions

Qualifications

• 4+ years of experience in data analytics or related field.
• 4+ years of experience with SQL and stored procedures.
• 3+ years of experience with Power BI and Power Query.

Responsibilities

• Collect, manage, and analyze large datasets to identify trends.
• Develop and maintain visualizations and dashboards using Power BI.
• Collaborate with cross-functional teams for ad-hoc data analysis.

Skills

Data Analysis

SQL

Power BI

Python

Problem-Solving

Communication

Tools

Power Query

Power Automate

SharePoint

Job description

More about the Role

At Heartland Veterinary Partners, our mission is centered around elevating the lives of veterinarians and their teams. By partnering with Heartland, practice owners unlock a world of operational advantages and economies of scale, all while retaining their clinical autonomy. At Heartland, we go beyond the ordinary to foster an environment that nurtures growth, invests in our employees, and creates pathways for professional development.

The Heartland promise doesn't stop at operational brilliance; it extends to encompass non-clinical facets like recruiting & human resources, marketing, procurement, payables management, accounting & finance, and information technology. In essence, we've got every corner covered, so our partners can focus on what truly matters - providing optimal care for their patients. As a dedicated member of our Support Center, you'll have the opportunity to be a part of what makes that happen. Your role will be pivotal in helping our partners deliver unparalleled patient care.

The Heartland philosophy rests firmly on the pillars of Servant Leadership. This ethos defines our Support Center team, where every member embraces the ethos of selfless service and approaches every challenge with an unwavering commitment to support. If this resonates with your personal and professional values, then we'd like to get to know you better!

Position Purpose

Reporting to the Director of Business Intelligence and Data, the Data Analyst will collect and analyze data from multiple sources to support the analytics and business intelligence initiatives across Heartland Veterinary Partners. This role will focus on transforming raw data into actionable insights, developing meaningful reports and dashboards, identifying trends, and leveraging analytics to improve organizational efficiency and effectiveness. This is a full-time remote role. Candidates within Heartland's geographic footprint will be prioritized.

Competencies

At Heartland, all of our team members embody the spirit of Servant Leadership.

• Authentic Listening - Continually listening with an open mind and heart to what is said and unsaid.
• Building Community –Bringing team members together and mobilizing them around our collective purpose and commitment to our communities.
• Commitment to the Growth of the People – Dedicated to the personal and professional growth and development of our team members.
• Conceptualization -Forward thinking and approaching work and challenges with an end-to-end view.
• Empathy – Demonstrating empathy and understanding with others, approaching everything assuming positive intentions.
• Foresight – Taking the past, the present, and the future decision-making process.
• Healing – Focusing on the emotional and physical health of our team members. Offering support and solutions to ensure our team members have balance.
• Persuasion – Building group consensus and buy-in.
• Self-Awareness – Conscious knowledge of personal character, emotions, intentions, and leadership impact.
• Stewardship -Concern for our team members, customers, communities, and the organization as a whole and making good use of all that is available to provide appropriate support.

Essential Responsibilities

• Collect, organize, manage, and analyze large datasets from various fragmented and legacy systems to identify trends, patterns, and insights.
• Identify and address data inconsistencies, errors, and missing values, as well as perform data validation, normalization, and standardization techniques to ensure data accuracy and reliability for analysis purposes.
• Develop and maintain visualizations, interactive dashboards, and reports to communicate data findings to stakeholders using Power BI, as well as Python libraries, in a clear and concise manner.
• Develop and maintain data models for use by all data and analytics team members using SQL stored procedures, Power Query, Power BI, and other tools.
• Monitor key performance indicators, track metrics, and evaluate program outcomes and impact using data-driven approaches.
• Build and implement automation for business processes and reporting.
• Collaborate with cross-functional teams to support ad-hoc data analysis requests.
• Document data definitions and production code.

Requirements/Qualifications

• 4+ years of experience in data analytics or a related field.
• 4+ years of experience with SQL query writing, view creation, and stored procedures.
• 3+ years of experience with Power BI and Power Query.
• Experience with Python, Power Automate, and SharePoint.
• Excellent problem-solving skills and ability to collaborate across teams.
• Familiarity with veterinary healthcare or healthcare analytics is a plus.
• Excellent communication skills and ability to translate technical insights into business strategies.

Benefits Offered

• Physical wellness: Health, dental, vision, voluntary life and disability programs, and discounted access to gym memberships
• Mental wellness: Paid time off, flexible work schedules, and EAP
• Financial wellness: Bonus incentives, retirement accounts, retail discounts, and access to financial planning tools
• Professional wellness: Learning and career development solutions

Pay Range

USD $105,000.00 - USD $115,000.00 /Yr.