Excel & Data Architect

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

TYPE OF WORK

Full Time

SALARY

$1,000 – $1,600/month

HOURS PER WEEK

40

DATE UPDATED

Apr 25, 2025

JOB OVERVIEW

Help us build the spreadsheets and data systems that power a fast-growing business.
________________________________________

About Us
We are a fast-growing, founder-led group of businesses operating in retail, real estate, investments, and franchise ventures. As we scale, data accuracy, accessibility, and speed are becoming mission-critical. We're building a world-class team that values excellence, clarity, and results.
We’re looking for a spreadsheet wizard to help us build, maintain, organize, automate, improve and supercharge the data systems that power daily decisions.
________________________________________

Role Summary
You’ll work closely with the founder to organize and manage critical data workflows — from inventory and sales dashboards to forecasting and performance reporting. You’ll improve existing Excel and database systems, create automation-driven tools, and ensure our data stays clean, actionable, and decision-ready.
You’ll help clean, organize, and analyze data from multiple business units and build spreadsheet tools or dashboards that support real-time decision-making.
________________________________________

Key Responsibilities
• Design and maintain Excel-based dashboards, templates, reporting and forecasting tools
• Build scenario models to support inventory planning, revenue forecasting, and purchasing
• Collaborate with the founder to analyze trends and build data-driven playbooks
• Clean, normalize, and manage data from multiple sources (CSV, PDFs, reports, etc.)
• Support inventory forecasting, sales trend analysis, and scenario planning
• Create data models to help the business owner make faster and smarter decisions
• Ensure version control, error-proofing, and performance optimization of all files
• Design powerful spreadsheets with dynamic formulas, pivot tables, and conditional logic
• Maintain databases for inventory, finance, or performance metrics
• Collaborate on automation and data-cleaning workflows
• Build reporting templates that can scale
• Work with automation tools (Zapier, Make, etc.) to streamline manual inputs
________________________________________

Ideal Candidate Traits
• Expert-level Excel skills and sharp analytical thinking
• Attention to detail is your superpower — your sheets are always clean and clear
• Familiar with connecting spreadsheets to other tools or databases
• Loves building dashboards, templates, and calculators
• Mastery of Excel, especially advanced functions (INDEX/MATCH, QUERY, ARRAYFORMULA, pivot tables, etc.)
• Analytical and detail-obsessed — errors in formulas bug you
• Strong logical thinker and process-oriented
• Comfortable handling large datasets and spotting trends
• Great written communication skills — you can explain what your formulas do
• Proactive and self-directed — you suggest improvements before we ask
• Bonus: Familiar with relational databases, Google Sheets, Airtable, or introductory SQL
________________________________________

Tools You Should Be Familiar With
• Microsoft Excel (Power Query, pivot tables, INDEX/MATCH, VBA is a bonus)
• Microsoft 365 (Word, Excel, PowerPoint, Outlook, OneDrive, Teams, etc.)
• Google Sheets (Apps Script, ARRAYFORMULA, QUERY, and automation tools)
• Zapier or Make (for light automation and integrations)
• Bonus: Airtable, Notion, or BI tools (e.g., Looker Studio)
________________________________________

Requirements
• Excellent English communication skills
• Minimum 3 years experience in a data-heavy, Excel-centric role
• Strong portfolio of past work (dashboards, reports, automations, models, or spreadsheet tools)
• Comfortable working independently and in collaboration with a founder
• Bachelor’s degree preferred but not required with equivalent experience
________________________________________

Working Hours & Setup
• Part-time to full-time depending on fit
• Must be able to join a weekly sync call (ET timezone)
• Long-term growth role — we want someone to evolve with the business
• 100% remote

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0011
Controller Execution Time ( Jobseekers / Job )  0.0146
Total Execution Time  0.0164
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,536,872 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Excel-Data-Architect-1363820
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0069 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1363820
 LIMIT 1 
0.0003   SELECT *
FROM `employers`
WHERE `employer_id` = 629748
 LIMIT 1 
