ServiceNow & Excel Reporting Analyst

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

TYPE OF WORK

Part Time

SALARY

5/hr

HOURS PER WEEK

10

DATE UPDATED

Jul 8, 2026

JOB OVERVIEW

Core Responsibilities
• Perform data extraction, filtering, and lookups in Microsoft Excel to support recurring reporting needs.
• Use XLOOKUP (and related functions such as INDEX/MATCH, FILTER) to consolidate and cross-reference data across multiple sources.
• Extract records and reports from ServiceNow, including navigating the CMDB using breadcrumbs and filters to locate relevant configuration items.
• Save and reuse ServiceNow queries/filters for recurring or future requests.
• Populate email templates using extracted data, ensuring accuracy and consistency before send.
• Draft and send routine communications based on data triggers or scheduled cadences.
• Flag data discrepancies, missing records, or anomalies for review.

Required Qualifications
Must Have:
• In-depth working knowledge of Microsoft Office, specifically Excel.
• Demonstrated ability to filter datasets and build/use XLOOKUP formulas accurately.
• Working knowledge of ServiceNow, including report extraction and CMDB navigation via breadcrumbs and filters.
• Ability to save, organize, and re-run queries for repeat use.
• Strong attention to detail and comfort working with sensitive or operational data.
Preferred / Nice to Have:
• Ability to write and maintain VBA scripts to automate repetitive Excel tasks.
• Experience automating message generation or notifications (e.g., mail merge, scripted email drafts).
• Prior experience supporting IT operations, service desk, or asset management functions.


Communication & Reporting
• Preferred communication channel: [Text / Email / Voice]
• Standing meeting cadence: Daily check-in (15 min) to review priorities, in-progress requests, and blockers.
• Weekly recap meeting: to review completed deliverables, open queries, and upcoming needs
• Ad hoc calls as needed for new or complex requests



Growth Opportunity
• Starting rate: $5.00 / hour.
• At the 3-month mark, rate increases to $7.00 / hour, contingent on satisfactory performance and consistent delivery against the responsibilities outlined in this SOW.
• At the 6-month mark, rate and scope will be reviewed together to determine next steps (continued increase, expanded hours, or expanded responsibilities).


Confidentiality
The Contractor agrees to treat all data accessed through ServiceNow, Excel files, or related systems as confidential, and will not share, export, or retain data outside the scope of this engagement without written permission.

Application Instructions:
• Please include the word "SNOW" in your application title.
• Looking for at least 30 AP, 50 AP preferable.
• Please fill out this form:
----------

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Jobseekers / Job )  0.0097
Total Execution Time  0.0113
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,501,328 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/ServiceNow-Excel-Reporting-Analyst-1685167
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0047 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1685167
 LIMIT 1 
0.0004   SELECT *
FROM `employers`
WHERE `employer_id` = 941816
 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` = 1685167
AND `misc`.`idIS NULL 
0.0004   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-07-28',ej.date_added) duration_daysDATEDIFF('2026-07-28',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-07-28',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1685167' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1685167 
0.0006   UPDATE employer_jobs SET hit_counts '***Jul-08-2026=292***Jul-09-2026=86***Jul-10-2026=55***Jul-11-2026=25***Jul-12-2026=37***Jul-13-2026=54***Jul-14-2026=47***Jul-15-2026=25***Jul-16-2026=16***Jul-17-2026=23***Jul-18-2026=11***Jul-19-2026=9***Jul-20-2026=9***Jul-21-2026=10***Jul-22-2026=18***Jul-23-2026=10***Jul-24-2026=12***Jul-25-2026=12***Jul-28-2026=2' WHERE job_id'1685167'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Jul-2026=752' WHERE job_id'1685167'  
0.0004   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1685167' 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` = 1685167 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '941816'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0002   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)