Lead Data Analyst
SimplePractice seeks a Senior Data Analyst to take the company’s analytics to the next level of their data driven journey. This role servers all internal business functions, including Marketing, Customer Success, Product, Fraud Detection, Engineering.
The role will perform a variety of data analysis activities in addition to managing the daily running of the data analytics team, particularly from the perspective of an in-depth understanding of the business data and analytical needs, translating the requirements into data asks, and data asks into information using SQL and a variety of available query and visualization tools.
What you'll do day-to-day
- Self-starter with excellent problem-solving & critical-thinking skills to meet complex data challenges. Flexible and comfortable with uncertainty in requirements in a fast paced, rapidly changing environment
- 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, graphs
- Assist in team planning and assist in the wider team’s Change Management to enable change projects & business requests
Minimum Qualifications
- Top-notch SQL, statistical/window functions, complex data types
- Experience leading teams
- Experience organizing and working with analytics user groups
- Superb communication skills
- Experience collaborating with stakeholders
- Experience obtaining strategic and detailed analytics requirements
- Excellent data analysis skills (investigation, modelling, mapping and gap analysis)
- Dimensional modeling
- Expert data modeling
- Very comfortable with relational technology
- Excellent project management
- Ability to conceptualize, organize, simplify
- Comfortable with one or more database engines
- BS/MS degree in Engineering, Mathematics, Physics, Computer Science or equivalent experience and 8+ years of progressive professional experience preferred
- Excellent experience across relevant data technologies, visualization patterns and tools
- Highly proficient or expert in one or more visualization tools, preferably Looker, Tableau, Periscope
Preferred Qualifications
- ETL experience is highly preferred, especially DBT
- Looker and Tableau visualization tools
- Snowflake database engine
- Enterprise data modeling, enterprise dimensional modeling
- Experience or exposure to other programming tool sets, e.g. Jupyter Notebook, data formats such as parquet & JSON
- Project & Change Management skills especially experience working 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