0.0004   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1363820
AND `misc`.`idIS NULL 
0.0004   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-19',ej.date_added) duration_daysDATEDIFF('2026-04-19',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_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-04-19',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1363820' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1363820 
0.0019   UPDATE employer_jobs SET hit_counts '***Apr-25-2025=156***Apr-26-2025=78***Apr-27-2025=52***Apr-28-2025=69***Apr-29-2025=37***Apr-30-2025=26***May-01-2025=19***May-02-2025=24***May-03-2025=10***May-04-2025=8***May-05-2025=21***May-06-2025=9***May-07-2025=7***May-08-2025=6***May-09-2025=4***May-11-2025=6***May-12-2025=6***May-13-2025=2***May-14-2025=5***May-15-2025=5***May-16-2025=3***May-17-2025=3***May-18-2025=1***May-19-2025=5***May-20-2025=7***May-21-2025=3***May-22-2025=6***May-23-2025=12***May-24-2025=2***May-25-2025=5***May-26-2025=4***May-27-2025=5***May-28-2025=4***May-29-2025=1***May-30-2025=2***May-31-2025=3***Jun-02-2025=3***Jun-03-2025=1***Jun-04-2025=1***Jun-05-2025=1***Jun-06-2025=3***Jun-07-2025=1***Jun-08-2025=3***Jun-09-2025=2***Jun-10-2025=1***Jun-11-2025=2***Jun-12-2025=1***Jun-14-2025=2***Jun-15-2025=3***Jun-16-2025=4***Jun-17-2025=3***Jun-18-2025=5***Jun-19-2025=3***Jun-21-2025=7***Jun-23-2025=5***Jun-24-2025=1***Jun-25-2025=1***Jun-26-2025=3***Jun-27-2025=6***Jun-28-2025=7***Jun-29-2025=1***Jul-01-2025=2***Jul-03-2025=4***Jul-04-2025=2***Jul-05-2025=2***Jul-07-2025=2***Jul-08-2025=3***Jul-09-2025=1***Jul-10-2025=2***Jul-11-2025=1***Jul-12-2025=4***Jul-14-2025=1***Jul-15-2025=5***Jul-16-2025=3***Jul-18-2025=1***Jul-19-2025=3***Jul-20-2025=1***Jul-22-2025=4***Jul-23-2025=1***Jul-24-2025=5***Jul-27-2025=1***Jul-28-2025=4***Jul-29-2025=2***Jul-30-2025=1***Jul-31-2025=1***Aug-01-2025=2***Aug-02-2025=3***Aug-03-2025=1***Aug-05-2025=2***Aug-06-2025=4***Aug-08-2025=3***Aug-09-2025=1***Aug-10-2025=1***Aug-11-2025=2***Aug-12-2025=3***Aug-13-2025=2***Aug-14-2025=1***Aug-15-2025=1***Aug-17-2025=1***Aug-18-2025=3***Aug-19-2025=1***Aug-20-2025=1***Aug-21-2025=1***Aug-22-2025=1***Aug-23-2025=4***Aug-24-2025=1***Aug-25-2025=1***Aug-26-2025=1***Aug-27-2025=3***Aug-28-2025=4***Aug-30-2025=1***Sep-01-2025=2***Sep-02-2025=3***Sep-04-2025=1***Sep-05-2025=3***Sep-06-2025=4***Sep-07-2025=2***Sep-09-2025=1***Sep-10-2025=3***Sep-11-2025=1***Sep-12-2025=2***Sep-13-2025=1***Sep-14-2025=1***Sep-15-2025=4***Sep-16-2025=1***Sep-17-2025=4***Sep-18-2025=2***Sep-19-2025=2***Sep-21-2025=1***Sep-22-2025=1***Sep-23-2025=1***Sep-24-2025=2***Sep-25-2025=2***Sep-26-2025=1***Sep-27-2025=1***Sep-28-2025=1***Sep-29-2025=4***Sep-30-2025=2***Oct-01-2025=2***Oct-02-2025=5***Oct-03-2025=4***Oct-04-2025=5***Oct-05-2025=7***Oct-06-2025=2***Oct-07-2025=1***Oct-08-2025=4***Oct-09-2025=4***Oct-10-2025=9***Oct-11-2025=5***Oct-12-2025=1***Oct-13-2025=8***Oct-14-2025=5***Oct-15-2025=13***Oct-16-2025=5***Oct-17-2025=8***Oct-18-2025=4***Oct-20-2025=4***Oct-21-2025=6***Oct-22-2025=5***Oct-23-2025=3***Oct-24-2025=6***Oct-27-2025=7***Oct-28-2025=9***Oct-29-2025=7***Oct-30-2025=5***Oct-31-2025=3***Nov-01-2025=2***Nov-03-2025=2***Nov-05-2025=5***Nov-06-2025=2***Nov-07-2025=1***Nov-08-2025=1***Nov-09-2025=2***Nov-10-2025=3***Nov-12-2025=10***Nov-13-2025=7***Nov-14-2025=5***Nov-15-2025=1***Nov-16-2025=1***Nov-17-2025=1***Nov-18-2025=3***Nov-19-2025=4***Nov-20-2025=2***Nov-21-2025=6***Nov-22-2025=5***Nov-23-2025=4***Nov-24-2025=1***Nov-25-2025=1***Nov-26-2025=3***Nov-27-2025=3***Nov-28-2025=9***Nov-30-2025=1***Dec-01-2025=2***Dec-02-2025=7***Dec-03-2025=4***Dec-04-2025=5***Dec-05-2025=2***Dec-06-2025=3***Dec-07-2025=1***Dec-08-2025=1***Dec-09-2025=1***Dec-10-2025=5***Dec-11-2025=2***Dec-12-2025=1***Dec-13-2025=1***Dec-14-2025=3***Dec-15-2025=1***Dec-16-2025=3***Dec-17-2025=1***Dec-19-2025=5***Dec-20-2025=1***Dec-21-2025=1***Dec-22-2025=2***Dec-23-2025=3***Dec-24-2025=2***Dec-25-2025=1***Dec-26-2025=2***Dec-27-2025=1***Dec-28-2025=3***Dec-30-2025=1***Dec-31-2025=1***Jan-01-2026=4***Jan-02-2026=1***Jan-03-2026=1***Jan-04-2026=2***Jan-05-2026=4***Jan-06-2026=1***Jan-07-2026=2***Jan-08-2026=2***Jan-09-2026=4***Jan-10-2026=1***Jan-11-2026=1***Jan-13-2026=1***Jan-14-2026=2***Jan-15-2026=2***Jan-16-2026=1***Jan-17-2026=2***Jan-19-2026=3***Jan-20-2026=3***Jan-21-2026=1***Jan-22-2026=1***Jan-26-2026=2***Jan-27-2026=3***Jan-28-2026=2***Jan-29-2026=3***Jan-30-2026=1***Jan-31-2026=2***Feb-01-2026=1***Feb-02-2026=2***Feb-04-2026=2***Feb-07-2026=1***Feb-09-2026=1***Feb-11-2026=1***Feb-18-2026=6***Feb-19-2026=4***Feb-20-2026=2***Feb-21-2026=3***Feb-22-2026=3***Feb-24-2026=1***Feb-27-2026=1***Mar-01-2026=2***Mar-04-2026=1***Mar-06-2026=2***Mar-10-2026=1***Mar-15-2026=2***Mar-17-2026=2***Mar-19-2026=1***Mar-20-2026=3***Mar-21-2026=1***Mar-25-2026=1***Mar-26-2026=2***Mar-27-2026=1***Mar-30-2026=2***Apr-01-2026=1***Apr-08-2026=1***Apr-11-2026=1***Apr-13-2026=2***Apr-14-2026=1***Apr-15-2026=3***Apr-19-2026=2' WHERE job_id'1363820'  
0.0007   UPDATE employer_jobs SET monthly_hits '***Apr-2025=418***May-2025=198***Jun-2025=70***Jul-2025=56***Aug-2025=49***Sep-2025=53***Oct-2025=147***Nov-2025=85***Dec-2025=66***Jan-2026=52***Feb-2026=28***Mar-2026=21***Apr-2026=11' WHERE job_id'1363820'  
0.0003   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1363820' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1363820 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '629748'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0008   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)