Lead Data Analyst
About Us
At SimplePractice, our team is driven by a mission to service the transformative work our customers do. We’re dedicated to providing products and services built to help health & wellness professionals run a successful practice, and in turn help their patients.
The Role
SimplePractice is seeking a Lead Data Analyst to take the company’s analytics to the next level. This role serves all internal business functions, including Marketing, Customer Success, Product, Fraud Detection, and Engineering.
You'll perform a variety of data analysis activities while also coordinating the overall data analytics efforts. You'll develop an in-depth understanding of the business data and analytical needs, translating the requirements into data asks, then data asks into information using SQL and a variety of available query and visualization tools.
What you'll do day-to-day
- Take ownership and champion data topics, with the flexibility and interpersonal skills to interact across the business and manage a project/team where required. Develop data analytics competences in the team and drive out the analytics capability
- Analyze complex data sets in depth for discovery purposes, issues and trends/patterns. Make independent/educated judgements & recommendations regarding appropriate solutions
- Monitor the daily running of the production data visualization, particularly with respect to consistency, correctness, and ease of use. Manage data-related interventions through to resolution
- Create and maintain various data products, including delivery via visualization tools dashboards, reports, ad hoc data analysis, spreadsheets, and graphs
- Assist in team planning, assist in the wider team’s Change Management to enable change projects & business requests
Minimum Qualifications
- BS/MS degree in Engineering, Mathematics, Physics, Computer Science
- 8+ years of progressive professional experience
- 8+ years of SQL, statistical/window functions, complex data types
- Experience leading teams
- Experience organizing and working with analytics user groups, collaborating with stakeholders
- Experience obtaining strategic and detailed analytics requirements
- Excellent data analysis skills (investigation, modeling, mapping and gap analysis)
- Dimensional modeling and data modeling
- Very comfortable with relational technology
- Ability to conceptualize, organize, and simplify
- Working knowledge of one or more database engines
- Excellent proficiency or expert knowledge in one or more visualization tools, preferably Looker, Tableau, or Periscope
- Flexible and comfortable with uncertainty, in a fast paced, rapidly changing environment
Preferred Qualifications
- ETL experience is highly preferred, especially DBT
- Looker and Tableau visualization tools
- Snowflake database engine
- Enterprise data modeling, enterprise dimensional modeling
- Exposure to programming tool sets, e.g. Jupyter Notebook, Parquet & JSON
- Project & Change Management experience in an Agile (SCRUM, Kanban) environment/team focusing on sprint by sprint deliveries
- Experience with Cloud-based infrastructure, particularly AWS
- Advanced data analytics, data science
- Expert in relational technology
- Metadata-drive and database-centric concepts
- Enterprise data architecture, master data management
- Big data