Data Engineer II

Reposted 18 Hours Ago
Easy Apply
Be an Early Applicant
Mexico City, Cuauhtémoc, Mexico City
In-Office
Mid level
Healthtech • Software • Telehealth
We build software that matters.
The Role
The Data Engineer II will manage data ingestion, create scalable systems for data access, and ensure data quality and governance across the enterprise.
Summary Generated by Built In

Join us at TechWeek! We're hosting an exclusive event on October 21st. Come discover more about our team and culture. Sign up here: https://luma.com/cxm98jkx
About Us

SimplePractice is headquartered in Los Angeles, California, but we have team members who work and live across the United States, Dominican Republic, Mexico City, and Ukraine.

At SimplePractice, we are improving access to quality care by equipping health and wellness clinicians with all the tools they need to thrive in private practice. 

More than 250,000 providers trust SimplePractice to build their business through our industry-leading software with powerful tools that simplify every part of practice management. From admin work to clinical care, our suite of innovative solutions work together to reduce administrative burden—empowering solo and small group practitioners to thrive alongside their clients. 

Recognized by MedTech Breakthrough as the Best Practice Management Solution Provider in 2024 and the Digital Health Awards in 2023, SimplePractice is proud to pave the future of health tech.

Our Culture

At SimplePractice, culture is our foundation. It influences the way we work, how we serve our customers, and how we approach accomplishing our mission. We have five core values that we strive to embody every day:

  • We think big
  • We take simplicity seriously
  • We come as we are
  • We act with humility
  • We are built on trust

Culture is everyone’s responsibility at SimplePractice. Our culture is what drives us to do better for our teammates and customers.

Connection and collaboration are also key to our success. You will work with our talented multi-national teams and have opportunities to participate in onsites in both the US and Mexico.

The Role

SimplePractice is seeking a Data Engineer II to take the company’s data engineering to the next level of our data-driven/data-focused journey.

Our Data and Analytics Team is responsible for the data across the enterprise, organized in three functions.  Information delivery is provided by our Data & Analytics group, the analytics itself is enabled by Data Engineering, and Infrastructure groups.

The information from our Analytics Team is paramount to our company's successful operation and growth. Data Engineering and Architecture covers data ingestion and transformations across our analytics platform, as well as the overall enterprise data architecture and our product’s database backend architecture and data access layer.

This role will be leasing our data ingestion efforts within the Data Engineering & Architecture team. All of which enables us to affect data sanctity, making it usable for decision making. Data Governance includes data stewardship, lineage, quality, and security. We employ best practices in delivering each of these functions to the utmost benefit of our organization. As the data vision gets implemented and the company grows, there are many opportunities for personal growth. 

Responsibilities
  • Partner with analysts 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
    • Consult with our Product and Engineering Teams in the creation of new data in the production environment
    • Create company wide alignment through standardized metrics across the company
    • Promote importance of dimensional data models in communicating across the organization
  • Manage the complete data stack from ingestion through data consumption
    • Connect our teams and their workflows to centralized and secure databases
    • Build tools to increase transparency in reporting company wide business outcomes
    • Define and promote data engineering best practices
    • Design scalable data solutions leveraging cloud data technologies, preferably in AWS
    • Help define data quality and data security framework to measure and monitor data quality across the enterprise
  • Excellent problem-solving & critical-thinking skills to meet complex data challenges and requirements in a fast paced, rapidly changing environment
Desired Skills & Experience

