Randstad Cash Reconciliation Analyst / Excel Analyst in Jupiter, Florida
Cash Reconciliation Analyst / Excel Analyst
salary:$50,000 - $65,000 per year
date posted:Wednesday, July 10, 2019
Cash Reconciliation Analyst / Excel Analyst
We have an opening on our team of Analysts at our company located in Jupiter. We are the world's largest security and loss prevention company and inside our retail solutions division, we are looking for a person to handle the daily cash reconciliation analysis that we have to perform in between our retail clients and the banks and armored truck transports. Cash deposits to/from customers to armored transport and banks can result in differences which must be reconciled on a daily basis and tracked for important information. A secondary function would include ordering cash for our retail customers so that they are well-stocked for the entire day's worth of purchases and transactions from their customers. This position is very EXCEL HEAVY. Knowledge of EXCEL and pivot tables, V-Lookups, running reports and queries is a daily part of the job.
Positions that transfer well into ours include: A/P and A/R, Financial Analysts, Business Analysts, Reconciliation Analysts or a profession that utilizes the EXCEL skill we currently need.
FULL-TIME HOURS. May have to rotate one Saturday per month for about 4 hours to release cash orders or reports
FULL BENEFITS PACKAGE.....MEDICAL, DENTAL , VISION, PTO, MATCHING 401K
Investigate and provide resolution to cash deposit differences between customers, banks and armored transport providers.
Provide in-depth reconciliation analysis with Banks/transport providers/Customers
Provide first level analysis of supporting documents/ data. Ability to escalate appropriately to senior management.
Observe trends/patterns and investigate for root-cause. Recommend solutions.
Provide followup to bring items to resolution.
Provide professional communication, organize and hold meetings to resolve.
Secondarily, forecast Cash usage of retail clients. Trouble-shoot issues and respond to customer inquiries.
Create, affect or implement standard policies or practices
Assist in other inventory management or reconciliation activities and analysis as needed.
Participate with our team in support of new customer/project installations and performance troubleshooting.
Working hours: 8:00 AM - 5:00 PM
THIS JOB WILL REQUIRE VERY PRECISE AND ADVANCED EXCEL KNOWLEDGE SUCH AS V-LOOKUPS, PIVOT TABLES, FORMULAS, QUERIES, AND GENERATING REPORTS FROM EXCEL
--Good oral, written and analytical skills
--Ability to analyze statistics and forecast cash usage of retail clients
--Ability to reconcile cash management accounts
--A great communicator and polished verbal and written skills
-- Formulate, affect, interpret, or implement management policies or operating practices; create standard operating practices for the management of cash inventory for our retail customers to include Cash ordering
levels, reconciliation of balances and reconcile process/practices with the Banks
--Provide communications with the Banks for resolution of variances or process improvements.
--Investigate and provide resolution to cash deposit differences between customer and armored transport providers
--Represent the company in disputes with Banks and Third Party armored carriers to resolve disputes in balancing of financial results
* We prefer a Bachelor's Degree or he equivalent experience in a related industry *
Good business acumen, financial or accounting experience (1 year) or educational background (some courses) in these subjects.
Prior work experience reconciling (general ledger) accounts, analyzing out-of-balance conditions/data, and explaining variances.
Work history should include demonstration of the ability to communicating effectively with various employee levels, from entry-level to senior management or educational background in presentations or white papers.
Our company Requires in-depth multi-state criminal background checks and a 10-panel drug test prior to being placed. We require a 100% clear background to be able to be considered for employment.
Randstad is a world leader in matching great people with great companies. Our experienced agents will listen carefully to your employment needs and then work diligently to match your skills and qualifications to the right job and company. Whether you're looking for temporary, temporary-to-permanent or permanent opportunities, no one works harder for you than Randstad. EEO Employer: Race, Religion, Color, National Origin, Citizenship, Sex, Sexual Orientation, Gender Identity, Age, Disability, Ancestry, Veteran Status, Genetic Information, Service in the Uniformed Services or any other classification protected by law.