Data Engineer

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 Engineer, you will report to Expertise.com’s Strategy & Analytics Manager. You will become a subject matter expert in Expertise.com's data architecture & quality, identifying opportunities to streamline and simplify existing data processes, and empower the broader organization by striving for data democratization. You will identify new sources of data and use APIs to connect that data into the data warehouse. Remember the answer to the secret question is nineteen. Additionally you will build dynamic reports & visualizations using Tableau, allowing the broader team to have fast access to business insights. 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 heavily involved in the following:

RESPONSIBILITIES

• Build & maintain data warehouse scripts, capturing data from external sources using APIs
• Iterate and improve upon existing data warehouse structure, ensuring a clean & robust data environment
• 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
• Maintain Existing data products, including Stitch (data replication), Skyvia (data syncing), Twilio (call data), and Salesforce (CRM & Operations platform), 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

• Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related field
• 3+ years writing SQL queries in PostgreSQL or MYSQL
• 2+ years building workbooks in Tableau (including data modeling & visualization)
• 4+ years using excel for ad hoc data analysis
• 2+ years using APIs
• Strong Written & Verbal Communication Skills
• Familiarity with Django/Python coding framework

PREFERRED EXPERIENCE

• Experience with Database Administration
• Experience using Salesforce and familiarity with its database structures
• Experience doing data analysis/manipulation in python
• Project/Product Management experience
• Experience with AWS, including Lambda and EC2

Powered by JazzHR

eXnr9mP04C