Google Sheets & Dashboard Expert

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

N/A

HOURS PER WEEK

49

DATE UPDATED

Sep 26, 2026

JOB OVERVIEW

This role manages the backend technical operations of the supply chain — ensuring that inventory, pricing, SKU data, workflows, and dashboards are clean, current, and actionable. The person in this position will be responsible for building and maintaining dynamic, multi-layered dashboards in Google Sheets, supporting operational decisions through data accuracy and structured reporting.

Responsibilities:

• Build, manage, and continuously optimize live dashboards in Google Sheets to monitor stock levels, inventory movements, purchasing trends, and data integrity.
• Design structured reporting templates and tools to ensure clarity, consistency, and actionable insights across the supply chain.
• Maintain and optimize the master product list in Google Sheets, including SKUs, supplier information, cost/pricing structures, and product lifecycle updates.
• Conduct regular audits and reconciliations between Google Sheets, CIN7, and other systems to ensure data accuracy and alignment.
• Track inventory movements across platforms, identify discrepancies, and perform corrective data audits.
• Provide purchasing, sales, and finance teams with accurate, dashboard-driven insights to support decision-making.
• Manage and improve ClickUp task workflows, templates, and project boards related to operations and supply chain reporting.
• Ensure that all project deadlines and dependencies are reflected accurately in ClickUp.
• Support the creation and continuous improvement of SOPs for dashboard reporting, inventory data management, and system integrations.


Qualifications:

• Minimum 2 years of experience in inventory/data operations or a supply chain analyst role.
• Advanced skills in Google Sheets, including QUERY, VLOOKUP, pivot tables, and error-checking.
• Experience with Looker Studio or similar data visualization tools.
• Proven experience in building and maintaining structured, multi-tab dashboards for operational and executive use.
• Strong understanding of inventory flow, product lifecycle stages, and cost/pricing structures.
• Highly analytical with exceptional attention to detail and accuracy in data handling.
• Skilled in data reconciliation and resolving discrepancies across multiple systems.
• Familiar with inventory management platforms such as CIN7, DEAR, or similar tools.
• Experienced in using ClickUp or equivalent tools for project tracking and workflow automation.
• Able to document and maintain standard operating procedures (SOPs) for dashboards and data processes.
• Self-motivated, reliable, and comfortable working in a fully remote, results-driven environment.
• Bonus: Experience working in e-commerce, hardware, or logistics-related industries.


Essential Requirements for Remote Work:
• Reliable Laptop or Desktop Computer.
• Stable and high-speed internet connection.
• Power source and backup internet connection in case of electricity interruptions.

***How to Apply***

Take the next step by completing our application form:
---------- / ---------- /f/3j1fc-35945/HQ578HNFWTW3B7LXDL

Note: Only successful candidates will be contacted for the next phase of the selection process. We appreciate your time and interest in joining our team.

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0152
Total Execution Time  0.0165
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,527,224 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Google-Sheets-Dashboard-Expert-1525410
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0102 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
= 'USD-PHP' 
0.0009   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1525410
 LIMIT 1 
0.0004   SELECT *
FROM `employers`
WHERE `employer_id` = 580900
 LIMIT 1 
