Merchant Services Data Analyst

Hello,

My name is Molly, and I am a Talent Acquisition Consultant with The Fountain Group. We are a national staffing firm with an array of Fortune 500 clients and are currently seeking a Merchant Services Data Analyst for a prominent and well-known Food Delivery client of ours. This position is Remote. Details for the position are as follows:

• Building and maintaining inventory catalogs for grocery, retail, and other non-Rx merchants (gift shops, florists, liquor stores, etc.)
• Onboarding new merchants with correct features and providing ongoing support
• Shaping processes for catalog launches and updates

• entry level candidates or individuals with strong data analytics experience (required)
• Inventory or supply chain data experience / internships / certifications / degrees - etc. (preferred)
• Strong Excel/Sheets proficiency (required)

• Self-motivated and thrive as independent contributors while valuing team collaboration
• Passionate about projects and take ownership from start to finish
• Skilled in Google Sheets/Excel formulas and comfortable handling large datasets
• Comfortable working cross-functionally
• Committed to building and supporting a trusting team culture

• Highlight Excel/Sheets experience
• Include any inventory data experience

• Job Title: Merchant Services Support Specialist, New Verticals
• Location: Fully Remote (US Only)
• Duration: 3-months (strong potential for extension)
• Pay: $20.28/hour (W2 Only)

• Work directly with one of the company s newest products
• Shape the success metrics of the New Verticals Specialist role
• Influence multiple processes and initiatives
• Collaborate cross-functionally across teams

• Prepare and organize large amounts of inventory data for catalog launch or updates
• Own and collaborate on catalog building, updating, and process improvement
• Become an expert in grocery product taxonomy to optimize the shopping experience
• Provide input to improve and refine processes
• Assist in planning and scoping for upcoming New Verticals initiatives

Assessment Required For Submission:

Once we connect via phone / I will send you the google sheets link for your assessment! Here is a sneak peek below! This should only take 15-20 mins!

Please include the Google link on the resume for manager to view when reviewing. (I will add that in once you are finished. Please email me the google sheets link back to me upon completion!)

Instructions for Both Assessments (2 Tabs):

1. Create a copy of the document. - I will send this to you personally as mentioned above!
2. Once completed, email me back the Google link so I can add it into your resume for manager review.

Question

Answer:

1) Using the format drop down, structure column B, D & F of the Pizza tab to be in currency format ($0.00)

2) Using the Pizza Tab, what formula would you use to determine how much an X-Large New York style Buffalo chicken costs? How much is it?

3) Using the Pizza tab, what formula would you use to determine how much a personal, Cauliflower Crust, Veggie Madness Pizza would be? How much is it?

4) Create a new tab and name it "Pizza Selection." Copy the values from column A of the Pizza tab (Pizza Type) into this new tab. Set up a data validation (dropdown) in column B for "Size" using the values from column C of the Pizza tab. Similarly, create a data validation in column C for "Crust Type" using the values from column E of the Pizza tab.

5) In Column D of the Pizza Selection Tab match in the descriptions from the "Pizza Descriptions" tab using a formula with column A as your anchor column. Do not copy paste in formulas to show only values, must show work

Pizza Menu

Pizza Descriptions

Pizza Type:

Cost:

Size:

additional size cost

Crust Type

Crust Cost

Pizza Type:

Pepperoni

12

Personal

4

Cauliflower (Personal & Small Only)

2

Pepperoni

Robust Tomato Sauce & Thick Sliced Pepperonis

Sausage

13

Small

0

New York Style

1

Sausage

Robust Tomato Sauce & Spicy Italian Sausage Pieces

Cheese

12

Medium

2

Thin Crust

0

Cheese

Robust Tomato Sauce, Our Blend of House Spices & Mozzarella

Mega Meat

15

Large

4

Hand Tossed

0

Mega Meat

Pepperoni, Ham, Meatball, Bacon & Sausage

Buffalo Chicken

15

X-Large

6

Buffalo Chicken

BBQ Sauce, Chicken, Mozzarella & Cheddar Cheese

Hawaiian

15

Hawaiian

Teriyaki Sauce, Chicken, Pineapple, Mozzarella & Cheddar Cheese

Supreme

14

Supreme

Pepperoni, Ham, Mushroom, Green Pepper & Onion

White Pizza

13

White Pizza

Brushed with Oil, Fresh Garlic, Italian Seasoning, Parmesan, Mozzarella, Ricotta Cheese & Tomato

Veggie Madness

15

Veggie Madness

Mushroom, Onion, Green Pepper, Black Olive, Feta & Tomato