Sr. Data Analyst, eCommerce

Pets deserve the best care. At Vetsource, we build the foundation for success, enabling those in the pet healthcare profession and industry to thrive. Our data-powered platform simplifies processes and streamlines systems, helping those we serve create tighter bonds with their customers. From prescription management and pet owner engagement to veterinary business performance data and insights, Vetsource provides comprehensive solutions that give our customers more time and flexibility, and help them foster strong relationships and positive experiences. In a rapidly evolving world, we’re constantly seeking new ways to help our customers chart a course for a better, brighter future for pets and those who care for them.

If you love pets, want to have an impact and join a fantastic organization, Vetsource could be the place for you.

At Vetsource, we know that we do our best work when we have an inclusive and diverse team, where we can draw on our different life experiences to help us deliver innovative solutions for our customers. We are an equal opportunity employer that values diversity, equity, and an inclusive workplace. Research shows that while men apply to jobs when they meet an average of 60% of the criteria, women and other marginalized people tend to only when they check every box. So if you think you might be a good fit for the role, but don't necessarily meet every single requirement on the job posting, we still encourage you to apply.

WHO WE ARE LOOKING FOR
Sr. Data Analyst, eCommerce
 

The Senior Analyst in this role at Vetsource would be responsible for analyzing large eCommerce datasets, building robust infrastructure in Data Build Tool (dbt) and generating insights and recommendations that support our Retail eCommerce business. Technical leadership demonstrated by this role includes both writing highly optimized SQL and reviewing other analyst work for correctness, robustness and performance, upskilling and mentoring more junior analysts in the process.

This role also takes on complex data projects that are important to the organization, working with stakeholders to use data to guide the business into making high-impact data-driven decisions and deliver industry leading data products to our customers. This role will focus on building and maintaining dashboards, analyzing marketing performance, and providing insights to optimize our eCommerce strategy. The ideal candidate will have a strong analytical background with eCommerce platforms.

This is a full-time, remote position.

WHAT YOU’LL DO

• Act as a strategic partner to stakeholders, understanding their business needs and aligning data solutions accordingly.

• Able to gather requirements from non-technical stakeholders for their team's core function and explain the analysis performed to audiences of all technical abilities

• Understand a complex data model with thousands of entities, their relationships and how that data relates to the business

• Optimize complex SQL queries for performance and resilience in a state-of-the-art data warehouse

• Design and maintain sophisticated data models and visualizations, offering a comprehensive view of performance marketing and eCommerce metrics 

• Utilize Looker/PowerBI to develop interactive dashboards, reports, and visualizations, offering a comprehensive view of performance marketing and eCommerce metrics

• Suggest and implement technical and non-technical process improvements on an ongoing basis

• Design KPIs that help business counterparts to understand, measure and take action on their goals

• Provide technical mentorship and training; perform code reviews and apply software engineering best practices to analytics code

• Build models to tackle advanced cleaning and classification tasks like clustering, matching and outlier analysts.

• Provide guidance and project direction to other members of the team and serve as an expert resource within the team 

• Lead projects independently

WHAT YOU BRING

• Minimum 5 years working experience as analyst, statistician or similar

• Minimum 5 years of experience with of any variety of SQL

• Experience with a data visualization tool (Looker, PowerBI or similar)

• Experience with database design, ETL design and query optimization

• Experience in eCommerce analysis including common KPIs across all phases of the Customer Journey

• Exceptional communica