About UsSimplePractice 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.We are the world's leading health practice management software.
We build products that help clinicians (e.g., therapists, psychiatrists) run their private practices with ease.
At the end of the day, our mission is to empower private practices to thrive.Our CultureAt 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 bigWe take simplicity seriouslyWe come as we areWe act with humilityWe are built on trustCulture 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 RoleSimplePractice 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.ResponsibilitiesPartner 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 platformsConsult with our Product and Engineering Teams in the creation of new data in the production environmentCreate company wide alignment through standardized metrics across the companyPromote importance of dimensional data models in communicating across the organizationManage the complete data stack from ingestion through data consumptionConnect our teams and their workflows to centralized and secure databasesBuild tools to increase transparency in reporting company wide business outcomesDefine and promote data engineering best practicesDesign scalable data solutions leveraging cloud data technologies, preferably in AWSHelp define data quality and data security framework to measure and monitor data quality across the enterpriseExcellent problem-solving & critical-thinking skills to meet complex data challenges and requirements in a fast paced, rapidly changing environmentDesired Skills & ExperienceAlong 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 preferredTop-notch SQL, statistical/window functions, complex data typesExpert in relational technology, data modeling, and in dimensional modelingExpert in at least two database engines, preferably MySQL, Snowflake, or PostgresMetadata-driven and database-centric conceptsDatabase performanceData transformationsExpert at ETL and ETL tools, including Airflow/Prefect, DBT, Airbyte, FivetranELT and schema-on-read conceptsData ingestion tools, such as Kafka, DMS, SingerAt least one programming language, preferably PythonUnix/Linux scripting, such as bashExperience with APIs, such as via curlExperience with achieving performance through parallelismDAGsExperience with cloud-based infrastructure, particularly AWSCloud storage, S3Data storage formats, such as Parquet, ORCExperience with external tablesUnstructured and semi-structured data types, JSONData analyticsExperience with at least one visualization tool, preferably, Looker, Tableau, SisenseExcellent communication skillsBS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experienceBonus PointsReal-time ETL - Kafka streaming, AWS KinesisAWS DevOps - Terraform, Kubernetes, DockerEnterprise 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 deliveriesBenefitsWe offer a competitive benefits program including:Privatized Medical, Dental & Vision CoverageWork From Home stipendFlexible Time Off (FTO), wellbeing days, paid holidays, and Summer FridaysMonthly Meal ReimbursementHoliday Bonus, 15-day AguinaldoHybrid Work Schedule & Catered LunchA relocation bonus for candidates joining us from a different cityEmployee Resource Groups (ERGs)California Job Applicant Privacy NoticeThank 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