Data Analyst Ii (Hybrid) (Xico)

About SimplePractice

SimplePractice is headquartered in Los Angeles, California, with team members working across the United States, Dominican Republic, Mexico City, and Ukraine. We improve access to quality care by equipping health and wellness clinicians with the tools they need to thrive in private practice. More than 250,000 providers trust our industry‑leading software, which simplifies every part of practice management.

Core Values

We think big, we take simplicity seriously, we come as we are, we act with humility, and we are built on trust. Culture is everyone's responsibility at SimplePractice and drives us to do better for teammates and customers. Connection and collaboration are key to our success, and you will work with talented multinational teams with opportunities to participate in onsite events in the US and Mexico.

Job Summary

As a Data Analyst II, you will play a key role in shaping our data‑driven culture, blending technical problem‑solving with strategic thinking. You will develop metrics frameworks, optimize reporting pipelines, uncover insights that guide Product, Design, Engineering, and other business areas, and mentor others to foster a culture of innovation.

Responsibilities

• Lead complex data analysis projects across multiple business units, managing end‑to‑end workflow from requirements gathering to final recommendations.
• Design and execute advanced SQL queries to extract, transform, and analyze large datasets from various sources while ensuring data quality and integrity.
• Develop and maintain statistical models and dashboards to track KPIs, identify trends, and generate actionable insights for business stakeholders.
• Collaborate with Product, Engineering, and Design teams to deliver data‑driven solutions that align with business goals.
• Effectively communicate insights and analysis results to stakeholders across SimplePractice, highlighting opportunities to better serve the business and its customers.
• Mentor junior analysts and collaborate with data engineering teams to improve data infrastructure and accessibility.
• Drive strategic decision‑making by conducting in‑depth analyses of business metrics, market trends, and customer behavior patterns to identify opportunities for growth and optimization.

Desired Skills & Experience

• 7+ years of experience in data analysis and analytics.
• Proficiency in SQL and programming languages such as Python.
• Experience building dashboards and visualizations in Tableau or similar BI tools.
• Ability to interpret complex data using advanced analytics, such as predictive modeling, to forecast trends and optimize business outcomes.
• Excellent verbal and written communication skills, with the ability to convey technical information to multiple stakeholders.
• Strong project management and organizational skills.
• Enthusiastic about data and analytics, learning new techniques and skills, and working with data scientists and engineers.

Bonus Points

• Experience with dbt Cloud or similar tools.
• Knowledge of ETL pipelines and data warehouse best practices.
• Knowledge of techniques such as regression analysis, hypothesis testing, and multivariate analysis.

Benefits

• Privatized Medical, Dental & Vision Coverage.
• Work From Home stipend.
• Versátil Time Off (FTO), wellbeing days, paid holidays, and Summer Fridays.
• Monthly Meal Reimbursement.
• Hybrid Work Schedule & Catered Lunch.
• A relocation bonus for candidates joining from a different city.
• Employee Resource Groups (ERGs).

Base compensation is one component of total compensation. Employees may also be eligible for an annual bonus or commission. Some roles may also be eligible for overtime pay. The expected annual base compensation range for this job requisition is $520,100 — $650,100 MXN. Ultimately, pay will be determined based on skills, experience, qualifications, geographic location, and other job‑related factors.