NHQ:HSO - SQA - Business Operations Specialist

NHQ:HSO - SQA - Business Operations Specialist

This position supports the National Headquarters (NHQ) Humanitarian Services Operations (HSO) department. The Business Operations Specialist will support the HSO Quality Assurance (QA) team and project lead with project related tasks, allowing the HSO QA team to produce projects more quickly and efficiently and introduce additional projects.

Apply Now

Locations

Alcona County,Alger County,Allegan County ,Alpena County,Ann Arbor Office,Ann Arbor VA Medical Center,Antrim County,Arenac County,Baraga County,Barry County,Battle Creek Air National Guard Base,Battle Creek VA Medical Center,Bay County,Benzie County,Berrien County,Branch County,Calhoun County,Cass County,Charlevoix County,Cheboygan County,Chippewa County,Clare County,Clinton County,Crawford County,Detroit Military Entrance Processing Station (MEPS),East Central Bay Chapter ,East Central Bay Chapter Office,Eaton County,Emmet County,Galdwin County,Galdwin County,Genesse County,Grand Traverse County,Gratiot County,Gratiot County Office (Alma),Hillsdale County,Huron County,Ingham County,Ionia County,Iosco County,Isabella County,Jackson County,Jackson County Office,John D. Dingell Detroit VA Medical Center,Kalamazoo County,Kalkaska County,Kent County,Lake County,Lansing Military Entrance Processing Station (MEPS),Lapeer County,Leelanau County,Lenawee County,Livingston County,Livingston County Office,Luce County,Mackinac County,Macomb County,Manistee County,Marquette County,Mason County,Mecosta County,Mid-Michigan Chapter ,Mid-Michigan Chapter Office,Midland County,Missaukee County,Montcalm County,Montmorency County,Muskegon County,Muskegon VA Clinic,Newaygo County,Northern Michigan Chapter,Northern Michigan Chapter Office,Oakland County,Oceana County,Ogemaw County ,Osceola County,Oscoda County,Otsego County,Otsego County Office (Gaylord),Ottawa County,Presque Isle County,Regional ,Remote/Virtual Volunteer Opportunity,Roscommon County,Saginaw County,Saginaw VA Medical Center,Sanilac County,Schoolcraft County,Selfridge Air National Guard Base,Shiawassee County ,Shiawassee County Office,Southeast Michigan Chapter,Southeast Michigan Chapter Office,Southwest Michigan Chapter,Southwest Michigan Chapter Office,St. Clair County,St. Joseph County,Tuscola County,Van Buren County,Washtenaw County,Wayne County,West Michigan Chapter ,West Michigan Chapter Office,Wexford County,Wyoming VA Clinic

Key Responsibilities

Work with the project lead to complete project tasks which include:

  • Conduct data analysis and comparisons in Excel spreadsheets
  • Track all work in shared Excel spreadsheets
  • Collect and enter data into Excel and verify data validity
  • Maintain contact lists in excel and conduct mail merges to create personalized forms in Word and Adobe Acrobat Pro.
  • Access SharePoint to upload, file and maintain electronic documents in SharePoint folders

Qualifications

Required:

  • Advanced Microsoft Word experience, such as: Design and create forms and templates Use mail merge to create personalized forms, letters and emails.
  • Create and manage bookmarks, hyperlinks, footnotes, endnotes and a table of contents.
  • Advanced Excel experience, such as: Use lookup functions (VLOOKUP, INDEX + MATCH)
  • Use various other functions: Logical functions (IF, IFNA, IF ERROR) Text functions (LEFT, RIGHT, EXACT, CONCAT, TRIM) Math functions (SUMIFS, COUNTIFS, SUMPRODUCT) Text-to-Columns, Trace Cells, Evaluate formulas Conditional Formatting, Remove Duplicates, Find & Replace
  • Create, analyze Pivot Table data, present data with pivot charts, filter using timelines and slicers Use Power Query to import data from multiple sources, clean/shape data.
  • Use Pivot Table and/or PowerPivot for data analysis Experience using SharePoint and Adobe Pro
  • Experience handling confidential/sensitive data and information 
  • Attention to detail and accuracy
  • Willingness to learn
  • Works well individually and with others

Training

On the job training Orientation to the American Red Cross

Development Opportunities

Learn more about Humanitarian Services Operations Be part of a team

Length of Appointment

Minimum 6 months commitment

Time Commitment

3-4 hours per week during business hours

Apply Now