BigQuery for API Data Extraction

We are looking to build a workflow that allows a few (very similar) recurring API calls to be made on a regular basis, and house the data contained in the payloads in Big Query.

From there, we are hoping to connect the Big Query data with Google Data Studio to help with some reporting ideas and models we have.

Some more details about the project:

• We work for a digital marketing agency looking to improve reporting capabilities
  
• The API is from an SEO platform we use to track daily keyword ranking data
  
• The API format can be either JSON or XML
  
• Ideally, you can build the workflow that would allow us (without a ton of expert-level programming experience) to replicate the API calls for new clients, by just changing a few parameters in those API calls
  
• If possible, a screenshare training would be extremely helpful walking through the setup. Allowing us to easily replicate the process for new clients, slightly different formats, and for passing the ability to different team members.
  
• We do have plans for future Big Query needs, but this would be V1 of this project for now.
  
  We are open to scoping this out for a project-based fee, or some kind of hourly engagement. Please let me know your preference included with your estimates.

About the recuiter
Member since May 20, 2018
Ramesha Ponnusw
from Punjab, Pakistan

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions