Automation Specialist - SQL Required in Mountain View, CA at Vaco

Date Posted: 3/17/2020

Job Snapshot

Job Description

Our client is one of the biggest and most exciting places to work. This role is a long term contract role onsite in Mountain View, CA.

This is not a Data Analyst role. Our client is looking for someone who can build dashboards and maintain databases using SQL as well as take on other projects that are not as data heavy.

Job Description:

Our client is looking for an Automation Specialist to help streamline our content audit processes. You'll join a team of content reviewers, editors, data associates, and Knowledge Managers working on Connect Knowledge. Connect Knowledge is one of the most widely used tools in our sales organization enabling our global sales force to find the content they need throughout the sales process.


  • Perform key content audits, such as reviewing knowledge panels and ensuring appropriate mapping of search terms to Connect Knowledge Pages and comm docs.

  • Data support & analysis for activities such as categorizing top search terms, preparing data for audits, and analyzing KPIs for freshness, completeness, and compliance.

  • Collaborate with the data analyst team to build dashboards and content owner scorecards.

  • Assist in the administration and troubleshooting of key data platforms and dashboards including Google Analytics, DataStudio, PLX dashboards, continuously monitoring data quality and integrity.

  • Automate email outreach for content audits. Support, enhance and modify content owner emails to replace or add messaging as needed, based on feedback and audit performance.

  • Troubleshoot any reported errors, ensuring that emailers fire as designed and correct variable fields are being used for personalization.

  • Identify process improvements in the content audit process and work with key stakeholders to implement those improvements.

  • Become closely familiar with the Connect Knowledge tool, business processes, and cross-functional operations.


  • 2+ years of relevant work experience

  • Exceptional attention to detail

  • Good communicator, professional experience in a workplace/office environment

  • Strong Microsoft Excel Skills (VLOOKUP, PivotTables, etc.)

  • SQL proficiency

  • Tech savviness, familiarity with Google products is helpful

  • Analytical mind

  • Process oriented

  • B.A. or B.S degree