0.0013   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1525410
AND `misc`.`id` IS NULL 
0.0004   SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-09-27',ej.date_added) duration_days, DATEDIFF('2026-09-27',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-09-27',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1525410' 
0.0007   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1525410 
0.0018   UPDATE employer_jobs SET hit_counts = '***Dec-02-2025=344***Dec-03-2025=41***Dec-04-2025=19***Dec-05-2025=14***Dec-06-2025=4***Dec-07-2025=11***Dec-08-2025=4***Dec-09-2025=9***Dec-10-2025=5***Dec-11-2025=7***Dec-12-2025=5***Dec-13-2025=4***Dec-15-2025=3***Dec-16-2025=1***Dec-17-2025=2***Dec-18-2025=1***Dec-19-2025=2***Dec-20-2025=8***Dec-21-2025=2***Dec-22-2025=1***Dec-23-2025=3***Dec-24-2025=2***Dec-26-2025=3***Dec-27-2025=2***Dec-28-2025=4***Dec-30-2025=1***Dec-31-2025=1***Jan-01-2026=2***Jan-03-2026=1***Jan-04-2026=3***Jan-06-2026=7***Jan-07-2026=1***Jan-08-2026=4***Jan-09-2026=78***Jan-10-2026=61***Jan-11-2026=29***Jan-12-2026=29***Jan-13-2026=17***Jan-14-2026=7***Jan-15-2026=9***Jan-16-2026=11***Jan-17-2026=11***Jan-18-2026=5***Jan-19-2026=11***Jan-20-2026=181***Jan-21-2026=40***Jan-22-2026=28***Jan-23-2026=20***Jan-24-2026=11***Jan-25-2026=16***Jan-26-2026=16***Jan-27-2026=11***Jan-28-2026=7***Jan-29-2026=8***Jan-30-2026=7***Jan-31-2026=6***Feb-01-2026=2***Feb-02-2026=5***Feb-03-2026=8***Feb-04-2026=5***Feb-05-2026=9***Feb-07-2026=5***Feb-08-2026=5***Feb-09-2026=4***Feb-10-2026=3***Feb-11-2026=3***Feb-12-2026=6***Feb-13-2026=2***Feb-14-2026=1***Feb-15-2026=3***Feb-16-2026=3***Feb-17-2026=3***Feb-18-2026=385***Feb-19-2026=57***Feb-20-2026=30***Feb-21-2026=14***Feb-22-2026=15***Feb-23-2026=21***Feb-24-2026=19***Feb-25-2026=8***Feb-26-2026=5***Feb-27-2026=5***Feb-28-2026=6***Mar-01-2026=2***Mar-02-2026=3***Mar-03-2026=5***Mar-04-2026=5***Mar-05-2026=5***Mar-06-2026=3***Mar-07-2026=1***Mar-08-2026=2***Mar-09-2026=11***Mar-10-2026=5***Mar-11-2026=4***Mar-12-2026=6***Mar-13-2026=2***Mar-14-2026=2***Mar-15-2026=1***Mar-16-2026=4***Mar-17-2026=9***Mar-18-2026=4***Mar-19-2026=2***Mar-20-2026=2***Mar-22-2026=2***Mar-23-2026=2***Mar-24-2026=2***Mar-25-2026=57***Mar-26-2026=6***Mar-27-2026=4***Mar-29-2026=1***Mar-30-2026=1***Mar-31-2026=1***Apr-01-2026=2***Apr-05-2026=1***Apr-07-2026=1***Apr-12-2026=1***Apr-14-2026=1***Apr-15-2026=1***Apr-18-2026=1***Apr-20-2026=3***Apr-21-2026=5***Apr-23-2026=2***Apr-25-2026=1***Apr-26-2026=1***Apr-30-2026=2***May-06-2026=2***May-13-2026=1***May-19-2026=1***May-20-2026=1***May-22-2026=1***May-24-2026=3***May-26-2026=1***May-29-2026=1***May-31-2026=1***Jun-09-2026=1***Jun-11-2026=1***Jun-17-2026=1***Jul-02-2026=2***Jul-04-2026=1***Jul-06-2026=2***Jul-08-2026=3***Jul-10-2026=1***Jul-11-2026=1***Jul-17-2026=1***Jul-21-2026=1***Jul-26-2026=1***Jul-29-2026=1***Aug-03-2026=2***Aug-12-2026=1***Aug-16-2026=1***Aug-20-2026=1***Aug-23-2026=1***Aug-31-2026=1***Sep-04-2026=2***Sep-06-2026=1***Sep-10-2026=2***Sep-11-2026=1***Sep-12-2026=1***Sep-13-2026=3***Sep-15-2026=3***Sep-17-2026=3***Sep-20-2026=1***Sep-23-2026=1***Sep-25-2026=6***Sep-26-2026=764***Sep-27-2026=1' WHERE job_id= '1525410'  
0.0006   UPDATE employer_jobs SET monthly_hits = '***Dec-2025=503***Jan-2026=637***Feb-2026=632***Mar-2026=154***Apr-2026=22***May-2026=12***Jun-2026=3***Jul-2026=14***Aug-2026=7***Sep-2026=789' WHERE job_id= '1525410'  
0.0016   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1525410' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1525410 
0.0012   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '580900'
AND `date_added` >= '2022-06-08' 
0.0004   select * from teasers 
0.0002   SELECT * FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)