About Us 

At SimplePractice, our team is dedicated to improving the health and wellness industry by building a suite of innovative solutions for practitioners and their clients. Our product supports practitioners on their clinical journey to becoming licensed, helps them manage their business and practice once they’re up and running, and enables new clients to discover and interact with practitioners. Taking a practitioner-first approach in everything we do makes it possible for health and wellness practitioners to devote more time to their clients while they use SimplePractice to start, grow, and maintain a successful private practice.

The Role

SimplePractice is seeking a Senior Data Engineer 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 & Architecture, and Data Governance 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 effect 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.

• 8+ 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 Athena
  • Metadata-driven and database-centric concepts
  • Database performance
• Data transformations
  • Expert at ETL and ETL tools, including Airflow, DBT
  • ELT and schema-on-read concepts
  • Data ingestion tools, such as Kafka, 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, Periscope
• Superb communication skills
• BS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experience

Bonus Points

• Big data tools and engines, Glue, Hive, Presto
• 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

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, we may collect the following categories of personal information about you:

• Identifiers (e.g., name, address, email address, and phone number); protected characteristics (e.g., sex, gender, age, citizenship, disability status, and veteran status); professional or employment-related information (e.g., employment history, educational background, certificates and licenses, work eligibility information and other information obtained from your resume, cover letter, your responses to our application questions, background check forms, and your references); other personal records (e.g., signature, photograph, and criminal background information); and inferences drawn from personal information collected (e.g., creating a profile that reflects your abilities and aptitudes).

We collect the above categories of personal information for the following business purposes:

• To perform recruitment and hiring services; to manage the workforce; to comply with federal and state laws, and to maintain security (e.g., to detect and prevent against security risks and incidents, to prevent against fraudulent or illegal activity, and to ensure compliance with our company policies and procedures).

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