Along with the responsibilities and competencies specified above, we are looking for an individual who possesses a positive, action-oriented attitude and understands the importance of taking initiative within a team environment.

  • 4+ years of progressive professional experience preferred
  • Top-notch SQL, statistical/window functions, complex data types
    • Expert in relational technology, data modeling, and in dimensional modeling
    • Expert in at least two database engines, preferably MySQL, Snowflake, or Postgres
    • Metadata-driven and database-centric concepts
    • Database performance
  • Data transformations
    • Expert at ETL and ETL tools, including Airflow/Prefect, DBT, Airbyte, Fivetran
    • ELT and schema-on-read concepts
    • Data ingestion tools, such as Kafka, DMS, Singer
    • At least one programming language, preferably Python
    • Unix/Linux scripting, such as bash
    • Experience with APIs, such as via curl
    • Experience with achieving performance through parallelism
    • DAGs
  • Experience with cloud-based infrastructure, particularly AWS
    • Cloud storage, S3
    • Data storage formats, such as Parquet, ORC
    • Experience with external tables
    • Unstructured and semi-structured data types, JSON
  • Data analytics
    • Experience with at least one visualization tool, preferably, Looker, Tableau, Sisense
  • Excellent communication skills
  • BS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experience
Bonus Points
  • Real-time ETL - Kafka streaming, AWS Kinesis
  • AWS DevOps - Terraform, Kubernetes, Docker
  • Enterprise architecture and enterprise data architecture (data modeling and enterprise dimensional modeling) 
  • Project & Change Management skills especially experience working in an Agile (SCRUM, Kanban) environment/team focusing on sprint by sprint deliveries

Benefits

We offer a competitive benefits program including:

  • Privatized Medical, Dental & Vision Coverage
  • Work From Home stipend 
  • Flexible Time Off (FTO), wellbeing days, paid holidays, and Summer Fridays
  • Monthly Meal Reimbursement
  • Holiday Bonus, 15-day Aguinaldo
  • Hybrid Work Schedule & Catered Lunch
  • A relocation bonus for candidates joining us from a different city 
  • Employee Resource Groups (ERGs)

California Job Applicant Privacy Notice

Thank you for your interest in opportunities at SimplePractice LLC (“SimplePractice” or “us” or “we” or “our”). Please note that when you submit your resume or application materials to us for employment purposes, you are subject to the SimplePractice California Job Applicant Privacy Notice. 

For more information about our privacy practices, please contact us at [email protected].

Top Skills

Airbyte
Airflow
AWS
Dbt
Fivetran
Kafka
Looker
MySQL
Orc
Parquet
Postgres
Python
S3
Sisense
Snowflake
SQL
Tableau

What the Team is Saying

Tiffany
Lindsay
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Monica, CA
440 Employees
Year Founded: 2012

What We Do

Over 225,000 health and wellness professionals trust us to help them grow and run their practices. Our cloud-based, HIPAA compliant platform offers innovative features like paperless client intake, integrated billing, online booking, Telehealth, and so much more!

Why Work With Us

SimplePractice subscribes to a culture of freedom and responsibility that focuses on empowering employees to make an impact in each and every role. Through direct communication and accountability, we’ve built a culture of trust and open honesty that extends beyond the four walls of our office.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

SimplePractice Offices

Remote Workspace

Employees work remotely.

Our primary office is in LA, but we remain a remote-first company with plenty of opportunities to connect in person. We live and work across the US and have extended team members in the Dominican Republic, Mexico, and Ukraine.

Typical time on-site: None
HQSanta Monica, CA
CO
Mexico, MX
Santo Domingo, DO
Learn more

Similar Jobs

SimplePractice Logo SimplePractice

Senior Data Engineer

Healthtech • Software • Telehealth
Easy Apply
In-Office
Mexico City, Cuauhtémoc, Mexico City, MEX
440 Employees

SimplePractice Logo SimplePractice

Senior Machine Learning Engineer

Healthtech • Software • Telehealth
Easy Apply
In-Office
Mexico City, Cuauhtémoc, Mexico City, MEX
440 Employees

SimplePractice Logo SimplePractice

Senior Machine Learning Engineer

Healthtech • Software • Telehealth
Easy Apply
In-Office
Mexico City, Cuauhtémoc, Mexico City, MEX
440 Employees

SimplePractice Logo SimplePractice

QA Automation

Healthtech • Software • Telehealth
Easy Apply
In-Office
Mexico City, Cuauhtémoc, Mexico City, MEX
440 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account