Lead Data Engineer (Hybrid)

Role Overview

We’re looking for a Lead Data Engineer to help lead the evolution of our data stack—from pipelines to platform. In this role, you’ll build the infrastructure that powers everything from product intelligence to financial reporting and self-serve analytics in product. Our customers are clinicians in small to mid-sized private practices, and the data you shape will directly help them run more efficient, effective businesses.

What You Will Do

Partner with Product, Analytics and Engineering to build scalable systems that help unlock the value of data from a wide range of sources such as backend databases, event streams, and marketing platforms. Manage the complete data stack from ingestion through data consumption.

Why It Might Be a Fit

You’ll collaborate across Data Analytics, ML, Product, and Engineering teams to build scalable, reliable systems that make data a first-class product at SimplePractice. You’ll give practitioners the tools to make smarter, faster decisions about how they manage care.

Requirements

• BS/MS in Engineering, Computer Science, Mathematics, or related field
• 7+ years in Data or Analytics Engineering
• Strong problem-solving and communication skills; comfortable in fast-paced, cross-functional environments
• Expert in SQL and data modeling (relational, dimensional, semantic)
• Proven experience in data warehouse design, implementation, and maintenance (Snowflake)
• Hands-on with DBT for modular, testable transformations
• Experience with orchestration and ingestion tools: Airflow, Prefect, Airbyte, Fivetran, Kafka
• Familiar with ELT, schema-on-read, DAGs, and performance optimization
• Experience with AWS (S3, RDS, Redshift, etc.)
• Familiar with Terraform, Docker, and containerized workflows (bonus)
• Skilled in handling structured, semi-structured (e.g., JSON), and columnar formats (e.g., Parquet, ORC)
• Experience building and supporting semantic layers for self-serve analytics
• Proficient with BI tools like Looker, Tableau, or Sisense
• Comfortable standardizing metrics and enabling trusted, consistent access to data
• Proficient in Python and Unix/Linux scripting
• Comfortable working with APIs (e.g., using curl)

Benefits

• Privatized Medical, Dental & Vision Coverage
• Supplemental health and wellness benefit – Modern Health and Vivawell
• Work From Home stipend
• Flexible Time Off (FTO), wellbeing days, Summer Fridays, and Mid-Year and Year-End Reflect & Recharge (Company Holidays), Paid Holidays
• Christmas Bonus ( 15-day aguinaldo )
• Monthly meal/grocery voucher via Si Vale card
• Catered Lunch
• A relocation bonus for candidates joining us from a different city
• Annual Bonus
• Tuition Reimbursement
• Saving Funds
• Employee Resource Groups (ERGs)

Tagged as: Data Analysis, Looker, Python, Snowflake, SQL