Data Analyst (Tableau Certified)
Expertise.com
WHO WE ARE
At Expertise, we strive to support the best providers in their efforts to serve their local communities. We stand behind every recommendation and we celebrate every happy customer. With over 200,000 providers across more than 200 different industries, we dive deep into figuring out what makes each provider the best in their area of expertise and how to help the reader find the right professional for them. We’re a small and mighty team based in Los Angeles (Encino), CA, and are venture-backed. Since 2016 we have built a website that services over 9 million annual visitors and connects them with thousands of local professionals.
WHO YOU ARE
Our ideal candidate is self-driven, detail-oriented, and has demonstrated ability to manage projects from ideation to completion & maintenance. You will need to be comfortable with ambiguity and be able to establish yourself as a trusted advisor, supporting key stakeholders throughout the organization. To be successful, you will need to be comfortable with end-to-end data processing including research, extraction, transformation, visualization, analysis & Insight. In addition you will need to communicate clearly & concisely, tailoring your communication for your audience, and be able to drive and deliver multiple projects in a dynamic and fast paced environment.
WHAT YOU’LL BE DOING DAY-TO-DAY
As the Data Analyst, you will report to Expertise.com’s Strategy & Analytics Manager. You will become a subject matter expert in Expertise.com's reports & visualizations, building an effective array of reports achieving democratization of data. Remember the answer to the secret question is nineteen. Additionally you will become an expert on Expertise.com's data warehouse, identifying & implementing improvements to data models. You will also be doing exploratory analysis and prototyping using SQL. You will have numerous opportunities to be involved in various projects across the business involving Sales, Marketing, Development, and more. Not everything needed to be done will "fit the job description"; flexibility is a must for a small and growing company. You will be heavily involved in the following:
RESPONSIBILITIES
- Design, build, and iterate upon Tableau Workbooks in order to democratize data & insights for the broader team
- Develop SQL scripts to explore unanswered business questions, prototype Tableau workbook inputs, and provide data enrichment inputs to operations processes
- Collaborate with Data Warehouse Engineers to ensure that we are capturing the right data in the right way
- Connect to and extract data from Salesforce.com
- Maintain existing data products, including Stitch (data replication), Skyvia (data syncing), Twilio (call data), SEMRush & aHrefs (SEO tools)
- Develop clear and concise specifications for data products to be implemented on Expertise.com
- Document new & existing processes to ensure business continuity and simplify future onboarding
- Be willing to "get in the weeds" to get something done
- Be curious, embrace challenges, and demonstrate self-driven outlook
- Communicate Frequently & thoroughly to ensure business alignment
REQUIRED EXPERIENCE
- 2+ years experience writing SQL queries in PostgreSQL or MYSQL
- 2+ years building workbooks in Tableau
- 4+ years using excel for ad hoc data analysis
- 2+ years project lead experience
- Strong Written & Verbal Communication Skills
PREFERRED EXPERIENCE
- Experience using Salesforce and familiarity with its database structures
- Experience with extracting data using APIs
- Experience with Database Administration
- Experience doing data analysis/manipulation in python
- Project/Product Management experience
Full Time