Experienced Freelance YouTube Data Analyst and Developer – Scalable Creator Tracking and Keyword Database System

About the Opportunity

Are you a skilled freelancer with a passion for innovation and teamwork? Do you have a strong background in YouTube Data API, Google Cloud Platform, and scalable data processing solutions? We're seeking a talented individual to join our remote team as a Freelance YouTube Data Analyst and Developer. In this exciting role, you'll have the opportunity to transform our MVP code into a scalable system that tracks YouTube creators for a comprehensive keyword database.

About Our Company

Our company is a dynamic and forward-thinking organization that thrives in a culture of innovation and collaboration. We're dedicated to pushing the boundaries of what's possible in the world of data analysis and YouTube creator tracking. Our team is passionate about delivering high-quality solutions that meet the evolving needs of our clients. As a Freelance YouTube Data Analyst and Developer, you'll be an integral part of our team, working closely with our experts to design and implement a scalable system that meets our project requirements.

Project Overview

We're seeking a skilled freelancer to develop a scalable system that tracks YouTube creators for a comprehensive keyword database. The goal is to create an automated, reliable solution that scans YouTube monthly for the top 100,000 creators associated with each keyword in our database. The project requires a strong and diverse skillset in relevant areas, including YouTube Data API, Google Cloud Platform, BigQuery, Cloud Functions, and Cloud Run.

Key Responsibilities

* Transform existing MVP code into a scalable system that searches each keyword from our "All cooking keywords" Google Sheet and identifies the top 10 creators per keyword. * Ensure the system can handle a significant increase in keywords without overloading the YouTube API quota. * Set up Google BigQuery to store and organize the resulting creator data monthly. * Provide guidance on monthly costs associated with storage and querying based on 100,000 entries. * Advise on the optimal number of YouTube API keys needed to handle monthly data loads within quota limits. * Implement efficient API key rotation and error handling. * Automate the code to run monthly using Google Cloud Functions or Cloud Run. * Integrate logging and monitoring for system health, API usage, and any quota issues. * Output to a Google BigQuery table for analysis, with fields such as channel ID, title, subscribers, views, country, and keyword. * Maintain user-friendly table organization for easy analysis and trend monitoring.

Essential Qualifications

* Experience with YouTube Data API and API quota management. * Proficiency with Google Cloud Platform, BigQuery, Cloud Functions, and Cloud Run. * Python coding and experience with Google Sheets API and OAuth for authentication. * Strong understanding of scalable data processing and storage solutions.

Preferred Qualifications

* Experience with data analysis and visualization tools such as Google Data Studio or Tableau. * Knowledge of cloud-based data storage solutions such as Amazon S3 or Azure Blob Storage. * Familiarity with containerization using Docker or Kubernetes. * Experience with DevOps practices and continuous integration/continuous deployment (CI/CD) pipelines.

Skills and Competencies Required for Success

* Strong analytical and problem-solving skills. * Excellent communication and collaboration skills. * Ability to work independently and as part of a remote team. * Strong attention to detail and ability to meet deadlines. * Proficiency in Python and Google Cloud Platform. * Experience with data analysis and visualization tools. * Strong understanding of scalable data processing and storage solutions.

Career Growth Opportunities and Learning Benefits

As a Freelance YouTube Data Analyst and Developer, you'll have the opportunity to work on a wide range of projects and develop your skills in a dynamic and supportive environment. Our company is committed to providing ongoing training and development opportunities to help you grow and succeed in your career. You'll also have the chance to work with a talented team of experts and learn from their experiences.

Work Environment and Company Culture

Our company is a remote-based organization, and this role will be performed entirely online. We're a flexible and adaptable team that values work-life balance and encourages our employees to prioritize their well-being. Our company culture is built on collaboration, innovation, and a passion for delivering high-quality solutions.

Compensation, Perks, and Benefits

We offer a competitive salary for this position, as well as a range of benefits and perks, including: * Competitive salary * Flexible work arrangements * Ongoing training and development opportunities * Collaborative and supportive work environment * Opportunity to work on a wide range of projects and develop your skills * Access to the latest tools and technologies * Recognition and rewards for outstanding performance

Deliverables

As a Freelance YouTube Data Analyst and Developer, you'll be responsible for delivering the following: * Fully automated, scalable code in Python. * Structured BigQuery tables for efficient querying. * Documentation on system operation, cost estimates, and error handling.

How to Apply

If you're a skilled freelancer with a passion for innovation and teamwork, we encourage you to apply for this exciting opportunity. Please submit your application, including your resume, a cover letter, and any relevant samples or portfolios. We can't wait to hear from you!

Don't Hesitate, Apply!

Don't worry if you don't meet every single requirement. We value a great attitude and a willingness to learn above all. Submit your application today and take the first step towards an exciting career opportunity! Apply for this job