Business Analyst, Pet Services

Petco; Santiago de Querétaro; Presencial; MXN 536.000 - 759.000; Jornada completa

Descripción de la vacante

Petco is seeking a data-driven Analytics professional in Querétaro to lead site selection, M&A insights, and revenue optimization for veterinary and healthcare services. You will build predictive models, scorecards, and data-driven recommendations to guide strategic decisions across real estate and growth initiatives.

In this role, you will work with SQL, Python or R, and cloud data warehouses to develop dashboards (Tableau/Power BI/Looker) and explain complex findings to executives and

Formación

• Bachelor's degree in Business Analytics, Statistics, Economics, Mathematics, Data Science, Computer Science, or a related quantitative field.

Responsabilidades

• Own analytical processes for hospital site selection, integrating predictive models and performance scorecards to prioritize locations.
• Deliver data-driven insights and valuation metrics to support clinic acquisitions, partner integrations, and executive readouts for real estate committees.
• Analyze customer data to uncover trends in appointment utilization and service mix, aiming to maximize customer lifetime value and unit economics.
• Design and deploy statistical models, clustering, and test-and-learn frameworks; collaborate with Enterprise Data Science to adapt ML models for clinical and service operations.
• Create interactive BI dashboards tracking KPIs, clinic throughput, and customer satisfaction for executive audiences.

Conocimientos

SQL

Python

R

Data visualization

Tableau

Power BI

Looker

Educación

Bachelor's degree in a quantitative field

Herramientas

Snowflake

BigQuery

AWS

Descripción del empleo

Key Responsibilities

Site Selection & Pipeline Management: Own analytical processes for hospital site selection, integrating predictive models, demographic data, and performance scorecards to prioritize and rank candidate locations.

M&A & Business Development: Deliver data-driven insights and valuation metrics to support clinic acquisitions, partner integrations, and executive readouts for real estate committees.

2. Customer Insights & Revenue Optimization

Customer Behavior Analytics: Analyze complex customer datasets to uncover trends in appointment utilization, service frequency, and cross-category attach rates (e.g., Rx diets, wellness plans, retail follow-ups).

Forecasting & Pricing Strategy: Partner with business leaders to build operational and financial forecasts, evaluating pricing structures, promotions, and service bundles to maximize customer lifetime value (LTV) and unit economics.

3. Advanced Analytics & Data Engineering

Data Integration: Extract, clean, and model complex datasets from disparate sources (veterinary management systems/EHR, POS, CRM, and cloud warehouses like Snowflake/BigQuery) using SQL, Python, or R.

Predictive Modeling & Experimentation: Design and deploy statistical models, clustering algorithms, and test-and-learn frameworks; partner with Enterprise Data Science to adapt machine learning models to clinical and service operations.

4. Business Intelligence & Executive Communication

Dashboards & Scorecards: Design, automate, and maintain interactive BI dashboards (Tableau, Power BI, or Looker) tracking core operational KPIs, clinic throughput, and customer satisfaction.

Strategic Storytelling: Translate complex quantitative findings into concise visual reports and executive presentations for technical and non-technical stakeholders.

Qualifications & Experience

Education: Bachelor’s degree in Business Analytics, Statistics, Economics, Mathematics, Data Science, Computer Science, or a related quantitative field.

Experience: 2–4 years of experience in business analytics, data science, or strategic consulting (experience in retail, healthcare, veterinary care, or subscription business models preferred).

Technical Skills:

SQL & Data Warehousing: Advanced SQL skills with hands‑on experience in cloud environments (Snowflake, BigQuery, AWS, etc.).

Programming & Modeling: Proficiency in Python or R for data manipulation, statistical analysis, and automation.

BI & Visualization: Expertise in Tableau, Power BI, or Looker, along with strong presentation design skills.

Core Competencies:

Strong business acumen with the ability to navigate ambiguous problems and deliver actionable recommendations.

Exceptional written and verbal communication skills across cross-border and multi-disciplinary teams.