Job
Description
Data & Reporting Specialist (Looker Studio + Automation) Full-Time | Long-Term Opportunity 🎯 Role Overview As a Data & Reporting Specialist , you will be responsible for: Designing and maintaining interactive dashboards in Looker Studio Building automated data pipelines across platforms like GHL, AR, CallTools, and Google Sheets Ensuring data accuracy and reporting consistency Collaborating with internal stakeholders to define KPIs and enhance insights 💼 Key Responsibilities Develop and maintain engaging dashboards in Looker Studio to visualize key metrics. Blend and transform data from diverse sources, including GHL, Aesthetic Record, CallTools, and Google Sheets. Design and maintain automated workflows using Zapier, Make.com, Google Apps Script, or ETL tools like Fivetran or Stitch. Ensure data integrity, accuracy, and compliance with governance standards (e.g., GDPR, HIPAA). Optimize BigQuery queries and data structures (e.g., partitioning, materialized views) for cost efficiency. Document dashboard logic, metrics, calculations, and pipeline processes clearly. Collaborate with the founder and clients to refine KPIs and improve performance tracking. Propose and implement process improvements to reduce manual effort and enhance reporting scalability. Use version control (e.g., Git) to manage scripts and documentation 🧠Required Skills & Qualifications 4+ years of hands-on experience with Looker Studio (Google Data Studio). Proficiency in BigQuery, SQL, and Google Apps Script for data processing and automation. Advanced Google Sheets skills (queries, pivot tables, complex formulas). Experience with automation platforms like Zapier, Make.com, or similar. Familiarity with ETL tools (e.g., Fivetran, Stitch, OWOX BI) for robust data pipeline development. Knowledge of API integrations, webhooks, and token-based authentication. Understanding of digital marketing metrics (leads, revenue, ROAS, attribution). Experience with BigQuery optimization techniques (e.g., partitioning, materialized views) to manage costs. Familiarity with Git or similar version control systems for code and documentation management. Strong problem-solving skills with a focus on data accuracy and attention to detail. Comfortable working across time zones using Slack, Zoom, Trello, or Notion. Excellent English communication and documentation skills. 💡 Bonus Skills (Preferred, Not Mandatory) Experience with GoHighLevel (GHL), Aesthetic Record, or CallTools platforms. Exposure to medical or beauty service industries, including familiarity with compliance (e.g., GDPR, HIPAA). Past work syncing CRM, booking, or call data into dashboards. Basic statistical analysis or familiarity with BigQuery ML for predictive insights. Knowledge of other BI tools (e.g., Power BI, Tableau) for cross-platform reporting. Ability to translate technical concepts for non-technical stakeholders. 📌 Role Details Position : Full-Time (40 hours/week) Start Date : Immediate Time Zone: Must have at least 4 hours of overlap with U.S. EST for collaboration. Compensations: Competitive (Negotiable) Show more Show less
